MySQL+Keepalived高可用配置

注意：首先关闭两台机器的防火墙 setenforce 0

 

Environment： 2台CentOS测试机器  安装好MySQL

1.两台机器安装keepalived

 yum -y install keepalived 

2.编辑配置文件

vim /etc/keepalived/keepalived.conf

    virtual_route_id  51 #广播的路由ID
    priority 100              #优先级权限，一台100，另一台90即可
    virtual_ipaddress{
            192.168.10.181  #设置漂移的ip
    }

3.生成停止mysql的脚本

vim /root/kill.sh
    #!/bin/bash
    service keepalived stop

4.service keepalived restart 

5.查看vip是否生成

ip a

备份主机的操作

1.可以拷贝master主机的配置文件到本地，也可以在本地直接配置

 scp 192.168.%：/etc/keepalived/keepalived.conf /etc/keepalived.conf 

2.编辑配置文件内部参数

vim /etc/keepalived/keepalived.conf
        state  BACKUP
        interface  eth0
        priority  90  #优先级设置为比master稍微低点即可
            real-server 192.168.189.%  3306

3.生成停止mysql的脚本

在root根目录下创建即可 vim /root/kill.sh

#!/bin/bash

service keepalived stop