fairyguo 发表于 2018-12-31 13:50:38

Keepalived+MariaDB10配置+双主+高可用数据库

Keepalived+MariaDB10配置双主高可用数据库
http://s1.运维网.com/wyfs02/M00/8B/D1/wKioL1haFhiChECmAAC2sCBGIgY742.png-wh_500x0-wm_3-wmp_4-s_418499768.png
OS
RS
子网掩码
路由网关
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

在两台服务器上分别安装MYSQL:
yum -y install MariaDB （这里略）
安装完后配置双主模型：
编辑配置文件26.210：vim /etc/my.cnf.d/server.cnf
在配置文件中加入以前几个参数设置：
log-bin=mysql-bin
server-id       = 210
relay-log       =relay-bin
http://s2.运维网.com/wyfs02/M01/8B/D5/wKiom1haFi6w2AFjAABtZFaJpKw462.png-wh_500x0-wm_3-wmp_4-s_1109173854.png

编辑配置文件26.211：vim /etc/my.cnf.d/server.cnf
log-bin         =mysql-bin
server-id       = 211
relay-log       = relay-bin

http://s2.运维网.com/wyfs02/M01/8B/D5/wKiom1haFjzC-u8aAAA16lon3oE416.png-wh_500x0-wm_3-wmp_4-s_2256727272.png
分别启动两台服务器的MYSQL服务：service mysql start
服务器设置双主：
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;   #查看从状态IO和SQL 运行状态均为YES表示配置成功
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;    #查看从状态IO和SQL 运行状态均为YES表示配置成功
http://s5.运维网.com/wyfs02/M01/8B/D1/wKioL1haFl-RwNGhAAAf2wMwnlY706.png-wh_500x0-wm_3-wmp_4-s_1802718384.png


    http://s2.运维网.com/wyfs02/M02/8B/D1/wKioL1haFrbCFLuuAAEEAnuNBEo784.png-wh_500x0-wm_3-wmp_4-s_21370647.png

http://s1.运维网.com/wyfs02/M02/8B/D5/wKiom1haFt6CeQ5GAACgNu3uenc527.png-wh_500x0-wm_3-wmp_4-s_1950821687.png

http://s5.运维网.com/wyfs02/M00/8B/D5/wKiom1haFuyBRv24AAEpHMqEji4261.png-wh_500x0-wm_3-wmp_4-s_2678446413.png

http://s1.运维网.com/wyfs02/M02/8B/D1/wKioL1haFvvBfeGvAAEnu6ONieI340.png-wh_500x0-wm_3-wmp_4-s_1557470995.png
http://s4.运维网.com/wyfs02/M00/8B/D1/wKioL1haFxPA1c95AAFOpdLrHG0600.png-wh_500x0-wm_3-wmp_4-s_1891350090.png
http://s2.运维网.com/wyfs02/M00/8B/D1/wKioL1haFyDQ4ZvmAADmR3XI0tE943.png-wh_500x0-wm_3-wmp_4-s_2003897867.png



显示状态为成功，我们再创建数据库来测试，看看双主是否运行正常。
http://s4.运维网.com/wyfs02/M01/8B/D1/wKioL1haF5zBlj4ZAAAcvKDo-jU882.png-wh_500x0-wm_3-wmp_4-s_1916028208.png

http://s1.运维网.com/wyfs02/M02/8B/D1/wKioL1haF6igV1wOAAAaxi56zi4860.png-wh_500x0-wm_3-wmp_4-s_2177067375.png

http://s5.运维网.com/wyfs02/M02/8B/D1/wKioL1haF7bSCFUSAAAY6dne8SY533.png-wh_500x0-wm_3-wmp_4-s_2902767884.png
双主设置成功。
26.210：安装Keepalived
http://s3.运维网.com/wyfs02/M00/8B/D5/wKiom1haF8jy7oFBAAFElToTh6g642.png-wh_500x0-wm_3-wmp_4-s_3087766826.png
安装报错未安装gcc
yum -y install gcc
http://s4.运维网.com/wyfs02/M00/8B/D5/wKiom1haF96AYDfJAAH76HfyGnQ021.png-wh_500x0-wm_3-wmp_4-s_1552189092.png
yum -y install openssl-devel
http://s5.运维网.com/wyfs02/M00/8B/D1/wKioL1haF--Q92PZAAAjZxbvMsU011.png-wh_500x0-wm_3-wmp_4-s_2244123038.png

