Ask Your Question

How to cluster MySQL

asked 2014-06-04 10:03:19 -0500

apanagiotou gravatar image


I want to install openstack and I stuck on clustering MySQL. I have 2 controller nodes using keepalived and HAproxy and 8 compute nodes.

How to cluster MySQL? using Galera? You suggest to cluter it only on controllers or on all nodes? Is there any guide for this?

Thank you, Alex

edit retag flag offensive close merge delete


View Oracle Guide 1.
Cluster Guide Oracle 2
I believe 2 data nodes . One data node per one openstack controller.

dbaxps gravatar imagedbaxps ( 2014-06-04 10:27:49 -0500 )edit

Has a bunch of links at the bottom with further reading as well.

mpetason gravatar imagempetason ( 2014-06-04 10:35:29 -0500 )edit

2 answers

Sort by ยป oldest newest most voted

answered 2014-06-04 23:08:38 -0500

mattgriffin gravatar image

updated 2014-06-04 23:13:57 -0500

Here are a few resources for MySQL clustering options for OpenStack deployments.

First, check out the official OpenStack High Availability Guide for working with MySQL cluster options. Probably the best place to go to learn from an OpenStack perspective. If this content is lacking, patches are always welcome ;) (

As far as clustered MySQL options, based on what I've heard in the community, the two most popular options are Galera Cluster for MySQL and Percona XtraDB Cluster. Full disclosure... I work for Percona.

Galera from Codership is the replication technology that enables MySQL nodes to behave like a cluster. Codership takes Galera and adds it to MySQL Community Edition to create Galera Cluster for MySQL. Find out information about deploying Galera Cluster for MySQL at their site.

Percona XtraDB Cluster is another great choice that is based on Percona Server, a 100% drop-in compatible and higher performance flavor of MySQL Community Edition. You can find information on the latest version, 5.6, at Percona's site as well as information on documentation and webinars. (

The MySQL Performance Blog, managed by Percona, is another great resource for learning about clustering MySQL using both of these solutions as well as other approaches to HA and, the often overlooked, performance testing.

edit flag offensive delete link more

answered 2014-06-04 10:39:42 -0500

marcantonio gravatar image

updated 2014-06-04 10:40:29 -0500

I have had a ton of success using Percona. It's standard MySQL with the galera stuff already added and some other useful tools. Their documentation is great too.

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools


Asked: 2014-06-04 10:03:19 -0500

Seen: 455 times

Last updated: Jun 04 '14