Mysql keepalived 缺陷_mysql+keepalived数据库停掉无法自杀

global_defs {

notification_email {

test@sina.com

}

notification_email_from admin@test.com

smtp_server 127.0.0.1

smtp_connect_timeout 30

router_id MYSQL_HA #标识，双主相同

}

vrrp_instance VI_1 {

state BACKUP #两台都设置BACKUP

interface eth0

virtual_router_id 51 #主备相同

priority 100 #优先级，backup设置90

advert_int 1

nopreempt #不主动抢占资源，只在master这台优先级高的设置，backup不设置

authentication {

auth_type PASS

auth_pass 1111

}

virtual_ipaddress {

192.168.42.170

}

}

virtual_server 192.168.42.170 3306 {

delay_loop 2

#lb_algo rr #LVS算法，用不到，我们就关闭了

#lb_kind DR #LVS模式，如果不关闭，备用服务器不能通过VIP连接主MySQL

persistence_timeout 50 #同一IP的连接60秒内被分配到同一台真实服务器

protocol TCP

real_server 192.168.42.128 3306 { #检测本地mysql，backup也要写检测本地mysql

weight 3

notify_down /etc/keepalived/mysql.sh #当mysq服down时，执行此脚本，杀死keepalived实现切换

TCP_CHECK {

connect_timeout 3 #连接超时

nb_get_retry 3 #重试次数

delay_before_retry 3 #重试间隔时间

}

}

#!/bin/sh

killall keepalived

启动正常，当mysql停掉之后keepalived 无法自杀。