:::: MENU ::::

Install Percona XtraDB Cluster on CentOS 6.2

Percona XtraDB Cluster is a new high availability and high scalability solution for MySQL users. XtraDB Cluster integrates Percona Server with the Galera library of high availability solutions in a single product package. Percona XtraDB is an enhanced version of the InnoDB storage engine for MySQL and MariaDB. It has much faster performance than InnoDB and better scalability on modern hardware.

This tutorial is how to setup a 3-node XtraDB cluster, assuming you are running CentOS Linux 6.2 64-bit.

Install Percona’s CentOS 6 repositories:

Install Percona XtraDB Cluster packages:

XtraDB Cluster requires a couple of TCP ports to operate. Easiest way:

If you want to open only specific ports, you need to open 3306, 4444, 4567, 4568 ports.

For example for 4567 port (substitute 10.0.0.1 by your IP):

Now repeat on all XtraDB cluster nodes

Create /etc/my.cnf files

On the first XtraDB Cluster node (assume IP 10.0.0.10):

On the second XtraDB Cluster node:

On the third XtraDB Cluster node:

Start mysqld on the first node:

When all nodes are in SYNCED stage your cluster is ready!

Connect to database on any node and create database:

The new database will be propagated to all nodes.