实时检查MySQL数据库延迟状况复制中断数据延迟
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了实时检查MySQL数据库延迟状况复制中断数据延迟，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2776字，纯文字阅读大概需要4分钟。
内容图文
脚本编写思路：
（1）根据show slave statusG;l列Seconds_Behind_Master；
（2）Seconds_Behind_Master= NULL判断io或sql进程哪个停止或者二者都停止
（3）Seconds_Behind_Master= 0复制正常
（4）Seconds_Behind_Master>0 说明主从延迟
上述（2）、（4）会发出邮件报警，正常时忽略，脚本10s采集数据一次。
#!/bin/bash
########################################
# automatic check mysql replacation status from salve database #
# edit by rgf in 2014/09/03 #
# The scropt distributes in slave databases,if slave db faults, #
# then it will send email to administrator or dba #
########################################
export LANG=zh_CN
base_dir=/usr/bin
logs_dir=/opt/mysql/log
db_user=root
db_pwd=123456
EmailFile=$logs_dir/${HOSTNAME}_mail_`date +%Y%m%d`.log
Email=gfsunny@163.com
while true
do
echo " " > $EmailFile
echo "-----------------------" >> $EmailFile
echo "`date +"%y-%m-%d %H:%M:%S"`" >> $EmailFile
echo "-------------------------" >> $EmailFile
Port=`netstat -ntlp|grep mysqld | awk -F ‘ ‘ ‘{print $4}‘ | awk -F ‘:‘ ‘{print $2}‘`
Ip=`ifconfig |grep "inet addr:"|grep -v "inet addr:127.0.0.1" | awk -F ‘ ‘ ‘{print $2}‘ | awk -F ‘:‘ ‘{print $2}‘`
echo "${HOSTNAME}:$Ip:$Port" >> $EmailFile
Seconds_Behind_Master=`${base_dir}/mysql -u$db_user -p$db_pwd -e "show slave statusG;" | grep "Seconds_Behind_Master:" | awk -F ‘:‘ ‘{print $2}‘` &> /dev/null
Slave_IO_Running=`${base_dir}/mysql -u$db_user -p$db_pwd -e "show slave statusG;" | grep "Slave_IO_Running:" | awk -F ‘:‘ ‘{print $2}‘` &> /dev/null
Slave_SQL_Running=`${base_dir}/mysql -u$db_user -p$db_pwd -e "show slave statusG;" | grep "Slave_SQL_Running:" | awk -F ‘:‘ ‘{print $2}‘` &> /dev/null
if [ $Seconds_Behind_Master = "NULL" ];then
echo "Disruption of replication" >> $EmailFile
if [ $Slave_IO_Running = "Yes" -a $Slave_SQL_Running = "No" ];then
echo "Slave_IO_Running is OK and Slave_SQL_Running is failure" >> $EmailFile
mail -s "Slave_IO OK AND Slave_SQL failured!!" $Email < $EmailFile
elif [ $Slave_IO_Running = "No" -a $Slave_SQL_Running = "Yes" ];then
echo "Slave_IO_Running is failure and Slave_SQL_Running is OK" >> $EmailFile
mail -s "Slave_IO failured AND Slave_SQL OK!!" $Email < $EmailFile
else
echo "Slave_IO_Running is failure and Slave_SQL_Running is failure" >> $EmailFile
mail -s "Slave_IO failure AND Slave_SQL failure!!" $Email < $EmailFile
fi
elif [ $Seconds_Behind_Master -eq 0 ];then
echo "slave is ok!" &> /dev/null
elif [ $Seconds_Behind_Master -gt 0 ];then
echo "slave has beened delayed compared with master" >> $EmailFile
mail -s "slave has beened delayed" $Email < $EmailFile
else
echo "slave Unknown fault!" >> $EmailFile
mail -s "slave Unknown fault!!" $Email < $EmailFile
fi
sleep 10
done
原文：http://gfsunny.blog.51cto.com/990565/1553586
内容总结
以上是互联网集市为您收集整理的实时检查MySQL数据库延迟状况复制中断数据延迟全部内容，希望文章能够帮你解决实时检查MySQL数据库延迟状况复制中断数据延迟所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。