MySQL released version 5.1.55, this is a bug fix release which also includes some security fixes and it is up to you if you want to upgrade. Check all the fixes and changes that are listed on the release notes to see what issues are resolved and if you are affected. I’ve compiled it and did some tests on my servers and it worked without any problems.

Read the documentation on how to ugrade this version of MySQL.

MySQL also release a new version of the 5.5.x branch which is already usuable in our setup when you read this blogpost. It works perfectly on my test machine. It includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware. MySQL 5.5 also provides a number of other new enhancements. Read the release notes for more details.

Read this documentation on how to ugrade this version using the package installer of MySQL.

It took me a bit longer then I first anticipated but I got most of the setup working on MySQL 5.5.x out of the box. First I struggled a long time at compiling it properly and found out when I had solved it that you no longer need to compile MySQL. Which is excellent news as it simplifies the setup and a lot of the problems I see here from users.

So here is a quick overview of people who are eager to use MySQL 5.5.x, I will update the other stuff over the next few weeks accordingly. By the way I’ve only done this on Snow Leopard, the Leopard version is only available for Intel, so no more PPC support from MySQL.

First get the binary installer package for MySQL 5.5.x from here (I’ve used 5.5.8) and install only the software (no preference pane or startup item).

If you haven’t installed Apache yet now is a good time. (Installing Apache)

Next up is PHP, this requires a new compilation instruction. From now on we will use the native MySQL driver for compilation. Which means changing:

–with-mysql=/usr/local/mysql
–with-pdo-mysql=/usr/local/mysql
–with-mysqli=/usr/local/mysql/bin/mysql_config

into:

–with-mysql=mysqlnd
–with-pdo-mysql=mysqlnd
–with-mysqli=mysqlnd

In all the compilation instructions found here and it all will compile perfectly.

For Postfix and Dovecot we require a bit of a workaround to get it working properly as the MySQL installation does not correctly sets the full library paths. You can see this when you execute the command:

otool -DX /usr/local/mysql/lib/libmysqlclient.dylib

You can correct it by executing the following command:

sudo install_name_tool -id /usr/local/mysql/lib/libmysqlclient.16.dylib /usr/local/mysql/lib/libmysqlclient.dylib

If you’ve done this you can compile Postfix and Dovecot using the existing instructions without any problem.

I’ve been trying to get the latest release of MySQL working properly and wanted to share some of the progress made. One of the challenges is that they complete redone the build process which now includes the use of cmake in addition to the normal make process. I’ve got the basics mostly covered but still encountered some issues, mostly related to getting PHP to work with this. Which made it difficult for me to even start testing the complete install (as my test are build with PHP for simplicity) and also limited the usefulness of the installation as most of our setup depend on using mysql with other compiled software. I haven’t even started on getting postfix or dovecot to work with this.

I found some bugs in the mysql bug forum related to these issues like:
#58987, #59006 and #59236

For the moment I would advise you to keep using MySQL 5.1.x, you can still download the 5.1.53 source code from the archive.

So I’m still working on it, and will keep you posted on any progress made.

MySQL released version 5.1.52, this is a bug fix release which also includes some security fixes and it is up to you if you want to upgrade. Check all the fixes and changes that are listed on the release notes to see what issues are resolved and if you are affected. Most of them are about InnoDB engine.

I’ve compiled it and did some tests on my servers and it worked without any problems.

Read the documentation on how to ugrade MySQL.

MySQL released version 5.1.51, this is a bug fix release which also includes some security fixes and it is up to you if you want to upgrade. Check all the fixes and changes that are listed on the release notes to see what issues are resolved and if you are affected. Most of them are about replication which we don’t use in our setup.

If you are still using a 5.0.x version I would urge you to plan a upgrade to a 5.1.x version.

I’ve compiled this version and did some tests on my servers and it worked without any problems.

Read the documentation on how to ugrade MySQL.