restart MySQL when the service is down

[enterume]

Hi,

Is anyone know how to do a chekcing routine to make sure the MySQL service is always up?

Thanks
Louis

[hand]

Which operating system?

[enterume]

Linux Redhat 7.x

[hand]

Use cron and connect to db using mysql in batch mode
(mysql < batch-file > mysql.out), and in the case of any error, restart mysql automatically

[enterume]

Hi Hand,

Can you please list out the step for me to add in the crontab?

Appreciate that.

Thanks
louis