3. KEEPALIVED

3.1. Install Keepalived

------------------ Both LB1 & LB2 server ---------------------

# yum –y install keepalived

3.2. Config Keepalived

# mv /etc/keepalived/keepalived.conf /etc/keepalived/keepalived.conf-backup

# vi /etc/keepalived/keepalived.conf

------------------ NODE LB1 ------------------------

vrrp_scrpt chk_haproxy {

script "pidof haproxy" # check the haproxy process

interval 2 # every 2 seconds

weight 2 # add 2 points if OK

}

vrrp_instance VI_1 {

interface ens33 # interface to monitor

state MASTER # MASTER on haproxy, BACKUP on haproxy2

virtual_router_id 51

priority 101 # 101 on haproxy, 100 on haproxy2

virtual_ipa {

10.10.10.99 # virtual ip address

}

track_scrpt {

chk_haproxy

}

}

------------------ NODE LB2 ------------------------

vrrp_script chk_haproxy {

script "pidof haproxy" # check the haproxy process

interval 2 # every 2 seconds

weight 2 # add 2 points if OK

}

vrrp_instance VI_1 {

interface ens33 # interface to monitor

state BACKUP # MASTER on haproxy, BACKUP on haproxy2

virtual_router_id 51

priority 100 # 101 on haproxy, 100 on haproxy2

virtual_ip {

10.10.10.99 # virtual ip address

}

track_script {

chk_haproxy

}

}

** Restart service Keepalived

# systemctl enable keepalived

# systemctl restart keepalived

3.3. Verify

# ip a

LB01 Down

LB02 Status

4. DATABASE

4.1. Config DB Server

------------------ Both LB1 & LB2 server ---------------------

# systemctl disable firewalld; systemctl stop firewalld; systemctl status firewalld

4.2. Install Mariadb-server

------------------ Both LB1 & LB2 server ---------------------

# yum -y update

# yum - y install net-tools mariadb-server

# systemctl enable mariadb

# systemctl start mariadb

# mysql_secure_installation

4.3. MySQL master-master replication configuration

# mv /etc/my.cnf /etc/my.cnf-bk

# vi /etc/my.cnf

----------------------------- Master 1-----------------------------------

[mysqld]

server-id=1

log-bin=mysql

auto-increment-increment = 2

auto-increment-offset = 1

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysl.sock

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

#

# include all files from the config directory

#

!includedir /etc/my.cnf.d

# systemctl restart mariadb

----------------------------- Master 2-----------------------------------

# mv /etc/my.cnf /etc/my.cnf-bk

# vi /etc/my.cnf

[mysqld]

server-id=2

log-bin=mysql-bin

auto-increment-increment = 2

auto-increment-offset = 2

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

#

# include all files from the config directory

#

!includedir /etc/my.cnf.d

# systemctl restart mariadb

** Create the replicator user on each server

----------------------------- Master 1-----------------------------------

# mysql –u root –p1234556

> GRANT REPLICATION SLAVE ON *.* TO 'DTULAB'@'5.5.5.5' IDENTIFIED BY '123456';

> FLUSH PRIVILEGES;

----------------------------- Master 2-----------------------------------

# mysql –u root –p1234556

> GRANT REPLICATION SLAVE ON *.* TO 'DTULAB'@'5.5.5.3' IDENTIFIED BY '123456';

> FLUSH PRIVILEGES;

** Check master status

----------------------------- Master 1-----------------------------------

> SHOW MASTER STATUS;

+------------------+----------+--------------+------------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |

+------------------+----------+--------------+------------------+

| mysql-bin.000001 | 399 | | |

+------------------+----------+--------------+------------------+

1 row in set (0.00 sec)

----------------------------- Master 2-----------------------------------

> SHOW MASTER STATUS;

+------------------+----------+--------------+------------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |

+------------------+----------+--------------+------------------+

| mysql-bin.000001 | 399 | | |

+------------------+----------+--------------+------------------+

1 row in set (0.00 sec)

** Set master to master relationship

----------------------------- Master 1-----------------------------------

> STOP SLAVE;

> CHANGE MASTER TO

-> MASTER_HOST = '5.5.5.5',

-> MASTER_USER = 'DTULAB',

-> MASTER_PASSWORD = '123456',

-> MASTER_PORT = 3306,

-> MASTER_LOG_FILE = 'mysql-bin.000001',

-> MASTER_LOG_POS = 399,

-> MASTER_CONNECT_RETRY = 10;

> START SLAVE;

----------------------------- Master 2-----------------------------------

> STOP SLAVE;

> CHANGE MASTER TO

-> MASTER_HOST = '5.5.5.3',

-> MASTER_USER = 'DTULAB',

-> MASTER_PASSWORD = '123456',

-> MASTER_PORT = 3306,

-> MASTER_LOG_FILE = 'mysql-bin.000001',

-> MASTER_LOG_POS = 399,

-> MASTER_CONNECT_RETRY = 10;

> START SLAVE;

** Check slave config

------------------ Both MASTER1 & MASTER2 server ---------------------

> SHOW STATUS SLAVE \G;

…

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

…

> EXIT;

ðSlave_IO_Running and Slave_SQL_Running are all YES that successful configuration

4.4. Validation data synchronization

----------------------------- Master 1-----------------------------------

# mysql –u root –p123456

MariaDB [(none)]> create database DTULAB;

----------------------------- Master 2-----------------------------------

# mysql –u root –p123456

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| DTULAB |

| Linux |

| Linux2 |

| mysql |

| performance_schema |

| reptest |

+--------------------+