author：skate
time:2013/05/13
mysql replication环境检查脚本
此脚本部署在slave端，可以通过短信或邮件监控slave的mysqld健康，replication环境健康，及复制延迟。
脚本：mysql_rep_moni.sh
#!/bin/bash
### author: skate
### time: 2013-05-14
### function: This script detects the mysqld health, replicaton health, replication latency
#variables
pwd=pwd
dir=/mysql/script/
ipaddr=1.1.1.1
###Determine whether there is connection
mysql_status=`netstat -nl | awk 'NR>2{if ($4 ~ /.*:3306/) {print "Yes";exit 0}}'`
if [ "$mysql_status" == "Yes" ] ; then
slave_status=`mysql -uroot -p$pwd -e "show slave status\G" | grep "Running" | awk '{if ($2 != "Yes") {print "No";exit 1}}'`
slave_delay=`mysql -uroot -p$pwd -e "show slave status\G" | grep "Seconds_Behind_Master" | awk '{if ($2 >=0) {print $2 ;exit
0}}'`
echo "delay"$slave_delay
echo "status"$slave_status
###replication is not working
if [ "$slave_status" == "No" ];then
echo "slave is not working!"
sh "$dir"notify.sh "phone" "$ipaddr""_warn_zxg_rep" "$ipaddr""_mysql_replication_is_not_working" "dba"
sh "$dir"notify.sh "email" "$ipaddr""_error_zxg_rep" "mysql_replication_is_not_working" "dba"
###replication is working,but replication have delay
elif [ "$slave_status" != "No" ] && [ $slave_delay -ge 10 ] ; then
echo "slave is working,but replication have delay!"
sh "$dir"notify.sh "phone" "$ipaddr""_warn_zxg_rep" "$ipaddr""_mysql_replication_is_delay:$slave_delay" "dba"
sh "$dir"notify.sh "email" "$ipaddr""_warn_zxg_rep" "mysql_replication_is_delay:$slave_delay" "dba"
else
echo "slave is working."
fi
else
echo "mysqld is down!"
sh "$dir"notify.sh "email" "$ipaddr""_error_zxg_mysqld" "$ipaddr""_mysqld_is_down" "dba"
sh "$dir"notify.sh "phone" "$ipaddr""_error_zxg_mysqld" "mysqld_is_down" "dba"
fi
创建定时crontab
*/5 * * * * su - mysql -c "sh /mysql/script/mysql_rep_moni.sh> /dev/null 2>&1"
说明：
上面的报警API(notify.sh)可以根据自己的使用方式修改
------end------
