Keepalived+MySQL双主单写实现高可用性

安装环境 RedHat6.3 MySQL-5.6.26
Keepalived版本 1.2.18

当主服务器当掉之后可自动切换到从服务器，主服务器启动后可自动切换回来，切换时间在毫秒级别。

两台MySQL服务器
1 192.168.10.145:3308
2 192.168.10.154:3308
对外提供服务的IP 192.168.10.111:3308

1. 配置两台MySQL服务器互为主从
   可参考MySQL主从复制
   change master to master_host=’192.168.10.154’, master_user=’rpl’, master_password=’rpl’, master_port=3308;

2. 安装keepalived
   ./configure
   make
   make install
   cp /usr/local/etc/rc.d/init.d/keepalived /etc/rc.d/init.d/
   cp /usr/local/etc/sysconfig/keepalived /etc/sysconfig/
   mkdir /etc/keepalived
   cp /usr/local/etc/keepalived/keepalived.conf /etc/keepalived/
   cp /usr/local/sbin/keepalived /usr/sbin/

3. 配置keepalived
   添加MySQL服务停止时执行的脚本
   vi /etc/keepalived/MySQL.sh
   service keepalived stop
   chmod 755 /etc/keepalived/MySQL.sh

   修改keepalived配置文件
   vi /etc/keepalived/keepalived.conf
   关键配置

vrrp_instance VI_1 {    #如果希望主服务重启后不抢夺服务 主state 可配置为 BACKUP    state MASTER    interface eth0    virtual_router_id 61    #从可配置为100    priority 150    advert_int 1    nopreempt authentication {        auth_type PASS        auth_pass 1111    }    virtual_ipaddress {        192.168.10.111    }} virtual_server 192.168.10.111 3308 {    delay_loop 6    lb_algo wlc    lb_kind DR    nat_mask 255.255.255.0    persistence_timeout 50    protocol TCP    real_server 192.168.10.145 3308 {            weight 3            notify_down /etc/keepalived/MySQL.sh            TCP_CHECK {                 connect_timeout 10                 nb_get_retry 3                 delay_before_retry 3                 connect_port 3308            }        }    }

4 启动keepalived
/etc/init.d/keepalived start
查看日志
vi /var/log/messages

设置开机启动 在MySQL之后启动
vi /etc/rc.d/rc.local
/etc/init.d/keepalived start