mysql-test

#!/bin/sh
# 
# Mysql-test 
# A little script to test if you mysql or mariadb is running. 
# If the database is up, only logs, if the database is down, the script starts the database again 
# Test on a Ubuntu Server 
#
# Author: Ataliba Teixeira 
# 
#########################################################################

mysqladmin ping > /dev/null 2>&1 && up=1 || up=0


if [ $up -eq 0 ] ; then

  /sbin/systemctl restart mysql.service
  /usr/bin/logger -t Mysql-test "O mysql estava parado e foi reiniciado"
else
   /usr/bin/logger -t Mysql-test "O mysql esta rodando"

fi