Difference between revisions of "How to install Percona XtraDB Cluster"
Jump to navigation
Jump to search
| Line 42: | Line 42: | ||
sudo apt-get -y upgrade | 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.59 db2 | ||
| + | |||
| + | # 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 | ; STEP 2- Install Percona_XtraDB-Cluster on db1,db2 and db3 | ||
Revision as of 11:12, 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
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.59 db2
# 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
- STEP 3- Configue Percona_XtraDB-Cluster
- STEP 4 - Bootstrap the first node (db1)