check slave状态并跳过相应错误

5534

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

一、具体代码 #!/bin/bash #-------------------------------------------------- #Author:jimmygong #Email:jimmygong@taomee.com #FileName:checkslave.sh #Function: #Version:1.0 #Created:2015-12-29 #-------------------------------------------------- if [[ `id -u` -ne 0 ]] then     echo "script need root"     exit 1 fi #根据情况修改变量信息 mysqluser="root" mysqlpass="123456" mysqlport=3398 mysqlsocket="/opt/mysql/socket/$mysqlport.sock" nowtime=$(date +"%m-%d %H:%M:%S") #各个错误代码解释 1158网络错误,出现读错误,请检查网络连接状况 1159网络错误,读超时,请检查网络连接状况 1008数据库不存在,删除数据库失败 1007数据库已存在,创建数据库失败 1062字段值重复,入库失败 1452不能删除或更新父行,外键约束失败 PS:1452这个根据情况跳过错误。 allerror=(1158 1159 1008 1007 1062 1452) function redirectlog () {     currdate=$(date +%Y%m%d)     logdir="/root/checkslave"     logfile=$logdir/${currdate}     mkdir -p $logdir     exec 1>$logfile     exec 2>$logfile } function mysqlconn () {     comm=$1     mysql -u${mysqluser} -p${mysqlpass} -S ${mysqlsocket} -e "$comm" } function checkrun () {     esport=$(lsof -i:$mysqlport|wc -l)     if [[ $esport -lt 2 ]]     then     echo "Mysql Server Failed"     exit 1     fi } function statuserror () {     for((i=0;i<${#allerror };i++))     do         if [[ "$1" == "${allerror[$i]}" ]]         then             mysqlconn "stop slave;set global sql_slave_skip_counter=1;start slave;"         else             echo "$nowtime MySQL slave is failed $1"         fi     done } function checkslave () {     status=($(mysqlconn "show slave status\G"|egrep -i "_running|last_errno"|awk '{print $NF}'))     if [[ "${status[0]}" == "Yes" ]] && [[ "${status[1]}" == "Yes" ]]     then         echo "MySQL Slave Ok"     else         statuserror ${status[2]}     fi } function main () {     while true     do         checkrun         checkslave         sleep 60     done } redirectlog main 二、相关日志都记录在 cat checkslave/20151226 |more 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452 12-26 16:16:00 MySQL slave is failed 1452