MariaDB Galera 10.1+ Cluster Check and Restart

mariadb_galera_cluster_check_restart.sh

STFAILED="failed"
STRUNNING="active"
STSTOPPED="stopped"
STSTARTING="starting"

CMDBOOTSTRAP="/usr/bin/galera_new_cluster"

CMDSTART="systemctl start mysql"
STARTWAIT=15

GRFILE="/var/lib/mysql/grastate.dat"
GRSAFE="safe_to_bootstrap: 1"

STATUS="$(systemctl is-active mysql)"

if [ "$STATUS" == "STRUNNING" ]
then
  echo "running. all ok."
  exit
fi

if [ "$STATUS" == "$STFAILED" ]
then
  echo "Trying to start normally...."
  eval $CMDSTART
  sleep $STARTWAIT
  STATUS="$(systemctl is-active mysql)"
fi

if [ "$STATUS" == "STRUNNING" ]
then
  echo "running. all ok."
  exit
fi


if [ "$STATUS" == "$STFAILED" ]
then
  echo "Status is failed, checking grastate for safe_to_bootstrap.."
  if [ -f $GRFILE ]; then
    echo "Grfile exists..."
    if grep -q "$GRSAFE" "$GRFILE"; then
      echo "Node is ok for bootstrapping..."
      eval $CMDBOOTSTRAP
    else
      echo "This node cannot be bootstrapped"
    fi
  else
    echo "Grfile $GRFILE is missing :("
  fi
fi