mysqlrestarter

gistfile1.txt

#!/bin/bash

# Run every minute using cron:
# */1 * * * * /path/to/mysqlrestarter > /dev/null 2>&1

serverName="website.com"
adminEmail="[email protected]"

PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
UP=$(service mysql status | grep 'mysql start/running' | wc -l);

if [ "$UP" -eq 0 ]; then
  echo "MySQL is down: $(service mysql status)" | mail -s "Restarting MySQL on $serverName" -r "no-reply@$serverName" $adminEmail
  service mysql start
fi