安装组件后编译成功：
http://s1.运维网.com/wyfs02/M01/8B/D5/wKiom1haGAehFwD2AAAqiew5UqM584.png-wh_500x0-wm_3-wmp_4-s_3241391957.png

http://s4.运维网.com/wyfs02/M01/8B/D1/wKioL1haGBbwxbQAAAAxpNM78Ag048.png-wh_500x0-wm_3-wmp_4-s_3602517175.png
http://s1.运维网.com/wyfs02/M02/8B/D1/wKioL1haGDuDjGEeAAALHAi0SrA008.png-wh_500x0-wm_3-wmp_4-s_1722113791.png


编辑配置文件：vim /etc/keepalived/keepalived.conf
http://s4.运维网.com/wyfs02/M00/8B/D1/wKioL1haGEmxL1zYAAAUpef-7iw928.png-wh_500x0-wm_3-wmp_4-s_817341647.png
! 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.2103306 {
      weight 1
      notify_down /etc/keepalived/mysql.sh
      TCP_CHECK {
connect_port 3306
connect_timeout 3
nb_get_retry 2
delay_before_retry 1
      }
    }

}
保存退出启动Keepalived服务。
service keepalived start

26.211：安装Keepalived。
http://s5.运维网.com/wyfs02/M01/8B/D5/wKiom1haGIuhYFA1AAAz0_S_6NI744.png-wh_500x0-wm_3-wmp_4-s_856343744.png


http://s1.运维网.com/wyfs02/M01/8B/D1/wKioL1haGNTClDhBAAAch9WS6b4332.png-wh_500x0-wm_3-wmp_4-s_2656384931.png
编辑配置文件26.211： vim /etc/keepalived/keepalived.conf

http://s1.运维网.com/wyfs02/M02/8B/D5/wKiom1haGSnBO3SmAAAJ-kgTRnU806.png-wh_500x0-wm_3-wmp_4-s_2630953844.png
! 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.2113306 {
      weight 1
      notify_down /etc/keepalived/mysql.sh
      TCP_CHECK {
connect_port 3306
connect_timeout 3
nb_get_retry 2
delay_before_retry 1
      }
    }

}
保存退出启动26.211上的Keepalived
service keepalived start

测试VIP是否可用:ping 192.168.27.210 -t

http://s5.运维网.com/wyfs02/M00/8B/D5/wKiom1haGTvxc_nNAABHhB37Suk648.png-wh_500x0-wm_3-wmp_4-s_2939542833.png


回到26.210或211都可以 上，创建一个数据库访问测试用户账号密码。

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

http://s2.运维网.com/wyfs02/M00/8B/D1/wKioL1haGU_xv56dAADt8K-jCyU331.png-wh_500x0-wm_3-wmp_4-s_2689729944.png




下面通过 VIP访问数据库观察访问：
http://s1.运维网.com/wyfs02/M01/8B/D1/wKioL1haGZ2QdQx5AACuw_5bjWo697.png-wh_500x0-wm_3-wmp_4-s_138735406.png


http://s5.运维网.com/wyfs02/M01/8B/D5/wKiom1haGazD0UuCAAFbQpHCqtY854.png-wh_500x0-wm_3-wmp_4-s_267030571.png

VIP在26.210这台服务器上，因此我们访问的26.210上的数据库。
下面停掉26.210上的MYSQL观察：
首先观察VIP网络出现波动后恢复。
http://s2.运维网.com/wyfs02/M02/8B/D5/wKiom1haGbyhgPfwAABxyuWASfk183.png-wh_500x0-wm_3-wmp_4-s_3626955643.png

数据库访问成功：
http://s3.运维网.com/wyfs02/M02/8B/D1/wKioL1haGcrSAnyBAABOw_7y0PQ446.png-wh_500x0-wm_3-wmp_4-s_456067701.png

VIP已经转移动26.211服务器上了。
http://s4.运维网.com/wyfs02/M00/8B/D5/wKiom1haGdqxe4MNAACueBj1bWs132.png-wh_500x0-wm_3-wmp_4-s_3078483889.png

我们再恢复26.210上的MYSQL数据库服务观察。http://s3.运维网.com/wyfs02/M00/8B/D1/wKioL1haGfzBW7VEAAGBXd3h7k4441.png-wh_500x0-wm_3-wmp_4-s_2471369002.png




页: [1]
查看完整版本: Keepalived+MariaDB10配置+双主+高可用数据库