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?
#