A project I have been working on for a while just hit a significant milestone.

Pluggable Query Logging has just been merged into the main Drizzle development.

The plan is that quickly this will replace the existing query log and slow query log that Drizzle inherited from MySQL.

The legacy logging system is more than a bit byzantine, is full of a lot of complexity to try to get incremental performance with complicated buffering, and yet has several completely unnecessary locks.

In the new plugin logging system, there is a callback right after a query is parsed but before it is executed, and another one right after it is done executing. A plugin registers itself, and will be called at those two points, and is passed the THD, from which it can learn everything about the query that will be / has been executed, and then do whatever it …

It may be rather obvious to some folks that I’ve been doing a lot of work on Drizzle since Brian released it. The great news is that my employer thinks this is a good thing, and is actually now paying me to work on Drizzle as a day job.

So as of yesterday I am no longer a member of the MySQL Professional Services team, and instead will be sitting on my couch all day annoying my wife and hacking on Drizzle.

The last three years I’ve been a consultant for MySQL have been wonderful. I’ve gotten to work with a whole load of bright people and many of the big exciting shops and large projects out there. I’ve also done some work with companies not much bigger than 2 or 3 people. I can truthfully say there is an almost never ending supply of interesting things people are trying.

At the same time, I can’t tell you about most of them, which is the downside to being a consultant. There are many upsides, …

One of the (many) ongoing discussions in the Drizzle developer community is the level of support the database server kernel should provide for non-Unicode character set encodings. Actually, when I say non-Unicode, I actually mean non-UTF8, since we've stripped out all other character sets and "standardized" on 4-byte UTF8. I'll come back to why exactly I put standardized in quotes in just a bit...but to sum up, in childish terms, my thoughts after spending 4 hours tonight reading about character sets and collations, here is an exchange between Toru and myself on Freenode #drizzle:

<jaypipes> tmaesaka: how do you write "I wish everyone would just speak English" in …

Well, as Giuseppe announced, I am leaving the MySQL Community Team after almost three years. I'll still be working at Sun, but as a staff engineer on the Drizzle project in the Sun CTO organization. We are looking for someone to pick up the reins in the North American MySQL community and assume the role as Community Relations manager. Interested? Get in touch with Giuseppe or myself after reading his article about the requirements of the job.

I should add that candidates should be advised about Giuseppe. As your team lead, he may subject you such horrors as excellent project and managerial skills, a kind and encouraging shoulder on which to vent, and a deep, heartfelt connection with open source and community issues. In addition, you can look forward to working with …

It's been a week or 2 and some of you may already have heard that PBXT has moved from Sourceforge to Lauchpad.net: https://launchpad.net/pbxt.

There are several very good reasons for the move, not the least of which is that MySQL has already moved to Launchpad, and Drizzle is there too. It simply makes sense for a storage engine like PBXT to be on the same platform.

And check this out, Stewart Smith has already ported PBXT to Drizzle. You will find the tree here: PBXT in …

      select
title, from_date, to_date
from titles
where emp_no in
(select emp_no
from employees
where first_name = 'Mary'
      and last_name = 'Sluis'
)

The result, in MySQL 5.1.28 is

+-------+------------+------------+
| title | from_date  | to_date    |
+-------+------------+------------+
| Staff | …

After an amazing summer of getting married, graduating college, adopting a new dog, and taking a much needed extended vacation, I’m now back on track with where I left off. I’ve been making good progress on the asynchronous MySQL library I talked about in this post in the form of a new drizzle client library. This library is also compatible with MySQL since they share the same protocol, and if drizzle changes in the future I plan on supporting current and new MySQL protocols as well. All of the connection and I/O overhead is mostly done, and I’m just working through the protocol bits now. I’m hoping to have something ready to show and talk about for the OpenSQL camp.

In other news, I’ve recently started working with the …

Drizzle TalkView SlideShare presentation


Drizzle talk for MySQL Developer's Meeting.


SlideShare Link

Today at the Riga Sun Database Group Developer Meeting, I'm giving a MySQL University session about using Launchpad.net and Bazaar for Contributors. Below, I've posted links to the slides.

A Contributor's Guide to Launchpad and Bazaar   Open Office Impress slides
  PDF slides

Topics included in the slides:

• Getting started on Launchpad
• Various features of Launchpad
• Setting up a Bazaar repository
• Bazaar Commands
• Working in a decentralized gatekeeper model
• Linking to tasks through Launchpad
• Resolving merge conflicts using Meld

When Brian began the work on refactoring the MySQL 6.0 Server source code into what has now become the Drizzle Project, a number of code pieces were removed, including some major MySQL functionality such as stored procedures, server-side prepared statements, SQL Mode, some legacy code, and a variety of data types. The goal, of course, was to reduce the server code base down to a more streamlined and eventually modular kernel.

Of course, that vision is great, but it's got some side effects! One of those side effects is a dramatic reduction in the number of test cases that pass the test suite in their current form, and an increase in the number of tests that have been disabled. I re-enabled and fixed a few tests yesterday, but as of this writing, there are only 54 of 408 tests currently passing in the test suite.

…