#! /bin/bash
#SCRIPT que mata processos si el servidor SQL esta en OFF


a=0
#Bucle infinit
while true
do


#COnsulta el status del servidor
UP=$(pgrep mysql | wc -l)

#Si esta down matar processos PHP
if [ "$UP" -ne 1 ]
then

  echo "MySQL is down."
  IDs=$(ps -ax | grep ".php$" | cut -f1 -d ' ')

  for id in $IDs
  do

    kill -9 $id >> sqldown.log
    date >> sqldown.log
  done


  #Si passen mes de dos minuts i segueix down, li fem start
  if [ "$a" -ge 60 ]
  then
    sudo systemctl start mysql
    a=0

  fi
  a=$((a+1))


#else

#  echo "All is well."

fi

sleep 2

done