Main Page

Tutorials

Percona XtraDB Cluster

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

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 

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

1. This script is to install Percona_XtraDB-cluster 5.7.
2. This script has been tested on Debain 8 and 9 and on
3. Ubuntu 14.04 and 16.04

1. !/bin/bash

1. update all nodes

sudo apt-get update sudo apt-get -y upgrade

1. Install Percon-Xtradb-cluster

sudo apt-get -y install wget cd /tmp/ wget https://repo.percona.com/apt/percona-release_0.1-5.$(lsb_release -sc)_all.deb sudo dpkg -i percona-release_0.1-5.$(lsb_release -sc)_all.deb sudo apt-get update sudo apt-get -y install percona-xtradb-cluster-57

1. Stop mysqld on all nodes