MySQL服务健康检查脚本

#!/bin/sh
#date:2015-12-07
#filename:check_mysql.sh
#作者：linuxzkq

#Email:[e-mail]
#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