The kind folks at The Dallas PHP/MySQL Users Group have asked me to repeat my 'MySQL Cluster -- a gentle introduction' presentation tonight at their meeting. This was after sitting through the original performance where I talked about how to set up complete cluster on a laptop. The presentation has been updated to reference Cluster 7.0 and the demo will work now that I have static IP addresses figured out with Virtualbox. So you know where to be if you are in the DFW Metroples and are not watching American Idol tonight.

The presentation in PDF format is available on NorthTexasMySQL.org

Just received an email newsletter from Sun titled "MySQL 5.4 Preview Release" which states:

Sun Microsystems recently released MySQL 5.4, delivering performance and scalability improvements enabling the InnoDB storage engine to scale up to 16-way x86 servers and 64-way CMT servers.

MySQL 5.4 also includes new subquery optimizations and JOIN improvements, resulting in 90% better response times for certain queries.

Apparently, the confusion about the contents of the release I wrote about earlier continue to reign inside Sun as well. MySQL 5.4 has not been released by any reasonable meaning of the word, since there's "only" a preview available at this time. Compare this to Windows 7: that's already a Release Candidate, but it has not been released. Also, the preview release available does not include new subquery optimizations nor JOIN improvements. Having planned such improvements …

The plan was only to do two quick posts on RAID Performance on the X-25e, but this was compelling enough to post on it’s own.  So in part I Mark Callaghan asked hey what gives with  the SLC Intel’s single drive random write performance,  It’s  lower then the MLC drive.   To be completely honest with you I had overlooked it, after all I was focusing on RAID performance.  This was  my mistake because this is actually caused by one of the Achilles heals of most flash on the market today, crappy performance when you fill more of the drive.  I don’t really know what the official title for it is but I will call it “Drive Overeating”.

Let me try and put this simply:  a quick trick most vendors use to push better random write #’s and help wear leveling is to not …

The goals of the project are basically

• Modularity. Make it easier to add new features without breaking existing ones.
• Pluggability. Make it easier for third parties to add functionality.
• …

Hi all,

I've just been reassigned (partially) to make sense of using a MySQL database server in the cloud, namely in Amazon Web Services. I'll be blogging about my experiences. Today is part 1.

After creating the account, I got to work. I signed up for EC2 (Elastic Compute Cloud 2), Simple Storage, and EBS (storage that allows for persistence). I played around with starting an instance, terminating it, etc. Then I got started with the command line tools. This is what I did.

• I made sure that my JAVA_HOME was set correctly in my mac: I typed

  export JAVA_HOME=/Library/Java/Home/

  in the terminal. Then I typed

  $JAVA_HOME/bin/java -version

  to confirm that the JAVA_HOME was indeed set correctly.
• Then I made created a .ec2 directory in my home directory. I then added my private key and X.509 certificate to this directory. I also made sure to point to these locations

   …

Hi all,

I've just been reassigned (partially) to make sense of using a MySQL database server in the cloud, namely in Amazon Web Services. I'll be blogging about my experiences. Today is part 1.

After creating the account, I got to work. I signed up for EC2 (Elastic Compute Cloud 2), Simple Storage, and EBS (storage that allows for persistence). I played around with starting an instance, terminating it, etc. Then I got started with the command line tools. This is what I did.

• I made sure that my JAVA_HOME was set correctly in my mac: I typed

  export JAVA_HOME=/Library/Java/Home/

  in the terminal. Then I typed

  $JAVA_HOME/bin/java -version

  to confirm that the JAVA_HOME was indeed set correctly.
• Then I made created a .ec2 directory in my home directory. I then added my private key and X.509 certificate to this directory. I also made sure to point to these locations

   …

Stored Procedures have been a MySQL 5.0 Key Feature. We have marketed them as an Enterprise Feature. Of course, the MySQL Connector/C++ supports them as far as possible. Using them is easy as long as you respect some limitations that still exist. The MySQL driver for C++ inherits those limitations from its underlying C-API. Which in turn cannot offer features not supported by the MySQL Client Server protocol. However, good news is: most things work just fine!

Setting up a connection for Stored Procedures

More good news first: no extra set up required with Connector/C++.

Stored Procedures can be invoked using the SQL command CALL. Unlike most other SQL statements, CALL statements can return more than one result set. CALL returns at least one result set to indicate the call status. In addition it can return further result sets returned by the statements executed by the stored procedure …

Stored Procedures have been a MySQL 5.0 Key Feature. We have marketed them as an Enterprise Feature. Of course, the MySQL Connector/C++ supports them as far as possible. Using them is easy as long as you respect some limitations that still exist. The MySQL driver for C++ inherits those limitations from its underlying C-API. Which in turn cannot offer features not supported by the MySQL Client Server protocol. However, good news is: most things work just fine!

Setting up a connection for Stored Procedures

More good news first: no extra set up required with Connector/C++.

Stored Procedures can be invoked using the SQL command CALL. Unlike most other SQL statements, CALL statements can return more than one result set. CALL returns at least one result set to indicate the call status. In addition it can return further result sets returned by the statements executed by the stored procedure …

How To Set Up WebDAV With MySQL Authentication On Apache2 (Debian Lenny)

This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on a Debian Lenny server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. Of course, WebDAV can also be used to upload and download files.

There is another live webinar on MySQL Cluster 7.0 scheduled for 27th May 09:00 (Western European time) / 08:00 (UK time) / 11:00 (Eastern European time) and you can register here.

Alternatively, if you can’t wait that long then you can watch/listen to the play-back of the original webinar.

Note that you may need to install the WebEx Player (Windows and Mac) - unfortunately, there doesn’t seem to be a simple, supported solution for LINUX users but you can always download the slides (PDF format) from the same link or else wait until 27th May and view it live.

What’s New in the Next Generation of MySQL Cluster?
Thursday, April 30, 2009