#!/bin/bash


PORT=` netstat -na| grep "LISTEN" | grep "3306" | awk -F[: " " ]+ '{print $4}' `
IP=` ifconfig eth0| grep "inet addr" | awk -F[: " " ]+ '{print $4}' `
IO_env=` echo $STATUS | grep IO | awk ' {print $2}' `

SQL_env=`echo$STATUS | grepSQL | awk'{print $2}'`

DATA=`date+"%y-%m-%d %H:%M:%S"`


if [ "$PORT" == "3306" ]
then
   echo "mysql is running"
else
   echo " $IP mysql is down " | mail -s " warn!server: $IP mysql is down" xxx@163.com

fi


if [ "$IO_env" = "Yes" -a "$SQL_env" = "Yes" ]
then
   echo "Slave is running!"

else

echo "Slave iserror!" | mail -s "warn! $DATA $IP MySQL Slave is not running" xxx@163.com

fi


然后每10分钟运行一次，编辑/etc/crontab文件，添加内容如下所示：

*/10* * * * root sh /root/mysql_slave.sh