Keepalived+mysql-自动切换.pdf

誉天 Cisco / Linux 认证社区
Keepalived+mysql 自动切换
网络结构：
VIP VI_1
}
}
vrrp_instance VI_1 {
state BACKUP
interface eth0
virtual_router_id 88
priority 80
advert_int 1
authentication {
auth_type PASS
auth_pass
}
track_script {
check_run
}

virtual_ipaddress {

}
}
复制代码

四 mysql 状态检测脚本/root/bin/
vim /root/
#!/bin/bash
MYSQL=/usr/local/mysql/bin/mysql
MYSQL_HOST=localhost
MYSQL_USER=root
MYSQL_PASSWORD=
CHECK_TIME=3
#mysql is working MYSQL_OK is 1 , mysql down MYSQL_OK is 0
MYSQL_OK=1
function check_mysql_helth (){
$MYSQL -h $MYSQL_HOST -u $MYSQL_USER -p${MYSQL_PASSWORD} -e "show status;" >/dev/null
2>&1
if [ $? = 0 ] ;then
MYSQL_OK=1
else
MYSQL_OK=0
Cisco / RHCE 培训 Cisco / Linux 认证社区
fi
return $MYSQL_OK
}
while [ $CHECK_TIME -ne 0 ]
do
let "CHECK_TIME -= 1"

check_mysql_helth
if [ $MYSQL_OK = 1 ] ; then