MySQL双主+keepalived高可用
系统版本:centos6.5_x64
Keepalived的版本:keepalived- 1.2.13
Vip:192.168.189.181
Mysq-A:192.168.189.140
Mysql-B:192.168.189.141
两台MySQL已经做完了互为主从
在MySQLA主机配置:
安装keepalived
yum -y install keepalived
配置keepalived
vim /etc/keepalived/keepalived.conf
其他的内容全部删除掉
编写脚本
#vim /opt/kill_keepalived.sh
pkill keepalived
给脚本增加执行权限
chmod +x /opt/kill_keepalived.sh
这是一个检测脚本,作用是当mysql停止工作时自动关闭本机的keepalived
MySQL正常启动之后,要手动启动keepalived服务。
启动keepalived
service keepalived start
关闭防火墙
service iptables stop
setenforce 0
在MySQLB主机配置:
操作跟A上差不多
安装keepalived
yum -y install keepalived
配置文件有些许不同
配置keepalived
vim /etc/keepalived/keepalived.conf
其他的都一样
编写脚本
#vim /opt/kill_keepalived.sh
pkill keepalived
给脚本增加执行权限
chmod +x /opt/kill_keepalived.sh
启动keepalived
service keepalived start
关闭防火墙
service iptables stop
setenforce 0
在MySQLA主机上可以看到VIP
我们停掉MySQLA上的mysql服务
#service mysqld stop
在MySQLB主机上可以看到漂移过来的VIP
至此高可用搭建完毕