shell监控脚本-监控mysql 主从复制

linuxx

监控脚本在 rhel5 下测试正常，其它版本的linux 系统请自行测试
#监控mysql 主从复制

• [Shell] 纯文本查看 复制代码

  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 
  #主循环遍历机器 
  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 
              #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 

  
  

#
结束

0

帮帮顶顶！！

linuxx

站的更高，尿的更远。

鄂破机看

要是我灌水，就骂我“三个代表”没学好吧。

xiaoyu28

有事秘书干，没事干秘书!

虚幻0516

睡眠是一门艺术——谁也无法阻挡我追求艺术的脚步！

ywg

听君一席话，省我十本书!