shell MySQL服務狀態檢查腳本示例

閒來無事，自己寫了一個mysql進程檢查的腳本。想想初學編程時候到處去網上搜的經歷，忽然想笑。我是運維工程師，我也想說：“I am a Coder!”。

#!/bin/bash
#DATE 2013/11/25
#MAIL [email protected]
#FUNCTION check the mysql status,if not run start mysql.
#Create by Chenchao Gao
checkMysql(){
CMDCHECK=`lsof -i:3306 &>/dev/null`
Port="$?"
PIDCHECK=`ps aux|grep mysqld|grep -v grep`
PID="$?"
if [ "$Port" -eq "0" -a "$PID" -eq 0 ];then
return 200
else
return 500
fi
}
startMysql(){
/etc/init.d/mysqld start
}
checkMysql
if [ $? == 200 ];then
echo "Mysql is running..."
else
startMysql
checkMysql
if [ $? != 200 ];then
while true
do
killall mysqld
sleep 2
[ $? != 0 ]&&break
done
startMysql
fi
fi