How to install Percona XtraDB Cluster

Percona XtraDB Cluster tutorial

For this tutorial, we will be installing:

• Percona-XetraDB-cluster 5.7
• Haproxy version 1.6.3
• sysbench version 1.0.12

Prerequisites

To complete this tutorial, you'll need the following:

• Four(4) Debian 9(Stretch) servers

This lab has been tested also on Ubuntu 14.04 and Xenial 16.04.

Server Information

Servername	IP adress	Server Role
db1	10.192.16.58	First db server
db2	10.192.16.59	Second db server
db3	10.192.16.60	Third db server
web1	10.192.16.61	Test client

STEP 1- Install Debian 9 on all 4 servers

Make sure that you install Debian 9 on all servers and all servers are up to date by runnimg the commands below after the install.

sudo apt-get update

sudo apt-get -y upgrade 

Note: If you are not running a DNS server in your environment, make sure you update you /etc/hosts file on each node.

127.0.0.1     localhost
10.192.16.58  db1
10.192.16.59  db2  
10.192.16.60  db3
10.192.16.61  web1
# The following lines are desirable for IPv6 capable hosts
::1     localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters

STEP 2- Install Percona_XtraDB-Cluster on db1,db2 and db3

login to as root and create the file percona.sh. Copy the script below and paste it into the new file. make the file executable

chmod +x percona.sh

Percona install script:

STEP 3- Configue Percona_XtraDB-Cluster

STEP 4 - Bootstrap the first node (db1)