Automatically reboot server

Posted June 10, 2014

I was wondering if there Is away to automatically reboot server if the database went unresponsive?

Submit an answer

You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

alexdo • October 17, 2020

Hello, @cameron1

You can create a simple bash script to check if MySQL is running and if not to restart it.

#!/bin/bash

# Check if MySQL is running
sudo service mysql status > /dev/null 2>&1

# Restart the MySQL service if it's not running.
if [ $? != 0 ]; then
    sudo service mysql restart
fi

Run this script every 5 minutes using a cron job like this one:

 */5 * * * * /home/user/scripts/monitor.sh > /dev/null 2>&1

Hope that this helps! Regards, Alex

digitalocean_ • June 11, 2014

Restart the whole machine? Or just the MySQL instance?

I’m thinking it’s the latter, in which case you can add a cronjob at your own desired interval which will periodically check if MySQL is running and start it if it is not. <pre> /etc/init.d/mysql status || /etc/init.d/mysql start </pre>