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

至此高可用搭建完毕