Ask Your Question

mattgriffin's profile - activity

2014-06-05 01:26:10 -0500 received badge  Nice Answer (source)
2014-06-04 23:40:54 -0500 received badge  Teacher (source)
2014-06-04 23:13:57 -0500 received badge  Editor (source)
2014-06-04 23:08:38 -0500 answered a question How to cluster MySQL

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/

2014-05-07 11:00:26 -0500 received badge  Supporter (source)