mysql健康检查_MySQL服务健康检查脚本

#!/bin/sh

#date:2015-12-07

#filename:check_mysql.sh

#作者：linuxzkq

#Email:[email protected]

#version:v1.0

#port=`netstat -tunlp|grep 3306|wc -l`

#process=`ps -ef|grep mysqld|grep -v grep|wc -l`

value=`/application/mysql/bin/mysql -u root -poldboy -e "select version();" >/dev/null 2>&1`

while  true

do

if [  $?  -ne  0  ]

then

#echo "ERROR! MySQL is not running"

/etc/init.d/mysqld start

else

echo "MySQL is running,now!"

fi

sleep 5

value=`/application/mysql/bin/mysql -u root -poldboy -e "select version();" >/dev/null 2>&1`

if [  $?  -ne  0  ]

then

#echo "ERROR! MySQL is not running"

/etc/init.d/mysqld start

else

echo "MySQL is running,now!"

fi

sleep 5

done

原文：http://linuxzkq.blog.51cto.com/9379412/1728877