MySQL replication monitoring script

gistfile1.txt

#!/bin/bash
#
# Author: Aleksey Korzun

email='[email protected]'
default_max=60

echo "=========================================================================="
echo " Replicator Man v1.0.2                                                    "
echo "=========================================================================="

help() {
        echo "Usage: -h 127.0.0.1 [-a alias] [-m 120]" 1>&2;
        exit 1;
}

while getopts ":h:m:a:" o; do
    case "${o}" in
        h)
            h=${OPTARG}
            ;;
        a)
            a=${OPTARG}
            ;;
        m)
            m=${OPTARG}
            ;;
        *)
            help
            ;;
    esac
done
shift $((OPTIND-1))

if [ -z "${h}" ]; then
    help
fi

if [ -z "${a}" ]; then
   a=$h
fi

if [ -z "${m}" ]; then
   m=$default_max
fi

echo

response=`mysql -h $h -e 'SHOW SLAVE STATUS\G' | grep 'Seconds_Behind_Master' | awk -F': ' {' print $2 '}`

if [ "$response" == 'NULL' ] || ! [[ $response =~ ^-?[0-9]+$ ]] || [ "$response" -gt "$m" ]; then
        if [ ! -f "/tmp/replicatorman_$h" ]; then
                echo "Response: $response" | mail -s "Replication failure on $a" $email
                touch "/tmp/replicatorman_$h"
        fi

        echo 'FAILURE'
        exit 1
elif [ -f "/tmp/replicatorman_$h" ]; then
        echo "Response: $response" | mail -s "Replication recovery on $a" $email
        rm "/tmp/replicatorman_$h"
fi

echo 'SUCCESS'
exit 0