Index syndication
comment syndication

Archive for Musings

Server Migration complete

I’ve had an on/off outage for most of the past 4 days, so to avoid hassles I put the site into maintenance mode.

I’ve actually had to decommission my 19″ server rack and the multiple servers I had for Tech Debug. There was a DNS server, kerberos, Database and web server. All the separate functions are now hosted on one OpenBSD VM that I’ve built recently. It’s running on the only remaining “non-laptop” left in my residence, which runs 24×7.

The only delay in getting back online in the last 48 hours was the MySQL data export and import. It’s a bit convoluted, and not documented in entirely one place on the MySQL documentation site (backup here, restore here), however once done once it will be easy to repeat. I still like the simplicity of PostgreSQL administration. Specifically the backup and restore:

pg_dumpall > savefile.dump
psql -f savefile.dump postgres

Well, there are some prep steps you should do; but it is all in one place on their documentation page.

Let me know how the site performs on the VM.

More Work?

Zug Zug. Thanks to roirevolution for the image

I’m not posting much these days since I’m currently heavily involved in a current development and build effort for a Client. (Solaris platform with Oracle 10g)

All other hours are either commuting, sleeping or playing WoW. Look forward to a number of upcoming posts on Dansguardian SQL logging, OpenBSD and of course Apple and the iPhone.

Zug Zug…. you WC3 fans will know what I mean.


Little Brother

I just started reading Cory Doctorow’s Little Brother using one of his ebooks he has relesed under the Creative Commons license.
I have to admit that I had never heard of Cory of BoingBoing fame, or his books until I read about them via CelticBear.

As a ‘paranoid’ geeked I’m hooked on Little Brother, and if you like tech, geek and drama you should check it out as well.

Update: I went to buy a copy from a local bookstore, but it is not released in Australia yet. You can read the ebook or buy it from amazon.

Coral Content Distributed network

Have you ever had your website hit on a topic that people find conflicting? When the site gets viewed by the masses, you need to be prepared. If you have access to modify your web server .htaccess file then go and have a read of the Coral CDN Overview
For those interested in the techie bits, here is my .htaccess for news site flood protection, and to allow CDN to serve up all my site images – thus offloading from my puny connection the bandwidth burden for images.

RewriteEngine On
#prevent slashdot effect
RewriteCond %{HTTP_USER_AGENT} !^CoralWebPrx
RewriteCond %{HTTP_REFERER} blogspot\.com [NC,OR]
RewriteCond %{HTTP_REFERER} reddit\.com [NC,OR]
RewriteCond %{HTTP_REFERER} digg\.com [NC,OR]
RewriteCond %{HTTP_REFERER} news\.slashdot\.org [NC,OR]
RewriteCond %{HTTP_REFERER} slashdot\.org
RewriteRule ^(.*)$$1 [R,L]
#Rewrite images to allow CDN to serve them
RewriteCond %{HTTP_USER_AGENT} !^CoralWebPrx
RewriteRule ^(.*)/(.*\.(gif|png|jpe?g))$$1/$2 [R,L]
#Wordpress rewites
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

mod_rewrite is your friend.

« Previous entries · Next entries »