MySQLのSlaveの遅延をチェック　遅延発生で赤色に

while_show_slave_status.sh

#!/bin/sh

color() {
  printf '\033[%sm%s\033[m\n' "$@"
}

while true
do
  DATE=`date | sed -e 's/\r\n/\n/g' | sed -e 's/\n//g'`
  SBM=`echo "show slave status\G" | mysql -u root | grep Seconds | sed -e 's/      Seconds_Behind_Master: //g'`
  if [ $SBM -gt 0 ]; then
    color '31;1' "[$DATE] $SBM"
  else
    echo [$DATE] $SBM
  fi
  sleep 1
done