http://pastebin.flamingspork.com/

A pastebin running Drizzle and  the Drizzle PHP Extension (which is on top of libdrizzle).

The following just went out to our mailing list:

We are happy to announce that MySQL Proxy 0.7.2 is available in a source and binary release for all of our target platforms.

This latest release also brings back Windows support in both the source and binary release.

The list of important changes in this release is:
* fixed memory leak proxy plugin (#45272)
* fixed ro-balance.lua (#45408)
* added CMake build files
* fixed portability issues for Win32
* added mysql-proxy-svc on Win32
* updated INSTALL file to cover all the build steps on win32

Please report any problems on bugs.mysql.com, our Launchpad discussion mailing list or on IRC: …

I’ve had a few VCs ask how we compare to Hadoop and companies using MapReduce. With Google blessing MapReduce, it seems to be the cool new thing. I figure I’m going to have to explain this to VCs, so I might as well blog about it.

MapReduce is a process of dividing a problem into small pieces and distributing (mapping) those pieces to a large number of computers. Then it collects the processed data and merges (reduces) it into a result set. Hadoop provides the plumbing, so users focus on writing the query and Hadoop handles the dirty work of mapping and reducing. Such a query, using a procedural language like Java, is more complex than a comparable SQL query, but more on that below.

So what is MapReduce good for? It really shines when you want to summarize, analyze or transform a very large data set. This is why it is well suited to web data. Map reduce doesn’t utilize an index, so the tradeoff you need to consider is whether …

Earlier this year I had published a small blog about being efficient when using mysql prompt. This is a small continuation of it highlighting a couple of other cool features which I really find very useful when working command line (i.e. always!). The first I’m gonna list here is setting the prompt itself by typing –

\R [...]

The following just went out to our mailing list:

We are happy to announce that MySQL Proxy 0.7.2 is available in a source and binary release for all of our target platforms.

This latest release also brings back Windows support in both the source and binary release.

The list of important changes in this release is:
\* fixed memory leak proxy plugin (#45272)
\* fixed ro-balance.lua (#45408)
\* added CMake build files
\* fixed portability issues for Win32
\* added mysql-proxy-svc on Win32
\* updated INSTALL file to cover all the build steps on win32

Please report any problems on bugs.mysql.com, our Launchpad discussion mailing list or on IRC: …

The following just went out to our mailing list:

We are happy to announce that MySQL Proxy 0.7.2 is available in a source and binary release for all of our target platforms.

This latest release also brings back Windows support in both the source and binary release.

The list of important changes in this release is:
\* fixed memory leak proxy plugin (#45272)
\* fixed ro-balance.lua (#45408)
\* added CMake build files
\* fixed portability issues for Win32
\* added mysql-proxy-svc on Win32
\* updated INSTALL file to cover all the build steps on win32

Please report any problems on bugs.mysql.com, our Launchpad discussion mailing list or on IRC: …

Version 0.4 of libdrizzle has been released. This was mostly a maintenance release with build system changes and small bug fixes. This is the client and protocol library for Drizzle and MySQL that provides both client and server interfaces.

Version 0.4.1 of the Drizzle PHP Extension has also been released. James Luedke has moved development and releases of the extension into PECL, and has also fixed a number of bugs, extended the interface, and worked with the PHP/PECL developers to get the extension up to the proper PHP coding standards. Thanks James!

Version 0.8 of the Gearman C Server and Library has been released. This includes basic HTTP protocol support, build system improvements, and bug fixes.

Version 0.4.0 of the Gearman PHP Extension has also been released.

If you want to learn more about Gearman, be sure to check out the upcoming Boston MySQL Meetup, MySQL Webinar, or the one of the events at OSCON (tutorial, session, and …

Yesterday I still worked for Sun Microsystems as a Principal Engineer & MySQL Sr. Architect. Today was my first day of work at Monty Program, Inc, a subsidiary of a tiny company established by Monty Widenius in February. Yet I didn't even make the top ten. If people want not to miss the train they have to hurry up.

Am I happy? Oh, yeah...
No more waking up with the question constantly drilling my mind: “What am I doing here?” What are all of us, MySQL Server developers, doing without Monty? Waiting for the time when all our options are vested? I can't . That's too long for me. I'm already too old to wait any more.
Besides, we've already lost at least 3 years. We have to do what we planned to do in 2005. We have to raise the Server to the level where any RDBMS that claims to be called mature should be.

So who is newly born? Me? In a way, yes. This is my second reincarnation for the history of MySQL, …

For the last couple of months, we've been quietly developing a MySQL protocol parser for Maatkit. It isn't an implementation of the protocol: it's an observer of the protocol. This lets us gather queries from servers that don't have a slow query log enabled, at very high time resolution.

With this new functionality, it becomes possible for mk-query-digest to stand on the sidelines and watch queries fly by over TCP. It is only an observer on the sidelines: it is NOT a man in the middle like mysql-proxy, so it has basically zero impact on the running server (tcpdump is very efficient) and zero impact on the query latency. There are some unique challenges to watching an entire server's traffic, but we've found ways to solve those. Some of them are harder than others, such as making sense of a conversation when you start …