ここからいただいたのですが、エラーが出てしまったので。
MySQLのレプリケーションを監視するシェルスクリプト
#! /bin/sh
#
# watch replication
#
ALERT_TO="********@gmail.com";
ALERT_SUBJECT="[MySQL] replication alert";
CHECK_COMMAND="SHOW SLAVE STATUS\G";
ALLOW_DELAY_SECONDS=30;
echo "$CHECK_COMMAND";
slave_status=`mysql -u root -p******* -e "$CHECK_COMMAND"`;
echo "$slave_status";
# set variables from status
eval "`echo "$slave_status" | sed -ne 's/: \(.*\)/="\1"/p' `";
#eval "`mysql --defaults-extra-file=/root/.my.cnf -e 'show slave status \G' | sed -ne 's/: \(.*\)/="\1"/p' `";
echo "Slave_IO_RUNNING" $Slave_IO_Running;
if [ "$Slave_IO_Running" != "Yes" ]; then
msg="Slave_IO_Running : $Slave_IO_Runningn";
fi
echo "Slave_SQL_Running:" $Slave_SQL_Running;
if [ "$Slave_SQL_Running" != "Yes" ]; then
msg="${msg}Slave_SQL_Running : $Slave_SQL_Runningn";
fi
echo "Last_ERRNO" $Last_Errno;
if [ "$Last_Errno" != "0" ]; then
msg="${msg}Last_Error : [${Last_Errno}] $Last_Error";
fi
echo "Second_Behind_Master:" $Seconds_Behind_Master;
if [ "$Seconds_Behind_Master" -gt $ALLOW_DELAY_SECONDS ]; then
msg="${msg}Seconds_Behind_Master : $Seconds_Behind_Master";
fi
if [ "$msg" != "" ]; then
echo "n-- Need alert mail --";
echo "$msg";
(echo "${msg}n${CHECK_COMMAND}n${slave_status}" | mailx -s "$ALERT_SUBJECT" "$ALERT_TO");
fi
