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

A while back I looked at the Memcached UDF for MySQL, and noticed that it didn't use libmemcached in an optimal way. In order to work in a multithreaded environment it used the following pattern:

   memcached_st* clone = memcached_clone(NULL, memc);

   ... memcached operations using the clone ---   

   memcached_free(clone);

Well, that doesn't look bad, does it? Well, it isn't that bad, but if you look at the network traffic you will see that we end up connecting / disconnecting to the involved memcached servers every time, and memcached is not optimized for "single-shot" connections.

So how should you solve this? Well, you should reuse your clones! And luckily for you, you don't have to reinvent the wheel. Yesterday I pushed a patch to libmemcached introducing a new library: libmemcachedutil. The intention of that library is to put utility functions built on top of libmemcached …

I’ve decided to start a series of blog entries on not-so-obvious findings that I’ve found while working on my new project. By archiving the findings, I’m hoping that I can help those that are looking into developing a storage engine for the MySQL family in the future.

Accumulating these mini-knowledge would also be useful for me since I can refer back to it when I forget something. Also, once I write enough entries I’m planning on summarizing them and making it available on the Drizzle Wiki. If MySQL is interested in updating the engine documentation, I would be more than happy to help there too.

So to begin with, I’ll describe something trivial that I stumbled across while trying to catch an error on duplicate primary key insertion to the data table.

Here are my new db_STRESS results obtained on the latest Sun M5000 server (SPARC64-VII 8CPU quad-core / bi-thread 2400Mhz). I was very curious to retest the "official" MySQL 5.4 on this machine as well other versions and InnoDB engines. But on the same time the new XtraDB version 5 was announced. As well Google shipped their v3 patch. How to resist? :-) (I'll try to be short :-))

MySQL 5.0 & 5.1

There is no more performance gap between 5.0 and 5.1 as I observed before , both versions are having near the same performance and both are way slower comparing to others :-) So, honestly, if you have any performance problem - why do not migrate to 5.4, XtraDB, or at least the latest InnoDB plugin?..

XtraDB Performance Improvements

I was very pleasantly surprised by performance improvements done in XtraDB-5! It's …

I’m surprised I haven’t used it before. I do have to say that MySQL Sandbox is incredibly awesome. In this case, it saved me waiting for a compile of MySQL 6.0, which is always a good thing.

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.
• …