检测 MySQL 是否宕掉，如果宕掉则启动

如果你的 MySQL 经常宕机，可以用这个脚本来实现宕机后自动启动，把它加到 crontab 里执行即可.

#!/bin/bash

 

result=` /usr/bin/mysqladmin ping `

expected= 'mysqld is alive'

 

if [[ "$result" != "$expected" ]]

then

echo "It's dead - restart mysql"

 

# email subject

SUBJECT= "[MYSQL ERROR] - Attempting to restart service"

 

# Email To ?

EMAIL= "admin@purui.cn"

 

# Email text/message

EMAILMESSAGE= "/tmp/emailmessage.txt"

echo "$result was received" > $EMAILMESSAGE

echo "when we were expected $expected" >>$EMAILMESSAGE

# send an email using /bin/mail

mail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGE

 

sudo /etc/init .d /mysql restart

fi