I have this script, I am using it to setup CRON job to execute this script, so it can check if MySQL service is running; if not then it restart the MySQL service:
#!/bin/bash
service mysql status| grep 'mysql start/running' > /dev/null 2>&1
if [ $? != 0 ]
then
sudo service mysql restart
fi
I have setup cron job as.
sudo crontab -e
and then added,
*/1 * * * * /home/ubuntu/mysql-check.sh
Problem is that it restart MySQL on every cron job execution.. even if server is running it restart the MySQL service what is correction in the script to do that.
I suspect that you setup the cron job to execute this script in your crontab file, and not in the root crontab file. This is not correct because if you don't run service mysql status as root, the mysql service will not be recognized.
So, modify the script as follow:
#!/bin/bash
if [[ ! "$(/usr/sbin/service mysql status)" =~ "start/running" ]]
then
/usr/sbin/service mysql start
fi
Be sure that is executable:
chmod +x /path/to/script
Then add a new entry in the root crontab as follow:
Edit root crontab file using:
sudo crontab -e
And add the following line to the file:
*/1 * * * * /path/to/script
Note: I have set the cron job for every minute, but you can change as you wish or as you think is better. See http://en.wikipedia.org/wiki/Cron in this sense.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments