Auto Restart MySQL When It Crashes Ubuntu 18.04

Good Day, long enough not blogging on this site. This is my problem when I’m moving some websites into my cloud servers. Sometimes when my traffic going very high MySQL server crashes and I need to run it manually or reboot my server. This is really bad for SEO because my servers uptime will changed.

I am googling about this problem to find solution for resolve this issue and finally I found one is working for me.  Here is the steps you need to follow :

Create file (example /etc/startifdown.sh and write this code inside it:

#!/bin/bash

#Scripts to start services if not running

ps -ef | grep nginx |grep -v grep > /dev/null

if [ $? != 0 ]

then

/etc/init.d/nginx start > /dev/null

fi

ps -ef | grep php5-fpm |grep -v grep > /dev/null

if [ $? != 0 ]

then

/etc/init.d/php5-fpm start > /dev/null

fi

ps -ef | grep mysql |grep -v grep > /dev/null

if [ $? != 0 ]

then

/etc/init.d/mysql start > /dev/null

fi

Similar Posts:

• CRON JOB to Repair and Optimize Database
• PHP: How To Limit Download By IP Address Per Interval
• PHP: How To Blocking Bad Referrer Site
• How To: Created 2 Way SMS Gateway With NowSMS and PHP