Ask Your Question
3

How to cluster MySQL

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

apanagiotou gravatar image

Hello,

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

Comments

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

http://www.mirantis.com/blog/ha-platf...

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
-1

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
2

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 ;) http://docs.openstack.org/high-availability-guide/content/ha-aa-db.html (http://docs.openstack.org/high-availa...)

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. http://galeracluster.com/products/

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. http://www.percona.com/software/percona-xtradb-cluster/pxc-56 (http://www.percona.com/software/perco...)

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. http://www.mysqlperformanceblog.com/

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

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

Seen: 301 times

Last updated: Jun 04 '14