db_monitor.sh

#!/bin/bash
UP=$(pgrep mysql | wc -l);
if [ "$UP" -eq 0 ];
then
        curl -X POST -H 'Content-type: application/json' --data '{"text":"⚠️ MySQL Database is down [*SITE_NAME*]"}' https://hooks.slack.com/services/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;
        systemctl restart mysql;
        curl -X POST -H 'Content-type: application/json' --data '{"text":"🚀 MySQL Database has been restarted [*SITE_NAME*]"}' https://hooks.slack.com/services/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;

else
        echo "MySQL Database is running [*SITE_NAME*]";
fi

mysql_monitor.md

1. Create script
   db_monitor.sh

UP=$(pgrep mysql | wc -l);
if ["$UP" -eq 0];
then
        curl -X POST -H 'Content-type: application/json' --data '{"text":"MySQL Database is down [SITE_NAME]"}' https://hooks.slack.com/services/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;
        systemctl restart mysql;
        curl -X POST -H 'Content-type: application/json' --data '{"text":"MySQL Database has been restarted [SITE_NAME]"}' https://hooks.slack.com/services/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;

else
        echo "MySQL Database is running [SITE_NAME]";
fi

2. Add db_monitor.sh to server
   (e.g. /etc/scripts/db_monitor.sh)

3. Open
   crontab -e

4. Add in script
   */5 * * * * /etc/scripts/db_monitor.sh

5. Save and check cron jobs
   crontab -l