Shulou(Shulou.com)06/01 Report--

Keepalived+MariaDB10 configuration of dual master high availability database

OS

RS

Subnet mask

Routing gateway

Centos6.6

MariaDB10

Keepalived

Eth0:192.168.26.210

255.255.252.0

192.168.25.3

VIP:192.168.27.210

255.255.255.252

Centos6.6

MariaDB10

Keepalived

Eth0:192.168.26.211

255.255.252.0

192.168.25.3

VIP:192.168.27.210

255.255.255.255

Win7 (client)

IP:192.168.26.70

255.255.252.0

192.168.25.3

Install MYSQL on both servers:

Yum-y install MariaDB

Configure the dual master model after installation:

Edit the configuration file 26.210:vim / etc/my.cnf.d/server.cnf

Add the previous parameter settings to the configuration file:

Log-bin=mysql-bin

Server-id = 210,

Relay-log = relay-bin

Edit the configuration file 26.211:vim / etc/my.cnf.d/server.cnf

Log-bin = mysql-bin

Server-id = 211

Relay-log = relay-bin

Start the MYSQL service of two servers: service mysql start

The server sets dual hosts:

26.210:

Mysql

Grant replication slave, replication client on *. * to 'jerry'@'192.168.%.%' identified by' jerrypass'

Change master to master_host='192.168.26.211',master_user='jerrymy',master_password='jerrypass',master_log_file='mysql-bin.000006',master_log_pos=558

Start slave

Show slave status\ G; # View from status IO and SQL running status both YES indicates that the configuration is successful

26.211:

Mysql

Grant replication slave, replication client on *. * to 'jerrymy'@'192.168.%.%' identified by' jerrypass'

Change master to master_host='192.168.26.210',master_user='jerry',master_password='jerrypass',master_log_file='mysql-bin.000007',master_log_pos=540

Start slave

Show slave status\ G; # View from status IO and SQL running status both YES indicates that the configuration is successful

The display status is successful, and then we create a database to test to see if the two hosts are working properly.

The dual master setting was successful.

26.210: install Keepalived

Installation error did not install gcc

Yum-y install gcc

Yum-y install openssl-devel

Compiled successfully after installing the component:

Edit configuration file: vim / etc/keepalived/keepalived.conf

! Configuration File for keepalived global_defs {

Router_id mysql-ha

}

Vrrp_instance VI_1 {

State MASTER

Interface eth0

Virtual_router_id 20

Priority 100

Advert_int 1

Nopreempt

Authentication {

Auth_type PASS

Auth_pass 123456

}

Virtual_ipaddress {

192.168.27.210

}

}

Virtual_server 192.168.27.210 3306 {

Delay_loop 2

Lb_algo rr

Lb_kind DR

Persistence_timeout 60

Protocol TCP

Real_server 192.168.26.210 3306 {

Weight 1

Notify_down / etc/keepalived/mysql.sh

TCP_CHECK {

Connect_port 3306

Connect_timeout 3

Nb_get_retry 2

Delay_before_retry 1

}

}

}

Save exit and start the Keepalived service.

Service keepalived start

26.211: install Keepalived.

Edit configuration file 26.211: vim / etc/keepalived/keepalived.conf

! Configuration File for keepalived global_defs {

Router_id mysql-ha

}

Vrrp_instance VI_1 {

State BACKUP

Interface eth0

Virtual_router_id 20

Priority 99

Advert_int 1

Nopreempt

Authentication {

Auth_type PASS

Auth_pass 123456

}

Virtual_ipaddress {

192.168.27.210

}

}

Virtual_server 192.168.27.210 3306 {

Delay_loop 2

Lb_algo rr

Lb_kind DR

Persistence_timeout 60

Protocol TCP

Real_server 192.168.26.211 3306 {

Weight 1

Notify_down / etc/keepalived/mysql.sh

TCP_CHECK {

Connect_port 3306

Connect_timeout 3

Nb_get_retry 2

Delay_before_retry 1

}

}

}

Save exit start Keepalived on 26.211

Service keepalived start

Test if VIP is available: ping 192.168.27.210-t

You can go back to 26.210 or 211 to create a database to access and test the user's account password.

Grant all on *. * to 'jerrytest'@'192.168.%.%' identified by' jerrypass'

The following is to access the database through VIP to observe access:

VIP is on 26.210 of this server, so we access the database on 26.210.

Let's stop the MYSQL observation on 26.210:

First of all, observe the recovery after the fluctuation of the VIP network.

Database access succeeded:

VIP has been transferred to the mobile 26.211 server.

Let's restore the MYSQL database service observation on 26.210.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.