Debian auto check mysql proccess

Question

I have very often downs mysql for some reason.

I would like to learn how to make a script that would check does not fall if mysql is down - start it again.

service mysql start

Sorry for bad english!

Answer 1

install and use monit

http://mmonit.com/monit/

You can monitor the mysql process and if it is down monit can restart it for you.. a sample config might look like

check process mysql with pidfile /var/run/mysqld/mysqld.pid
   group database
   start program = "service mysql start"
   stop program = "service mysql stop"
   if failed host 127.0.0.1 port 3306 protocol mysql then restart
   if 5 restarts within 5 cycles then timeout