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.
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. Read more »
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!
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.
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. Read more »
I’ve begun a migration of fewbar.com to a new box.. more details to follow… the site may be a little weird for about 1 hour while DNS propagates.
Words do not do it justice.. LITERALLY
Last week, my application to join the ranks of Core Ubuntu Developers was accepted by the Ubuntu Developer Membership Board. The process is a bit humbling, as when you dig through the roster of this team, there aren’t a lot of names, and most of them are quite familiar to anyone who has done Ubuntu Development, as they fly by in bug reports and changelogs at an almost superhuman pace, fixing, improving, and generally making Ubuntu more awesome-r.
So, a few hours ago, I made my first direct upload into Ubuntu without a sponsor. Its just a little upgrade to squid’s upstart job to make it start more reliably. I hope its the beginning of a string of uploads that will continue for a long time, and help me earn the badge that I’ve been granted.
Many thanks to all of my sponsors up to this point, and a special nod to those who were able to add a positive comment to my developer application.
Handlersocket is what all the cool kids are using these days.. I think. Basically you get a couple of new ports on your mysql server that allow SQL-free reading and writing for doing many thousands of tiny transactions per second without the overhead of parsing SQL.
Thanks to my venerable Ubuntu sponsor, Chuck Short, handlersocket is now available in Ubuntu Natty in the universe repository. apt-get install handlersocket-mysql-5.1 handlersocket-doc, then follow the instructions in /usr/share/doc/handlersocket-doc/docs-en to enable it, and you have yourself a bonified NoSQL solution for your MySQL server.
There are also client libraries for perl (libnet-handlersocket-perl) and C/C++ (libhsclient-dev .. static only as the API is in flux). Other languages are still not packaged, but the protocol is simple, and links to early implementations are listed in the README file, which should be at /usr/share/doc/handlersocket-mysql-5.1/README.
It should be on Debian unstable as well soon…
Update April 3 2011, Handlersocket is now in Debian Unstable as well
Happy hacking!
Thats right, my boss. 
Canonical Server Team manager and all around Canonical Stud Robbie Williamson lays out the plan, past, present, and future…
It’s Been a Crazy Year « Not Lucky All The Time, But Smart Everyday….
