Wow, I'm done with my book ""Developing Web Applications using Perl, memcached, MySQL and Apache" which is slated for July sale. What an experience, one that I intend to write about some day in a separate post. Now I can get back to managing some of my open source projects which need attention. These include:

* DBD::mysql
* DBD::drizzle
* FederatedX Storage Engine
* Memcached Functions For MySQL
* MySQL Web Tutorial Site

I'm really excited- this week I just started working with a fellow Stiepan Kovac (IT-Kovac, Geneva CH). He's been working on implementing SSL into Federated. We are going to try out Amazon's EC2 for our development. Seems pretty interesting so far. No need to have to go through the trouble of installing a Linux box - just select what I want, turn it one and use it!

Another reason for this post is because I'm quite excited about what I've been working on and have …

Alpha 2 has been announced. You can download the MySQL Connector/OpenOffice.org, an OpenOffice.org extension to connect from OpenOffice.org 3.1 to MySQL 5.1 or newer from ftp://qa-upload.services.openoffice.org/MySQLNative/. OpenOffice.org extensions as easy to install Plug-Ins. Installation instructions can be found at the MySQL Forge wiki page on the MySQL driver for OpenOffice.org.

The MySQL Connector/OpenOffice.org is the easiest way to connect OpenOffice.org and MySQL. Unlike the ODBC and JDBC bridges the "native driver", as its called on the OpenOffice.org world, does not require any extra driver installation and …

Alpha 2 has been announced. You can download the MySQL Connector/OpenOffice.org, an OpenOffice.org extension to connect from OpenOffice.org 3.1 to MySQL 5.1 or newer from ftp://qa-upload.services.openoffice.org/MySQLNative/. OpenOffice.org extensions as easy to install Plug-Ins. Installation instructions can be found at the MySQL Forge wiki page on the MySQL driver for OpenOffice.org.

The MySQL Connector/OpenOffice.org is the easiest way to connect OpenOffice.org and MySQL. Unlike the ODBC and JDBC bridges the "native driver", as its called on the OpenOffice.org world, does not require any extra driver installation and …

Well I finally put a few photos up on my Flickr account. I don't know what I was thinking but I didn't grab my small point and click as I left the house in Montreal and I keep forgetting I shoot RAW format on my Nikon D300. This means I have to find time to convert the photos and grab them all (and I left my card reader... talk about unprepared). So yes, that's why it's taken so long.

Yesterday's University of Colorado, Boulder, presentation was the smallest yet with Sun folks almost outnumbering the students. Oops. Let's hope that Fort Collins tonight will be better. It's at 5-6pm in Colorado State University (CSU).

I've also added MySQL Workbench to my list of things that I now show having yet again discovered that not understanding what a database schema might look like is a …

In my last blog, I introduced my investigation of the "Pool-of-Threads" scheduler in MySQL 6.0. Read on to see where I went next.

I now want to take a different approach to comparing the two schedulers. It is one thing to compare how the schedulers work "flat out" - with a transaction request rate that is limited only by the maximum throughput of the system under test. I would like to instead look at how the two schedulers compare when I drive mysqld at a consistent transaction rate, then vary only the number of connections over which the transaction requests are arriving. I will aim to come up with a transaction rate that sees CPU utilization somewhere in the 40-60% range.

This is more like how real businesses use MySQL every day, as opposed to the type of benchmarking that computer companies usually …

Now you can use the Sandboxes and Configurator on Mac OSX.

You need to download the macos.sh script.

• Sandbox users - Copy the script into the
mysqlcluster-XXX/scripts/ catalog
• Configurator users - Copy the script into the
mysqlcluster-XXX/cluster/scripts/ catalog

Then run it:

sh macos.sh

before you run any other script.

This will convert all the LD_LIBRARY_PATH to DYLD_LIBRARY_PATH and also use 'tar xvfz' instead of 'zcat' which does not work in MAC OSX.

You also need to download …

With MySQL Cluster it is possible to aggregate data from many MySQL Servers using Replication. Here is how.


E.g, you might have a sensor network, where each sensor writes data into a mysql server. The problem is that you have a quite few of these sensors, and you want to do aggregate this data, e.g. in order to do data mining on the combined data set.

The standard MySQL server does not support multi-source (i.e, one slave server can be connected to many masters), but Cluster can be used for this, since you can have many mysql servers connected to Cluster acting as slaves.

It is also possible to extend this - e.g, to replicate the aggregated data from Cluster to e.g, Infobright for datamining.

I did a small PoC at home to show how to use MySQL Cluster for …

Some unsettling things happened in MySQL in the past week or so.

New storage engine not mentioned in the changelog

There’s a bit of a storm brewing over at the MySQL Performance Blog, where Vadim reports discovering a new storage engine added without mention in the 5.1.33 changelog. This is in defiance of the policy of not making changes in a production release. And it certainly belongs in the changelog — but there is no sign that anyone will remedy this problem.

Arjen Lentz, who is ex-MySQL and was Employee #25, reported a bug on the licensing of this storage engine. To my eyes, the engine’s license does not look right to include in a GPL database. Arjen agrees.

But the …

Way back when I started this blog just under 4 years ago I wrote a post called 'An Oracle Developers Journey', in the early days the blog focused on the transition from Oracle to MySQL. The irony was that after a year or so professionally I move back the other way and for the last 3 years or so it's been all Oracle for me.

We all make mistakes, I know I have made some massive ones in the past, some were saved by a decent back up others were not so easy to recover from. It's been a while since I made anything like a big mistake (certainly not one that was noticed ;), once bitten twice shy tends to make you think about the consequences a little more.

But having now switched back to MySQL again I find myself really worried I'm going to make a mistake, in Oracle it's UPDATE/INSERT or more worryingly DELETE and then a COMMIT, but in MySQL (at least the way we are running it) there is no commit stage. I'm currently working …

The GreenSQL team is ready to present a new version of GreenSQL - SQL Database Firewall. GreenSQL intercepts SQL commands being sent to MySQL, checks them, and then either halts the query or passes it on to MySQL proper. Then it returns the query results to the calling application. Currently only MySQL database is supported. GreenSQL is distributed under the GPL license. This release includes a new version of firewall and a management application.

New application version is devoted in memory of Yuli’s father - Robert Stremovsky who had passed away February 14, 2009. Successful entrepreneur, industry expert and brilliant scientists in the field of chemistry, he struggled to prevent ecological catastrophe after the Chernobyl disaster. In our hearts you're always there.

This is a major application release geared towards application stability, ease of use, performance increase and elimination of bugs.

This release …