Get started with Percona XtraDB Cluster

This guide describes the procedure for setting up Percona XtraDB Cluster.

Examples provided in this guide assume there are three Percona XtraDB Cluster nodes, as a common choice for trying out and testing:

Node	Host	IP
Node 1	pxc1	192.168.70.61
Node 2	pxc2	192.168.70.62
Node 3	pxc3	192.168.70.63

Note

Avoid creating a cluster with two or any even number of nodes, because this can lead to split brain.

The following procedure provides an overview with links to details for every step:

• Install Percona XtraDB Cluster on all nodes and set up root access for them.

It is recommended to install from official Percona repositories:

• On Red Hat and CentOS, install using YUM.

• On Debian and Ubuntu, install using APT.

• Configure all nodes with relevant settings required for write-set replication.

This includes path to the Galera library, location of other nodes, etc.

• Bootstrap the first node to initialize the cluster.

This must be the node with your main database, which will be used as the data source for the cluster.

• Add other nodes to the cluster.

Data on new nodes joining the cluster is overwritten in order to synchronize it with the cluster.

• Verify replication.

Although cluster initialization and node provisioning is performed automatically, it is a good idea to ensure that changes on one node actually replicate to other nodes.

• Install ProxySQL.

To complete the deployment of the cluster, a high-availability proxy is required. We recommend installing ProxySQL on client nodes for efficient workload management across the cluster without any changes to the applications that generate queries.

Percona Monitoring and Management

Percona Monitoring and Management is the best choice for managing and monitoring Percona XtraDB Cluster performance. It provides visibility for the cluster and enables efficient troubleshooting.

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert

---

Last update: 2023-07-21