Check MySQL Replication Slave is running. If not will email to sysadmin using mailgun

checkslave.sh

#!/bin/bash
COUNT=`'SHOW SLAVE STATUS\G' | mysql -u root --password=password123 mysql | grep 'Master_Log_Pos' | awk '/Read/{a=$NF} /Exec/{b=$NF} END{print a-b}'`
# echo "count" $COUNT
# check if COUNT value is zero or not zero
if [ $COUNT -gt 0 ]; then
	curl -s --user 'api:key-getyourkeyatmailgun' \
        https://api.mailgun.net/v3/mg.shafiqmustapa.my/messages \
        -F from='MySQL Replication Status <postmaster@mg.shafiqmustapa.my>' \
        -F to='Shafiq Mustapa <sicksand@gmail.com>' \
        -F cc='Project Manager <pm@zanko.com.my>, Support <support@zanko.com.my>, ' \
        -F subject='Please check MySQL Replication Status' \
        -F text="Ada beza logs. $COUNT"
fi