Triggers Woo!

So while nothing appears different on the site, I thought I would try my hand at creating some TRIGGERS in place of some application level logic for the site. Specifically, the number of comments on each blog post is actually stored in the main BlogPosts table. That way, there is …

Certified MySQL 5.0 DBA FTW!

So today I finished the MySQL DBA II exam and passed, which now makes me (or will make me soon) a certified MySQL 5.0 DBA. Wh00h00! I have to admit, the day started out kinda meh, but it just keeps getting better. Dan got me lunch (thanks Dan!) to celebrate …

Of Suns and…Dolphins?

Alright so I thought I might throw my $0.02 into the whole fanfare about Sun acquiring MySQL. I think it was a surprising but good move. Sun has a lot to provide, is likely looking to strengthen their platform, and appears to be committed to open source. While it remains …

Recent Outages

My server has had quite a wild ride and it has taken some time to get back up to speed. Basically, earlier this week, I put in a maintenance to replace what appeared to be a failing CPU or bad RAM. Turns out there was more busted that I thought …