Shell Script to Check the Status of MySQL Replication

!/bin/bash emailAddress="emailtoNotify@domain.com" cmd=mysql -e 'show slave status\G' | grep Slave_SQL_Running | awk '{print $2}' if [ "$cmd" == "No" ];then         MSG="Mysql Replication Broken on hostname, please check asap"         echo $MSG | mail -s "Replication Broken on hostname" $emailAddress fi

If you want to get the value of check to be 0 or 1 you can use the following :

mysql -e 'show slave status\G' | grep Slave_SQL_Running | awk '{print $2}' | sed 's/No/0/;s/Yes/1/'