MySQL主从复制邮件报警脚本

最新推荐文章于 2024-04-21 03:22:36 发布

weixin_30911451

最新推荐文章于 2024-04-21 03:22:36 发布

阅读量85

点赞数

原文链接：http://www.cnblogs.com/manger/p/10069885.html

版权

#!/bin/sh
export PATH=$PATH:/application/mysql/3306/bin
logFile=`date +"%Y-%m-%d %H:%M:%S"`_check_mysql_slave.log
mysql='/application/mysql/3306/bin/mysql -uroot -p123456 -S /data1/mysql.data.d/3306/tmp/mysql.sock'
$mysql -e "show slave status \G;" > tmp.log
IO_env=`cat tmp.log | grep -w Slave_IO_Running | awk '{print $2}'`
SQL_env=`cat tmp.log | grep -w Slave_SQL_Running | awk '{print $2}'`
#判断Slave_IO_Running Slave_SQL_Running状态
if [ "$IO_env" = "Yes" -a "$SQL_env" = "Yes" ]
then
echo "slave OK!" >> $logFile
else
echo "replication thread is abnormal" | mail -s "repl log" abc@qq.com"
fi

转载于:https://www.cnblogs.com/manger/p/10069885.html