You are here

Ugly way to install MySQL Galera Cluster 5.6 on Ubuntu 14.04

I wanted to install MySQL Galera Cluster 5.6 on the new Ubuntu 14.04 with provided packages. It was a bit tricky to make it work.

apt-get update
apt-get install mysql-server   # this is still 5.5
# from universe
apt-get install mysql-server-5.6 mysql-client-5.6 mysql-client-core-5.6

So far so good. Everything works fine as MySQL 5.6.

Now we have to download Galera 5.6 from Coderships website:

wget https://launchpad.net/galera/3.x/25.3.5/+download/galera-25.3.5-amd64.deb
wget https://launchpad.net/codership-mysql/5.6/5.6.16-25.5/+download/mysql-server-wsrep-5.6.16-25.5-amd64.deb

apt-get install libssl0.9.8   # Should be resolved by the package?
dpkg -i galera-25.3.5-amd64.deb

And then the ugly part:

dpkg --force-all -i mysql-server-wsrep-5.6.16-25.5-amd64.deb

Finally:

 # /etc/mysql/conf.d/wsrep.cnf

[mysqld]
wsrep_provider        = /usr/lib/galera/libgalera_smm.so
wsrep_cluster_address = "gcomm://"

And to activate the changes:

service mysql restart

If you find a better way, please let me know...

Taxonomy upgrade extras: 

Comments

dpkg --force-all -i socat_1.7.2.3-1_amd64.deb
olicomment