Difference between revisions of "Main Page"

From ppwiki
Jump to navigation Jump to search
Line 44: Line 44:
  
 
; STEP 2- Install Percona_XtraDB-Cluster on db1,db2 and db3
 
; STEP 2- Install Percona_XtraDB-Cluster on db1,db2 and db3
{| class="wikitable"
 
#This script is to install Percona_XtraDB-cluster 5.7.
 
#This script has been tested on Debain 8 and 9 and on
 
#Ubuntu 14.04 and 16.04
 
 
#!/bin/bash
 
 
#update all nodes
 
sudo apt-get update
 
sudo apt-get -y upgrade
 
 
#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
 
 
#Stop mysqld on all nodes
 
|}
 
  
 
==Puppet==
 
==Puppet==

Revision as of 23:04, 13 February 2018

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

Puppet