该脚本可以监控当前MySQL的状态,可作为Keepalived高可用数据库来判断MySQL是否运行。
#!/bin/bash
/usr/local/mysql/bin/mysql -uroot -p123456 -e "show status" &>/dev/null
if [ $? -ne 0 ];then
service keepalived stop
fi
chmod a+x /etc/keepalived/check_status_mysqld.sh
注:
假如mysqld is running, mysql -uroot -p123456 -e "show status" ,and echo $? = 0
假如mysqld is no running, mysql -uroot -p123456 -e "show status" ,and echo $? = 1