April 2009

You are browsing the archive for April 2009.

MySQL Tuning

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 [...]

Holding Out for a [MySQL] Hero

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 [...]

Don't Forget to Bounce Sendmail

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 [...]

My Anal Retentiveness

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 [...]

Now Running FeedBurner

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}
RewriteRule ^/barneyblog/(feed(/atom|/rss)?/?|wp-rss2?.php)$


Why [...]

GoodBye Misbehaving Spiders

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 [...]

Unindex Search Plugin

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:
Plugin Name: Unindex Search
Plugin URI: http://www.barneyb.com/
Description: Addes a NOINDEX meta tag [...]

I Love Apache

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 [...]

Back Up

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 [...]

I'm Going Down

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 [...]