MySQL 5.6 has been released as GA and as per Oracle Notes http://www.oracle.com/us/corporate/press/1904335
“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 wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.12-2.el6.x86_64.rpm/from/http://cdn.mysql.com/ wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.12-2.el6.x86_64.rpm/from/http://cdn.mysql.com/ wget http://www.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.12-2.el6.x86_64.rpm/from/http://cdn.mysql.com/
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 http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
We need to enable the repo now.
[remi] name=Les RPM de remi pour Enterprise Linux 6 - $basearch #baseurl=http://rpms.famillecollet.com/enterprise/6/remi/$basearch/ mirrorlist=http://rpms.famillecollet.com/enterprise/6/remi/mirror enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi
[remi-test] name=Les RPM de remi en test pour Enterprise Linux 6 - $basearch #baseurl=http://rpms.famillecollet.com/enterprise/6/test/$basearch/ mirrorlist=http://rpms.famillecollet.com/enterprise/6/test/mirror enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi
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.