How to automatically start MYSQL on crash in UBUNTU?

Question

bash

Tried like this

#!/bin/bash
PGREP="/usr/bin/pgrep"
RESTARTM="/etc/init.d/mysql restart"
MYSQLD="mysqld"
echo $PGREP ${MYSQLD}
if [ $? = 0 ]; then
$RESTARTM
fi

so

#!/bin/bash
TSTMYSQL=$(/etc/init.d/mysql status | grep stop) 
if [ "$TSTMYSQL" = "mysql stop/waiting" ]; then
/etc/init.d/mysql start 
fi

What am I doing wrong?

Answer 1

Many, many years ago, I wrote this to test for a crash in the winbind process. Starts on the crown.

entries=`ps -ax | grep $1 | grep -v grep | grep -v checkwbd | wc -l`
host=`/bin/hostname`
_host=${host%%.*}
_date=`/bin/date "+%b %d %T"`

if [ $entries -eq 0 ]; then
  cd /usr/local/etc/rc.d
  ./$2 start
  /usr/bin/logger -4 -i -t chkservice -p daemon.info $1 crash detected, process restarted
fi

checkwbd is the name of the script itself

Answer 2

Perhaps the immortal utility will help in this matter: https://immortal.run

Answer 3

write a systemd unit. he himself will monitor the working state of the program and restart in case of a fall.
Failure Restart options, etc.