MySQL 5.6 has been released as GA and as per Oracle  Notes

“With increased performance, scalability, reliability and manageability, MySQL 5.6 helps users meet the most demanding Web, Cloud and embedded application requirements.”

So lets try to install it on an existing Centos 6.3 OpenVZ Container running LAMP.

Its my Lab container with WordPress and other things running. There is already mysql-5.1.67 on it which we will remove.

Please make sure you have a backup / snapshot to roll back if it breaks anything or doesn’t work or perform as expected.

We start getting the rpm packages.

You can browse for the latest version packages here

cd /tmp

libaio is needed

yum install libaio

Now it’s time to say good bye to the old mysql.

yum remove mysql mysql-server mysql-libs

Hello mysql 5.6

rpm -ivh MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm
rpm -ivh MySQL-server-5.6.12-2.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.12-2.el6.x86_64.rpm

(updated) I now need to hijack the remi repo to get the latest php.

rpm -Uvh

We need to enable the repo now.

vi /etc/yum.repos.d/remi.repo
name=Les RPM de remi pour Enterprise Linux 6 - $basearch
name=Les RPM de remi en test pour Enterprise Linux 6 - $basearch

in order to get the php-mysql running I run an update to get the latest php and installed php-mysql.

yum update
yum install php-mysql

Here it told me that “Package php-mysql is obsoleted by php-mysqlnd, trying to install php-mysqlnd-5.5.0-0.20.201303201430.el6.remi.x86_64 instead.

Confirm this and then you should be ready to go.

Finally start mysql. Please note that for whatever reason its now called mysql not mysqld anymore. Don’t ask me why it took me 5 minutes to spot that cause I was already way deeper looking for the issue 😉 .

service mysql start
Starting MySQL.. SUCCESS!

All I can say from some first testing, is that my WordPress (which is a mysql nightmare performance wise anyway) seems to run smooth (maybe even a bit smoother than usual) . But this is a total subjective feeling and not measured yet.

Have fun with bleeding edge mysql.

%d bloggers like this: