Restart slave when it lags too much

restartslaveonlag

#!/bin/bash

U=user
P=pass
MYSQLCMD="mysql -u $U -p$P -BN -e"

while : ; do
  LAG=$($MYSQLCMD "select now()-ts as behind_by from maatkit.heartbeat limit 1;" | awk -F. '{print $1}')
  echo "$(date) $LAG"
  if [[ $LAG -gt 120 ]]; then
    echo "$(date) lag is higher than 120, restarting slave"
    mysqladmin -u $U -p$P stop
    mysqladmin -u $U -p$P start
  fi
  sleep 60
done