Unless your in the desert under a rock (where rain is clearly needed), you will have heard of Drizzle - A Lightweight SQL Database for Cloud and Web. My company 42SQL is sponsoring the BuildBot for the Drizzle project. BuildBot is a system to automate the compile/test cycle required by most software projects to validate code changes.

Check out Installing Buildbot for what’s necessary to get a working installation. This is necessary for the Master and Slaves.

Configuration was a little more complicated then expected, due to lack of accurate documentation, and reading old docs at sourceforge. Be sure now to read …

As of today, Proven Scaling has launched an official blog, which we’ll all be writing entries on. Check it out and subscribe!

Whether an online comic, or not, the New Straits Times is one of the three English dailies, that still cost some amount of money in Malaysia. Their Computimes pullout, now better known as Tech&U, featured Raj Kissu, a Summer of Code 2008 participant for MySQL. While the article itself, fails to mention MySQL, he describes what he’s working on:

I?m doing a project on binary large objects in database. Basically, it is aimed at allowing people to file or stream files online. The program is based on open source.

Kudos to Raj, kudos to Google, kudos to phpMyAdmin, and kudos to MySQL. As for the reporter, as usual, old medium journalism tends to be somewhat of a fail….

I had a great time at O'Reilly's 10th annual Open Source Convention aka OSCON08.  I will post later about the conference itself including the podcasts I did, the announcements we made etc.  For now, here are some pics I took from the Sun Zend bash that was held in the Double Tree parking lot (which actually isn't used as a parking lot).

Above -- Row 1: (L) Tim Bray all dressed up with no place to go; (R) …

The MySQL Community version is different in theory from the Enterprise version in relation to the following points:

0) It’s free
1) It has community patches
2) It is released less often
3) It is tested less strictly

In reality, the first two differences are not applicable — the binaries and source code for Enterprise can be freely and legally downloaded at http://mirror.provenscaling.com/mysql/enterprise/. The process for adding community patches to the MySQL source code has not been changed sufficiently to be able to actually add community patches and encourage more community development.

I understand that MySQL (and now Sun) needs to make money. I also understand that development takes a lot of effort, and seeing an ROI is important. The Community/Enterprise split was designed to have tradeoffs on both sides. …

MySQL Proxy got a bunch of changes in the svn-repo over the last weeks. Most of the important changes are in and we are working on making it a good 0.7.0 release.

The important changes are:

• script cache to improve the proxy performance
• central low-level decoding + lua wrappers
• plugins for proxy, admin and debug
• admin plugin is now lua based (more flexible)
• improved test coverage
• close a connection where we did throw a assertion before

Script Cache

In 0.7.0 we added a script-cache to only reload a script when it has changed and use a byte-cached version of it if it is unchanged.

This speeds up all script functionality quite nicely. No extra compile step as we did in 0.6.x when a connection was opened.

Plugins

We moved the proxy functionality into a plugin that can be loaded at startup as needed. We have at …

Hooray! The MySQL reference manual has a new search system. It now uses a Google Appliance and the results should be a lot better. The old system was not very helpful. It used to break config variables into multiple words and search on them individually and give a billion results I didn’t care about. I’ve just tried to search for some things like key_buffer_size and got results I think are very useful.

I love the MySQL manual. It is a great example of quality software documentation. As someone recently mentioned, it is not released under a Free license though — that would be a great improvement, too!

When did this change happen, by the way? Maybe it’s been there for a while and I just missed it because I grew accustomed to using Google search instead.

Edit: I actually would suggest a …

PDO_MYSQLND is in the PHP CVS repository at php.net: PDO_MYSQL has been patched (PHP 5.3, PHP 6.0). Try out PDO_MYSQL with the MySQL native driver for PHP (mysqlnd). Its has new features.

Since Kaj’s announcement of the MySQL native driver for PHP (mysqlnd), we promised to to patch all three PHP MySQL extensions (ext/mysql, ext/mysqli and PDO_MYSQL) optionally support it. Almost exactly a year ago, on July 27th 2007, mysqlnd and updated versions of ext/mysql and ext/mysqli have been …

PDO_MYSQLND is in the PHP CVS repository at php.net: PDO_MYSQL has been patched (PHP 5.3, PHP 6.0). Try out PDO_MYSQL with the MySQL native driver for PHP (mysqlnd). Its has new features.

Since Kaj’s announcement of the MySQL native driver for PHP (mysqlnd), we promised to to patch all three PHP MySQL extensions (ext/mysql, ext/mysqli and PDO_MYSQL) optionally support it. Almost exactly a year ago, on July 27th 2007, mysqlnd and updated versions of ext/mysql and ext/mysqli have been …