Vesta mysql check status & restart script (Cron Job)

v-mysql-restart

#!/bin/bash

# @yasinkuyu 
# Vesta mysql check status & restart script (Cron Job)

# cd /usr/local/vesta/bin/
# Create v-mysql-restart file
# CRON: */5 * * * * sudo /usr/local/vesta/bin/v-mysql-restart
# 5 minute

# Importing system variables
source /etc/profile

# Email notification
[email protected]

# Argument definition
user=$1
notify=${2-no}

# Includes
source $VESTA/func/main.sh
source $VESTA/func/domain.sh
source $VESTA/func/db.sh
source $VESTA/conf/vesta.conf

if [[ ! "$(service mysqld status)" = *"is running"* ]]
then
    now=$(date +"%T")
    if [[ ! "$(service mysqld start)" = *"Daemon failed to start"* ]]
        reboot
        echo "SYSTEM REBOOT SUCCESSFUL $now" | mail -s "SYSTEM REBOOT SUCCESSFUL $now" $email
        exit 1
    then
        if [ "$?" -ne 0 ]; then
            echo "MYSQL ERROR: NOT RESTART $now" | mail -s "MYSQL ERROR: NOT RESTART $now" $email
            exit 1
        fi
        echo "MYSQL RESTART SUCCESSFUL $now" | mail -s "MYSQL RESTART SUCCESSFUL $now" $email
    fi
    exit
fi
exit