fduran · October 1, 2014 17:15
diff --git a/check and alert if mysql slave is not running b/check and alert if mysql slave is not running
 #!/bin/bash
 # check if mysql slave is running

 log=/var/log/mysqlslave.log
 [email protected]

 date >> $log
 res=`mysql -u root -pPassword -h db.example.com -N -B -e "show status like 'Slave_running'"|cut -f2`

 if [ $res = 'ON' ]
 then
  echo 'running' >> $log
 else
  echo 'NOT RUNNING' >> $log
  echo "Mysql slave not running" |mail -s "Slave not running" $email
 fi
	#!/bin/bash
	# check if mysql slave is running

	log=/var/log/mysqlslave.log
	[email protected]

	date >> $log
	res=`mysql -u root -pPassword -h db.example.com -N -B -e "show status like 'Slave_running'"\|cut -f2`

	if [ $res = 'ON' ]
	then
	echo 'running' >> $log
	else
	echo 'NOT RUNNING' >> $log
	echo "Mysql slave not running" \|mail -s "Slave not running" $email
	fi