#监控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.1sucai.cn 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.1sucai.cn             #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 #