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

MySQL双主+keepalived高可用
MySQL双主+keepalived高可用
其他的内容全部删除掉
编写脚本
#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

MySQL双主+keepalived高可用

MySQL双主+keepalived高可用
其他的都一样
编写脚本
#vim /opt/kill_keepalived.sh
pkill keepalived

给脚本增加执行权限
chmod +x /opt/kill_keepalived.sh

启动keepalived
service keepalived start

关闭防火墙
service iptables stop
setenforce 0

在MySQLA主机上可以看到VIP
MySQL双主+keepalived高可用
我们停掉MySQLA上的mysql服务
#service mysqld stop
在MySQLB主机上可以看到漂移过来的VIP
MySQL双主+keepalived高可用
至此高可用搭建完毕