Entry

How can I use a shell script to make sure Mysql server is alive and restart it if it is not running?

Feb 12th, 2008 04:20
dman, josh oshiro, Brad Lay, Narendra Jain, Chris Ditty, http://sturly.com

You have to check if the mysql process is running with this command:

#ps -ef | grep mysql | grep -v grep
or
#ps -auxwww | grep mysql | grep -v grep

depending on which nix* your using.

Then check if the result of this command was 0 (success) or other than 
0 (failed).

If the result is other than 0 then it means that mysql is not running.

You should then start mysql with a command that looks something like 
this:

#mysql -u <user> --password='<password>'

This will do it all in one shot

#ps -ef | grep mysql | grep -v grep || mysql -u <user> --
password='<password>'

this says if mysql is not running run mysql

remember, if ps -ef does not work then try using ps -auxwww instead.



[added by brad]

I used this on my Debian 3.0 Unstable box, in cron.

0-59/1 * * * * ps -ef | grep mysqld | grep -v grep >> /dev/null 
|| /etc/init.d/mysql start

if its running, it just continues on its merry way, if its not, it 
starts it and emails you about it.

Works great. Nice and simple.