How do you check MySql status via cron

November 28, 2013 14.5k views
ryan1
By:
ryan1
Help, I am trying to setup a cron job that checks mysql status every few minutes and it down restarts it. Currently running the Ubuntu 12.10 WP Stack and have applied the swapfile tutorial too. So if yall can help, please do. ------------------------------------------ # Script mysql-check.sh #!/bin/bash /usr/bin/mysqladmin ping| grep 'mysqld is alive' > /dev/null 2>&1 if [ $? != 0 ] then sudo service mysql restart fi # Added to cron * * * * * sh -x /homesys-checks/mysql-check.sh ------------------------------------------ However it does not work and have know idea why.
Log In to Comment
4 Answers
media1 November 8, 2014

How about this in your /etc/crontab

# Restart MySQL if it's down
* * * * *    root      service mysql status || service mysql start

Adapted from :
http://superuser.com/questions/611197/auto-restart-mysql-when-it-dies

Reply
kamaln7 MOD November 28, 2013
Are you sure that the script's path is correct? /homesys-checks/mysql-check.sh Shouldn't /homesys-checks be /home/sys-checks?
Reply
pablo December 3, 2013
Check out How To Use a Simple Bash Script To Restart Server Programs.
How To Use a Simple Bash Script To Restart Server Programs
by Etel Sverdlov
This tutorial includes an incredibly simple bash script that checks if a certain program is running. If it is not running, the script will start it up. Additionally the tutorial includes steps on setting up the simple script as a cron job.
Reply
joao.guilherme December 15, 2015
Reply
Have another answer? Share your knowledge.