By barneyb on April 30, 2009
While tuning my new server, I came across an article on MySQL tuning that does a really great job of laying out the main options that need to be tweaked, as well as explaining what they do. It's several years old, but still applicable. Also worth mentioning that MySQL ships with four "sample" configuration files [...]
Posted in database
By barneyb on April 27, 2009
I've been fighting this god-forsaken query for a week, and can come up with absolutely no explaination for its behaviour. Next time I see you, I'll buy you a beer if you can help me understand what's going on. There are two tables involved, and here are their CREATE statements:
CREATE TABLE `sequence` ( — contains [...]
Posted in database
By barneyb on April 26, 2009
When you change the hostname of your computer, you need to do two things: add a local alias to Sendmail's config and restart sendmail. I'm pretty sure I've forgotten step two every time I've set up a new box, and my new server was no exception. Fortunately, I finally remembered that that was the problem [...]
Posted in aside
By barneyb on April 24, 2009
I hate what stuff breaks. I'll admit to punting on occasion, but I really do try to avoid that whenever possible. While doing the FeedBurner stuff I went looking for site references, and found one on ColdFusion Bloggers that was quite interesting. I'm one of the aggregated feeds, as you'd probably imagine, and have been [...]
Posted in meta, personal
By barneyb on April 24, 2009
I set up FeedBurner for my main blog XML feed this afternoon. Pretty painless, and it appears that everything is all hunky-dory. However I figured I'd mention it in case there are problems so you'll know why.
Here's the Apache config I used (wrapped for readability):
RewriteCond %{HTTP_USER_AGENT}
!FeedBurner
[NC]
RewriteRule ^/barneyblog/(feed(/atom|/rss)?/?|wp-rss2?.php)$
http://feeds2.feedburner.com/barneyblog/
[P,L]
Why [...]
Posted in meta
By barneyb on April 23, 2009
Alright, all you misbehaving spiders that don't flush your DNS cache (I'm looking at you Yahoo! Slurp and Adobe Feeds), I'm killing my old box today. So while currently you're transparently proxying through to the new one because you won't respect my TTLs in DNS, that's gonna stop. Here's the list of user agents that [...]
Posted in meta
By barneyb on April 22, 2009
Even though I use Google Custom Search for my blog, I get a lot of WordPress's internal search results pages indexed by robots. Didn't want that to happen anymore, so I wrote a simple plugin to address the issue. Maybe someone will find it useful:
<?php
/*
Plugin Name: Unindex Search
Plugin URI: http://www.barneyb.com/
Description: Addes a NOINDEX meta tag [...]
Posted in meta, wordpress
By barneyb on April 21, 2009
So after I got my new server online, I wanted to deal with my oversight on DSN TTLs. Not surprisingly, mod_rewrite saved the day again. First, since my old server is subject to the same TTLs, I added a record in my /etc/hosts file to point all of them at the new IP. Then I [...]
Posted in meta, tools
By barneyb on April 21, 2009
Back alive again. Pretty smooth, considering I'd done zero prep, and didn't even have ColdFusion or PHP installed 90 minutes before killing my Apache. I'm sure there will be all kinds of random little issues, but hopefully they're minimal since I by and large just rsynced everything across the wire. I did manage to do [...]
Posted in meta
By barneyb on April 21, 2009
And not the good kind. In an hour or so I'm shutting this server down and migrating to another. Routing issues continue, and no resolution. Hopefully I'll be offline for 15-20 minutes, but who knows. I'm going totally blind because I really don't have any other options. See you on [...]
Posted in meta