Made some commits to my proxy for MySQL tonight. These are significant enough that they warrant another preview post.

original post

git clone http://consoleninja.net/code/dpm/dpm.git - to get the latest code, always
http://consoleninja.net/code/dpm/dpm-export.tar.gz - a tarball of the latest code, for those unwilling to git.

This feels more like a "real" preview now. Aside from one silly bug, it looks like I fixed most of the really bad stability issues. There're still a handful left, but I was pretty abusive just now and wasn't able to break it.

Grab it, build it, read the README.

The demo allows you to do some fun things:

- …

Made some commits to my proxy for MySQL tonight. These are significant enough that they warrant another preview post.

original post

git clone http://consoleninja.net/code/dpm/dpm.git - to get the latest code, always
http://consoleninja.net/code/dpm/dpm-export.tar.gz - a tarball of the latest code, for those unwilling to git.

This feels more like a "real" preview now. Aside from one silly bug, it looks like I fixed most of the really bad stability issues. There're still a handful left, but I was pretty abusive just now and wasn't able to break it.

Grab it, build it, read the README.

The demo allows you to do some fun things:

- …

I'm back from the MySQL EMEA Support Team meeting.. and it was just fantastic!

Most know that MySQL is a virtual company and we don't see to much colleagues. Most goes via our internal IRC server, email and phone. However, we in Support for example, try to meet up each year. This year we did it a bit differently by actually gathering and actively doing support together (in Bielefeld, Germany). You know, like in a real office!

The cool thing about the EMEA Support Team, and I can safely say this for the global Support Team, is that we simple play along very well. Each of us comes with baggage of experience when joining MySQL. Most importantly, we think mostly alike. When we disagree we settle or make it better. For people only meeting up once a year or less it is just spectacular!

It's also lots of fun and drinking beers, socializing and sleeping together.. I mean sharing rooms! Fact that I had my …

Diary: Saturday 16th June 2007

Today, Miss She-BA Sheeri Kritzer married partner Tony in Boston. For those that remember, Sheeri was the 2007 Community Advocate of the Year at the MySQL Conference.

The official photos and videos are already up, so I’ve add my snaps online now. This was an excellent day, it had some the best planning I’ve seen in a …

Well, the foundations for the Traffic Analyzer module were finally laid today; the basic classes of the module are now up in the SVN repository.

So far I've only constructed the classes for Unix and not Windows, I've created a separate branch for the Windows code but the associated directory is currently empty. Of course, there may be source files which will end up being common to both branches, however I don't think that maintaining a more complex directory structure in order to have both branches share common source files is something that's currently necessary (or something I currently know how to do!).

So right now the Traffic Analyzer can detect packet traffic and deconstruct packets sequentially using some clever pointer logic and special structs; nothing new there. There are a few command line arguments that the user can use to customize how the program runs and I've even included the old ConfigReader class from …

I’m surprised to see so little being said about the First Discussion draft of the Affero GPL v3. I see only 9 comments as of 9PM PDT 6/13. That’s not very many.

Perhaps the reason is that the only difference is the single paragraph in Section 13 which states:

Notwithstanding any other provision of this License, if you modify the Program, your modified version must give all users interacting with it remotely through a computer network (if your version supports such interaction) an opportunity to receive the Corresponding Source of your version by providing access to copy the Corresponding Source from a network server at no charge.

Fabrizio here seems bullish on the new license and goes on to say:

Bottom line: if GPL v3 and AGPL v3 are exactly the same document and are 100% compatible, why would an open …

MySQL AB today published a "Do's & Don'ts" summary article on the 'Top 5 Common Scale-Out Pitfalls to Avoid' -- based on the real-world experiences of the vendor's veteran professional services team. These database experts have helped countless businesses manage their 'growing pains' and be more successful with their scale-out solutions through consulting engagements. They have seen many companies fall into a few common traps when they first design their systems, only to run into performance issues once the explosive growth hits.

The full article is available here.

We live in a world full of truly lousy people.  I know this based on the amount of porn pingback and trackbacks I'm getting on this blog.  I don't yet know how to solve this so, for now, I'm turning those off.

I’ve just posted slides and (rather) rough presenter notes and image credits for my Age of Literate Machines presentation.

These are still draft slides. I’ll be working on an improved version in the coming weeks and months.

Many thanks to all who have sat through drafts of the talk (DES, Jen, Hilde, Markus, Monty, Rory, Tony).

• The Age of Literate Machines - Rough speaker?s notes and image credits (PDF)
• The Age of Literate …

Using MEMORY tables in MySQL is very useful; they are stored in memory and they are usually not so big in order to avoid a huge utilization of RAM. They are very fast.

MEMORY tables are often used to store session user data, chat messages and to store small frames of data from a bigger table in order to achieve great performance.

But, if you use them in a replication environment, you can have some problem due to their "volatility"; MEMORY table rows are lost when the server shuts down.

If you restart a slave host for some reason, you will have empty MEMORY tables on it, while the master host will have the correct ones.

How to populate automatically MEMORY tables at slave start up copying data from master host?

We could use something like LOAD TABLE table_name FROM MASTER, but it's deprecated, so we will use something else.

I have developed a stored procedure you have to create on the …