监控mysql运行状态，停止则重启

12 年 ago jony 监控mysql运行状态，停止则重启已关闭评论

#!/bin/sh
#
PORT=`netstat -na|grep "LISTEN"|grep "3306"|awk -F[:" "]+ '{print $5}'`
#MYSQLIP=`ifconfig eth0|awk '/inet/{print $2}'|cut -c 6-`
while [ `whoami` == "root" ]
do
if [ "$PORT" == "3306" ];then
echo "mysql is running......"
else
echo "restart mysql"
/etc/init.d/mysqld restart
echo "$PORT"
if [ "$PORT" == "3306" ];then
echo "mysql restart successful......"
else
echo "mysql restart successful......"
fi
fi
break
done

赋予check_mysql.sh可执行的权限

加入crontab，让系统五分钟检测一次mysql状态
#crontab -b

  1. */5 * * * * /usr/local/sbin/check_mysql.sh > /dev/null 2>&1