MySQL Tools

mysql_rep_delay.bash

#!/bin/bash

MYSQL_USER="mysql"
MYSQL_PASS="password"
MYSQL_HOST_MASTER[0]="192.168.0.1"
MYSQL_HOST_MASTER[1]="192.168.0.2"
MYSQL_HOST_SLAVE[0]="192.168.0.2"
MYSQL_HOST_SLAVE[1]="192.168.0.3"

echo "------------------"
echo "### MASTER HOST ###"
for host in ${MYSQL_HOST_MASTER[@]}; do
    echo -n "   ### $host : "
    mysql -u "${MYSQL_USER}" -p"${MYSQL_PASS}" -h ${host} -e 'show master status\G' | grep "Pos" | awk '{print $NF}'
done

echo "------------------"
echo "### SLAVE HOST ###"
for host in ${MYSQL_HOST_SLAVE[@]}; do
    echo -n "   ### $host : "
    mysql -u "${MYSQL_USER}" -p"${MYSQL_PASS}" -h ${host} -e 'show slave status\G' | grep "Exec_Master_Log_Pos" | awk '{print $NF}'
done
echo "------------------"

http://www.percona.com/doc/percona-toolkit/2.1/pt-heartbeat.html