How to restart MYSQL service if it crashes

Question

Mysql SQL Service Crashes when daily hit increases, how can I restart it as soon as it crashes?

Answer 1

Firstly, you can go to WHM Panel and search for "Service Manager" and select MOnitor option near by MYSQL.

 

If you do not have a WHM panel then go to SSH

Login and

Run this :

crontab -e

and add this code to the file

* * * * * /sbin/service mysql status || service mysql start

this checks every minute MYSQL status and if result is false then run service mysql start command.

Do not forget to save the file.