xdoujiang.com
、
#!/bin/bash
#--------------------------------------------------
#Author:jimmygong
#Email:[email protected]
#FileName:checkslave.sh
#Function:
#Version:1.0
#Created:2016-01-01
#--------------------------------------------------
if [[ `id -u` -ne 0 ]]
then
echo "script need root"
exit 1
fi
function usage ()
{
echo "Usage:bash $0 start"
echo "Usage:bash $0 stop"
}
if [[ $# -ne 1 ]]
then
usage
exit 1
fi
#
mysqluser="root"
mysqlpass="123456"
mysqlport=3398
mysqlsocket="/opt/mysql/$mysqlport/$mysqlport.sock"
currdate=$(date +%Y%m%d)
logpath="/root/checkslave"
logfile=$logpath/${currdate}
#
1158 , ,
1159 , ,
1008 ,
1007 ,
1062 ,
1452 ,
PS:1452
allerror=(1158 1159 1008 1007 1062 1452)
sleeptime=60
[[ -d $logpath ]] || mkdir $logpath
function echosucc ()
{
succstatus="[ Ok ]"
printf "\033[32m $succstatus $* \033[0m
"
}
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> $logfile
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 "$(date +"%m-%d %H:%M:%S") Mysql Slave Ok" >> $logfile
else
statuserror ${status[2]}
fi
}
function start ()
{
echosucc "Starting Monitor"
while true
do
checkrun
checkslave
sleep $sleeptime
done
}
function stop ()
{
echosucc "Stop Monitor"
echo $$ > "$logpath/pidfile"
for PID in $(ps -eo pid,command|grep "$0"|grep -v grep|awk '{print $1}');
do
[[ $PID != $(cat $logpath/pidfile) ]] && kill -s TERM $PID >& /dev/null
done
}
case $1 in
start)
start &
;;
stop)
stop
;;
*)
usage
;;
esac
、
cat checkslave/20160102 |more
01-02 21:19:10 Mysql Slave Failed 1452
01-02 21:19:10 Mysql Slave Failed 1452
01-02 21:19:10 Mysql Slave Failed 1452
01-02 21:19:10 Mysql Slave Failed 1452
01-02 21:19:10 Mysql Slave Failed 1452
01-02 21:34:58 Mysql Slave Ok
01-02 21:35:58 Mysql Slave Ok
01-02 21:36:59 Mysql Slave Ok
01-02 21:37:59 Mysql Slave Ok
、
ps -ef |grep -w checkslave.sh
root 12260 1 0 21:34 pts/2 00:00:00 bash checkslave.sh start
、
bash checkslave.sh start
[ Ok ] Starting Monitor
bash checkslave.sh stop
[ Ok ] Stop Monitor