simple shell script which can restart mysql when your site down.

mysqlcheck.sh

log=autocheck.log
nflag=`curl --connect-timeout 3 --max-time 2 "http://callmet.zzgary.info/link/" -o $log`
# change the grep text according to your condition.
err=$?
# get the error code.
flag=`cat $log | grep "Database Error" -c`
pflag=`cat $log | grep "502 Bad Gateway" -c`
#echo $err;
#echo $flag;
#echo $pflag;
if [ $flag -eq 0 ] && [ $err -ne 28 ] && [ $pflag -eq 0 ] && [ $err -ne 7 ]; then
# all good.
echo "running normal";
elif [ $flag -ne 0 ]; then
# mysql down.
service mysql restart
elif [ $err -eq 7 ]; then
# nginx down
service nginx restart
elif [ $pflag -ne 0 ]; then
#php down
service php5-fpm restart
else
# restart both
service php5-fpm restart
service nginx restart
service mysql restart
fi
echo > autocheck.log
# clear the log file