shell监控脚本实例—监控mysql主从复制
分享一例shell脚本，用于监测mysql数据库的主从复制，有需要的朋友不妨参考学习下。
转自：http://www.jbxue.com/article/14103.html（转载请注明出处)
本节内容：
监控mysql主从复制的shell脚本。
说明：
监控脚本在 rhel5 下测试正常，其它版本的linux 系统请自行测试。
代码：?
复制代码代码如下:
#监控mysql 主从复制
cat chk_mysql_rep.sh?
#!/bin/bash?
#?
#script_name:chk_mysql_rep.sh?
#check mysql replication?
#?
#ssh root@xen “/usr/local/mysql/bin/mysql -uroot -pdongnan -e ‘show slave status\G’ -ss” | awk ‘/Running:/ {print $2}’?
#Yes?
#Yes?
#?
#variables?
ssh=/usr/bin/ssh?
sh_dir=/root/sh/?
crondir=${sh_dir}crontab?
source ${sh_dir}CONFIG?
hosts=”$DB_SLAVE_HOSTS”
#main?
#主循环遍历机器 www.jbxue.com
for HOST in $hosts;do?
log=$crondir/log/mysql_replication_error.log?
key=$($ssh root@$HOST “/usr/local/mysql/bin/mysql -uroot -pdongnan -e ‘show slave status\G’ -ss” | awk ‘/Running:/ {printf $2}’)?
??? #无法连接的主机,跳过本次循环?
??? test -z “$key” && continue?
??? #返回结果真?
??? if [ “$key” == “YesYes” ];then?
??????? #flag真,解除报警?
??????? if [ -f “${crondir}/log/$HOST.mysql” ];then?
??????????? #sms?
??????????? #for mobile in $MOBILES;do?
??????????????? #echo “$HOST replication ok” | /usr/local/bin/gammu –sendsms TEXT “$mobile” -unicode?
??????????? #done?
??????????? #mail?
??????????? for mail in $MAILS;do?
??????????????? echo “$HOST replication ok” | mail -s “$HOST replication ok” $mail?
??????????? done?
??????????? #flag?
??????????? rm -f “${crondir}/log/$HOST.mysql”?
??????? fi?
??? #返回结果假?
??? else???
check_date=$(date ‘+ %F %T’)?
??????? #flag假，报警?
??????? if [ ! -f “${crondir}/log/$HOST.mysql” ];then?
??????????? #sms www.jbxue.com
??????????? #for mobile in $MOBILES;do?
??????????????? #echo “$HOST replication error” | /usr/local/bin/gammu –sendsms TEXT “$mobile” -unicode?
??????????? #done?
??????????? #mail?
??????????? for mail in $MAILS;do?
??????????????? echo “$HOST replication error” | mail -s “$HOST replication error” $mail?
??????????? done?
??????????? #flag?
??????????? echo “replication error” >”${crondir}/log/$HOST.mysql”?
??????????? #log?
??????????? echo “$check_date $HOST mysql replicaton error” >> $log?
??????? fi?
??? fi?
#?
done?
#?
cat chk_mysql_rep.sh?
#!/bin/bash?
#?
#script_name:chk_mysql_rep.sh?
#check mysql replication?
#?
#ssh root@xen “/usr/local/mysql/bin/mysql -uroot -pdongnan -e ‘show slave status\G’ -ss” | awk ‘/Running:/ {print $2}’?
#Yes?
#Yes?
#?
#variables?
ssh=/usr/bin/ssh?
sh_dir=/root/sh/?
crondir=${sh_dir}crontab?
source ${sh_dir}CONFIG?
hosts=”$DB_SLAVE_HOSTS”
#main?
#主循环遍历机器 www.jbxue.com
for HOST in $hosts;do?
log=$crondir/log/mysql_replication_error.log?
key=$($ssh root@$HOST “/usr/local/mysql/bin/mysql -uroot -pdongnan -e ‘show slave status\G’ -ss” | awk ‘/Running:/ {printf $2}’)?
??? #无法连接的主机,跳过本次循环?
??? test -z “$key” && continue?
??? #返回结果真?
??? if [ “$key” == “YesYes” ];then?
??????? #flag真,解除报警?
??????? if [ -f “${crondir}/log/$HOST.mysql” ];then?
??????????? #sms?
??????????? #for mobile in $MOBILES;do?
??????????????? #echo “$HOST replication ok” | /usr/local/bin/gammu –sendsms TEXT “$mobile” -unicode?
??????????? #done?
??????????? #mail?
??????????? for mail in $MAILS;do?
??????????????? echo “$HOST replication ok” | mail -s “$HOST replication ok” $mail?
??????????? done?
??????????? #flag?
??????????? rm -f “${crondir}/log/$HOST.mysql”?
??????? fi?
??? #返回结果假?
??? else???
check_date=$(date ‘+ %F %T’)?
??????? #flag假，报警?
??????? if [ ! -f “${crondir}/log/$HOST.mysql” ];then?
??????????? #sms www.jbxue.com
??????????? #for mobile in $MOBILES;do?
??????????????? #echo “$HOST replication error” | /usr/local/bin/gammu –sendsms TEXT “$mobile” -unicode?
??????????? #done?
??????????? #mail?
??????????? for mail in $MAILS;do?
??????????????? echo “$HOST replication error” | mail -s “$HOST replication error” $mail?
??????????? done?
??????????? #flag?
??????????? echo “replication error” >”${crondir}/log/$HOST.mysql”?
??????????? #log?
??????????? echo “$check_date $HOST mysql replicaton error” >> $log?
??????? fi?
??? fi?
#?
done?
#?