分享一例shell腳本,用于監(jiān)測mysql數(shù)據(jù)庫的主從復(fù)制,有需要的朋友不妨參考學(xué)習(xí)下。 轉(zhuǎn)自:http://www./article/14103.html(轉(zhuǎn)載請(qǐng)注明出處) 本節(jié)內(nèi)容: 監(jiān)控mysql主從復(fù)制的shell腳本。
代碼: 復(fù)制代碼代碼如下: #監(jiān)控mysql 主從復(fù)制 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 #主循環(huán)遍歷機(jī)器 www. 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}') #無法連接的主機(jī),跳過本次循環(huán) test -z "$key" && continue #返回結(jié)果真 if [ "$key" == "YesYes" ];then #flag真,解除報(bào)警 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 for mail in $MAILS;do echo "$HOST replication ok" | mail -s "$HOST replication ok" $mail done #flag rm -f "${crondir}/log/$HOST.mysql" fi #返回結(jié)果假 else check_date=$(date '+ %F %T') #flag假,報(bào)警 if [ ! -f "${crondir}/log/$HOST.mysql" ];then #sms www. #for mobile in $MOBILES;do #echo "$HOST replication error" | /usr/local/bin/gammu --sendsms TEXT "$mobile" -unicode #done 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 # |
|