Difference between revisions of "How to install Percona XtraDB Cluster"

From ppwiki
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.

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
STEP 3- Configue Percona_XtraDB-Cluster
STEP 4 - Bootstrap the first node (db1)