May
2
2011

If you came here between April 28 and about an hour ago, you got a “couldn’t connect to database” error. Oops! Seems my limited memory EC2 instance got a little overwhelmed by php processes and decided the db server, drizzled, should die to make more room for PHP. Ooops! Time to drop pm.max_children.
I don’t have any monitoring setup for the site, so I just now figured it out. Until I get proper monitoring, I’ve installed this fancy bit of duct-tape upstart magic:
start on stopping
task
script
env | mail -s "$JOB is stopping!" me@myemail.com
end script
What does this do? Well is emails me whenever upstart gives up respawning something, or I manually stop a service.
Its not monitoring. I need monitoring. But this is a nice little hack to prevent a regression while I figure that out.
5 comments | tags: drizzle, PHP, ubuntu, upstart | posted in Cloud
Apr
27
2011
Or, for short, the “2011 O’Reilly MySQL Users Conference & Expo”. Yes thats the short name of the conference that, thus far, has brought me nothing but good info, good times, and insight into one of the most interesting open source communities around.
MySQL has been at the core of a real revolution in the way data driven applications have exploded on the internet. Its so easy to just install it, fire up php’s mysql driver, and boom, you’re saving and retrieving data. The *use* of MySQL has always been incredibly simple.
The politics has, at times, been confusing. Continue reading
no comments | tags: cloud, drizzle, MySQL, mysqlconf, percona, ubuntu | posted in Drizzle, MySQL
Apr
21
2011
HTTP JSON AlsoSQL interface to Drizzle | Ramblings. – This is what I’m talking about when I say Drizzle will be for HTTP what Apache was for MySQL. Its hyper flexible and quite performant. Stewart is a quite gifted programmer, but look how easy it was to integrate a JSON library and libevent into the server on a whim.
As a sysadmin with LAMP shops, I always had to stop innovating around the MySQL part of it. Linux I could hack on, apache I could hack on, and PHP/Perl/Python were built to be hacked on. But MySQL was always difficult beyond a few clever UDF’s.
I’m waiting for somewhere to adopt Drizzle and really start running wild with the plugins. Should be interesting!
3 comments | tags: drizzle, lamp, plugins | posted in Drizzle
Apr
15
2011
Ubuntu and Drizzle — Run Drizzle on your Narwhal: OReilly MySQL Conference & Expo 2011 – OReilly Conferences, April 11 – 14, 2011, Santa Clara, CA.
I gave a talk this week in Santa Clara at the MySQL Users Conference. I think it went pretty well and I got a lot of feedback from Ubuntu users about the positives of having Drizzle available in Universe.The slides are available at the link above.
no comments | tags: conference, drizzle, ubuntu | posted in Drizzle, MySQL, Ubuntu
Apr
13
2011
Since we’re just about to 11.04 beta2, I figured its high time I start using Ubuntu Server for my personal blog.
What? Almost a year at Canonical and my blog wasn’t on Ubuntu server? Well, for over 5 years now, a personal friend has provided me with a free Xen virtual machine to run my blog on. I migrated it off of Debian then, which was sad for me, but back then I was so focused on working I didn’t have time or resources to be picky, so I said OK.
Fast forward to now, I’ve been working on Ubuntu Server and getting ribbed by my co-workers about that “crappy CentOS xen box” they’d see me logged into.
Well thats all over now. I decided to marry all the new tech I’ve been playing with lately into one glorious blog migration. Continue reading
6 comments | tags: cloud, drizzle, ec2, natty, ubuntu | posted in Cloud, Ubuntu