Mysql主从之keepalive+MySQL高可用

cat  /usr/mysql/chk_mysql.sh

#!/bin/bash
counter=$(netstat -na|grep "LISTEN"|grep "3306"|wc -l)
if [ "${counter}" -eq 0 ]; then
    systemctl stop keepalived
fi  

!Configuration File for keepalived     
global_defs {
notification_email {
ceshi@qq.com
}       
notification_email_from ceshi@qq.com
smtp_server 127.0.0.1 
smtp_connect_timeout 30
router_id MASTER-HA
}      
vrrp_script chk_mysql_port {       #检测mysql服务是否在运行。用脚本检测等等
    script "/usr/mysql/chk_mysql.sh"   #这里通过脚本监测
    interval 2                         #脚本执行间隔，每2s检测一次
    weight –5   #脚本结果导致的优先级变更，检测失败（脚本返回非0）则优先级 -5                   
    fall 2      #检测连续2次失败才算确定是真失败。会用weight减少优先级（1-255之间）                   
    rise 1      #检测1次成功就算成功。但不修改优先级
}      
vrrp_instance VI_1 {
    state dataBase1               #这里所有节点都定义为dataBase1
    interface ens33               #指定虚拟ip的网卡接口
    mcast_src_ip 192.168.179.10   #本地IP 
    virtual_router_id 51          #路由器标识，MASTER和BACKUP必须是一致的
    #定义优先级，数字越大，优先级越高同一个vrrp_instance，MASTER的优先级大于dataBase1的优先级。
    priority 101   
    advert_int 1
    nopreempt  #不抢占模式，在优先级高的机器上设置即可，优先级低的机器可不设置         
    authentication {   
        auth_type PASS 
        auth_pass 123456     
    }
    virtual_ipaddress {    
        192.168.179.15   #虚拟IP 
    }     
track_script {               
   chk_mysql_port             
   }
}

!Configuration File for keepalived       
global_defs {
notification_email {
ceshi@qq.com
}      
notification_email_from ceshi@qq.com
smtp_server 127.0.0.1 
smtp_connect_timeout 30
router_id MASTER-HA
}      
vrrp_script chk_mysql_port {
    script "/usr/mysql/chk_mysql.sh"
    interval 2            
    weight -5                 
    fall 2                 
    rise 1               
}       
vrrp_instance VI_1 {
    state   dataBase1
    interface    ens33 
    mcast_src_ip      192.168.179.12
    virtual_router_id 51    
    priority 99          
    advert_int 1         
    authentication {   
        auth_type PASS 
        auth_pass 123456     
    }
 virtual_ipaddress {    
       192.168.179.15    #虚拟IP 
    }     
track_script {               
   chk_mysql_port             
    }
}