!/bin/bash emailAddress="emailtoNotify@domain.com
[emailAddress=%22emailtoNotify@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