检测MYSQL不同步发邮件通知的脚本

2011-12-30 16:49 901 0

摘要: 脚本代码如下：#!/bin/bash &n...

关键词： nbsp bsp nbs elain mysql nb sp slave Seconds DBSock

脚本代码如下：#!/bin/bash # Info : check mysql slave # Author : dingtm # CTime : 2011.03.21 # This script run by root DBDir=/elain/apps/mysql/bin/ DBSock=/elain/data/mysql/3306/mysql.sock Log=/tmp/mysql_slave.log DBUser=root DBPasswd=elain [email protected],[email protected] Seconds_Behind_Master=$(${DBDir}mysql -u${DBUser} -p${DBPasswd} -S ${DBSock} -e "show slave status\G;" | awk -F':' '/Seconds_Behind_Master/{print $2}') if [ ${Seconds_Behind_Master} != "NULL" ]; then echo "slave is ok!" else ${DBDir}mysql -u${DBUser} -p${DBPasswd} -S ${DBSock} -e "show slave status\G;" >$Log /usr/bin/sendEmail -f [email protected] -t $MailList -s mail.elain.org -xu '[email protected]' -xp 'elain@123' -u "[`date +%Y-%m-%d`]数据库不同步了，请赶快看看吧！" -m "`cat $Log`" fi 添加定时任务 # Info : 监控MYSQL主从同步 # Author : dingtm # CTime : 2011.03.21 */3 * * * * /bin/sh /root/scripts/check_mysql.sh 本文出自 “elain的技术博客” 博客，请务必保留此出处http://elain.blog.51cto.com/3339379/640344

声明：文章版权归原作者所有部分文章转自互联网如有侵权请联系 [邮箱地址] 删除