#!/bin/bash -x

PATH=$PATH

# Chech to see if the messaging and datasource databases are configured.

ds_name_response=$(mysql --user=<%= mysql_replication_user %> --host=<%= mysql_master_ip_address %> --password=<%= mysql_replication_password %> --execute="show databases;" | grep <%= ds_name %>)
export ds_name_response
echo $ds_name_response

if [ $ds_name_response = '<%= ds_name %>' ]; then
    export response=True
    exit 1
else
    export response=False
    echo $response
    echo $ds_name_response
fi

rm /var/lib/mysql/<%= ds_name %>_verify_slave_status.out

response=TRUE
export $response

mysql --user=<%= mysql_replication_user %> --host=<%= mysql_master_ip_address %> --password=<%= mysql_replication_password %>  --execute="show slave status\G"  >  /var/lib/mysql/<%= ds_name %>_verify_slave_status.out

Slave_IO_Running=$(grep 'Slave_IO_Running:' /var/lib/mysql/<%= ds_name %>_verify_slave_status.out  | grep Yes | awk '{ print $2 }')
echo $Slave_IO_Running

if [ $Slave_IO_Running = "Yes" ]; then
    export response=True
else
    export response=False
    echo $response
    exit 1
fi

Slave_SQL_Running=$(grep 'Slave_SQL_Running:' /var/lib/mysql/<%= ds_name %>_verify_slave_status.out  | grep Yes | awk '{ print $2 }')
    echo $Slave_SQL_Running

if [ $Slave_SQL_Running = "Yes" ]; then
    export response=True
else
    export response=False
    echo $response
    exit 1
fi

Slave_IO_Stat=$(grep 'Slave_IO_State:' /var/lib/mysql/<%= ds_name %>_verify_slave_status.out  | grep 'Waiting for master to send event' | awk '{ print $6 }')
    echo $Slave_IO_Stat

if [ $Slave_IO_Stat = "send" ]; then
    export response=True
else
    export response=False
    echo $response
    exit 1
fi

Seconds_Behind_Master=$(grep 'Seconds_Behind_Master:' /var/lib/mysql/<%= ds_name %>_verify_slave_status.out | grep 0 | awk '{ print $2 }')
     echo $Seconds_Behind_Master

if [ $Seconds_Behind_Master  =  "0" ]; then
    export response=True
else
    export response=False
    echo $response
    exit 1
fi