Browse: Home / 2009 / April

April 2009

You are browsing the archive for April 2009.

MySQL Tuning

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

Holding Out for a [MySQL] Hero

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

Don't Forget to Bounce Sendmail

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

My Anal Retentiveness

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 ,

Now Running FeedBurner

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

GoodBye Misbehaving Spiders

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

Unindex Search Plugin

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 ,

I Love Apache

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 ,

Back Up

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

I'm Going Down

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

Next »