Finished my presentation earlier this afternoon. I had a better audience than last year and there was interest in the download URL for the source tarballs so I hope to see people hacking on it soon.The link to the presentation is here.There has been lots of good communication with staff from MySQL^WSun Microsystems^W^WOracle so maybe we shall see this code to begin to be integrated soon. In other

At MySQL Conference & Expo 2009, I will be giving a presentation on Q4M tomorrow (Apr. 22) from 11:55am. If you are interested in using a simple, fast message queue as part of your system, please come to the session.

Details: Using Q4M: A Message Queue Storage Engine for MySQL

On the next day (Apr. 23), I will be doing another presentation at Percona Performance Conference, held at the same location. In the presentation, I will describe the techniques (mainly MySQL UDFs) used to squeeze maximum performance out from MySQL used in Pathtraq, one of the largest web access stats service in Japan.

Details: …

Video for the presentation at the 2009 MySQL Conference:

High Performance Ruby on Rails and MySQL
David Berube (Berube Consulting)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6942

read more

Now that MySQL 5.4 (internally code named performance version or summit) is officially released, I can tell you that I used MySQL 5.4 alpha for my Nehalem scaling studies in my earlier blog - MySQL Scalability on Nehalem systems (Sun Fire X4270). I am waiting to get hold of a 4 socket Nehalem system to see we scale; but that will have to wait for the MySQL conference to get over.

Allan managed to get slightly higher Sysbench Read-Only numbers than mine using the latest MySQL 5.4. Interestingly Solaris does better than Linux. Probably a bug since many of the optimizations in MySQL 5.4 are OS independent. But then a lot can happen in 12 months

The first production release of MySQL Connector/C++ is available, please see the official announcement. You can download source and binary packages from http://dev.mysql.com/downloads/connector/cpp/1.0.html. A long and detailed getting started type API introduction article is waiting for you in the DevZone. The documentation has sections on how to set up NetBeans or VisualStudio projects for creating client applications.

During beta we learned about a pitfall: binary portability on Windows and Linux (generic builds). Forum users …

You know, amongst all the announcements this week, I should also mention that MySQL has been accepted into the Google Summer of Code 2009, and all our students are ready to rock and roll. Its the community bonding period now, and we have a bunch more mentors that will participate, its very exciting. Check out the student list for MySQL. Yes, lots of phpMyAdmin and Drizzle stuff too. They’re all part of the extended community, no?

…

Video for the presentation at the 2009 MySQL Conference:

Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud
Thorsten von Eicken (RightScale, Inc)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6912

Unfortunately, this video was cutoff, but most of the presentation is available.

read more

While sitting in krow's talk on Drizzle, I was hacking on my project to allow query logging to Gearman from Drizzle, and I found a couple of annoying bugs in GearmanD, and a critical bug in Drizzle. With MontyT's help, I found and fixed the Drizzle bug, and then showed the GearmanD bugs to EricD, who has gone off to fix them.

Maybe there will be an actual running demo of it all at my BOF this evening.

Two years ago, at the very first MySQL Conference that I attended, MySQL and IBM announced they were working a storage engine for IBM DB2.

When I went to work for MySQL PS, one of my first gigs was going to an IBM site and help them with that.

Now I'm sitting in this MySQL conference, watching the talk where the resulting storage engine is being publically described.

I feel some level of pride in my part creating this very odd duck.

... or how to misuse RBR to fill a MySQL table in the hopefully fastest way.

In my session yesterday I didn't had time to talk about this. The slide-desk covers it and I still wanted to document the idea at least.

The starting point is "Row Based Replication stores data in internal MySQL row-format." The slave can apply these events without any SQL parsing involved.

The idea is to create a master plugin that

• takes a file or something else that you want to INSERT into the mysql-server
• creates a binlog-stream using row-based replication events from it
• expose the binlog-stream and pretend to be a mysql-master (listen on port :3306 and handle COM_BINLOG_DUMP)
• let the MySQL-server connect to master-plugin using CHANGE MASTER TO and …