#!/bin/bash
# Check MySQL Slave Runnning Status
# crontab ：*/10 * * * *
# show slave status
IP=`ifconfig eth0|grep "inet addr" | awk -F[:" "]+ '{print $4}'`
STATUS=$(/usr/bin/mysql -uroot -p11111 -e "show slave status\G" | grep -i "running")
IO_env=`echo $STATUS | grep IO | awk ' {print $2}'`
SQL_env=`echo $STATUS | grep SQL | awk '{print $2}'`
logFile=/data/mysqlbackup/logs/CheckMysqlStatus.log
DATE=`date +"%Y%m%d_%H:%M:%S"`
if [ "$IO_env" = "Yes" -a "$SQL_env" = "Yes" ]
then
echo "MySQL Slave is running!"
else
echo "####### $DATE #########">> $logFile
echo "MySQL Slave is not running!" >> $logFile
echo "MySQL Slave is not running!" | mail -s "WARN! $IP MySQL Slave is not running." admin@yourdomain.com
fi
