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

#!/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="[e-mail]"

 

# 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