[MySQL] shell脚本监控mysql主从同步状态并自动修复

shell脚本 vi monitor.sh

#!/bin/sh
# check_mysql_slave status
ip=eth1
cmd=/usr/bin/mysql
mysqluser=user
mysqlpwd=pwd
sock=/data/mysql/mysql.sock
datetime=`date +"%Y-%m-%d_%H:%M:%S"`
log=/data/mysql/logs/slave.log
slave_ip=`ifconfig $ip|grep "inet addr" | awk -F[:" "]+ '{print $4}'`
$cmd -u$mysqluser -p$mysqlpwd -S $sock -e "show slave status\G" | grep -i "running:" &> $log
Slave_IO_Running=`grep Slave_IO_Running $log| awk ' {print $2}'`
Slave_SQL_Running=`grep Slave_SQL_Running $log | awk '{print $2}'`
if [ "$Slave_IO_Running" = "Yes" -a "$Slave_SQL_Running" = "Yes" ]
then
        echo "Slave is Running!"
        else
        echo " $datetime $slave_ip Slave is not running!" >> $log
cat | $cmd -u$mysqluser -p$mysqlpwd -S $sock << EOF
stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
start slave;
exit
EOF
fi

定时任务每分钟（或者每10秒）执行一次

*/1 * * * * /data/mysql/monitor.sh > /dev/null 2>&1