Difference between revisions of "How to install Percona XtraDB Cluster"
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
To complete this tutorial, you'll need the following: | To complete this tutorial, you'll need the following: | ||
− | * Four(4) Debian 9(Stretch) servers | + | * Four(4) Debian 9(Stretch) servers |
+ | This lab has been tested also on Ubuntu 14.04 and Xenial 16.04. | ||
{| class="wikitable" | {| class="wikitable" |
Revision as of 11:01, 15 February 2018
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.
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
- STEP 3- Configue Percona_XtraDB-Cluster
- STEP 4 - Bootstrap the first node (db1)