Automatically reboot server

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>

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