mysql replication环境检查脚本

ゝ一纸荒年。 2022-02-20 15:21 278阅读 0赞

author：skate  
time:2013/05/13

**mysql replication环境检查脚本**

此脚本部署在slave端，可以通过短信或邮件监控slave的mysqld健康，replication环境健康，及复制延迟。

脚本：mysql\_rep\_moni.sh

\#!/bin/bash  
\#\#\# author: skate  
\#\#\# time: 2013-05-14  
\#\#\# function: This script detects the mysqld health, replicaton health, replication latency

\#variables  
pwd=pwd  
dir=/mysql/script/  
ipaddr=1.1.1.1

\#\#\#Determine whether there is connection  
mysql\_status=\`netstat -nl | awk 'NR>2\{if ($4 ~ /.\*:3306/) \{print "Yes";exit 0\}\}'\`  
  if \[ "$mysql\_status" == "Yes" \] ; then  
        slave\_status=\`mysql -uroot -p$pwd -e "show slave status\\G" | grep "Running" | awk '\{if ($2 != "Yes") \{print "No";exit 1\}\}'\`  
        slave\_delay=\`mysql -uroot -p$pwd -e "show slave status\\G" | grep "Seconds\_Behind\_Master" | awk '\{if ($2 >=0) \{print $2 ;exit  
 0\}\}'\`  
       echo "delay"$slave\_delay  
       echo "status"$slave\_status  
\#\#\#replication is not working  
         if \[ "$slave\_status" == "No" \];then  
             echo "slave is not working!"  
             sh "$dir"notify.sh "phone" "$ipaddr""\_warn\_zxg\_rep" "$ipaddr""\_mysql\_replication\_is\_not\_working" "dba"  
             sh "$dir"notify.sh "email" "$ipaddr""\_error\_zxg\_rep" "mysql\_replication\_is\_not\_working" "dba"  
\#\#\#replication is working,but replication have delay  
        elif \[ "$slave\_status" != "No" \] && \[ $slave\_delay -ge 10 \] ; then  
             echo "slave is working,but replication have delay!"  
             sh "$dir"notify.sh "phone" "$ipaddr""\_warn\_zxg\_rep" "$ipaddr""\_mysql\_replication\_is\_delay:$slave\_delay" "dba"  
             sh "$dir"notify.sh "email" "$ipaddr""\_warn\_zxg\_rep" "mysql\_replication\_is\_delay:$slave\_delay" "dba"  
        else  
             echo "slave is working."  
        fi  
  else  
       echo "mysqld is down!"  
       sh "$dir"notify.sh "email" "$ipaddr""\_error\_zxg\_mysqld" "$ipaddr""\_mysqld\_is\_down" "dba"   
       sh "$dir"notify.sh "phone" "$ipaddr""\_error\_zxg\_mysqld" "mysqld\_is\_down" "dba"  
  fi

创建定时crontab  
\*/5     \*       \*       \*       \*       su - mysql -c "sh /mysql/script/mysql\_rep\_moni.sh> /dev/null 2>&1"

**说明：**  
上面的报警API(notify.sh)可以根据自己的使用方式修改

\------end------