#!/bin/bash
slave=$(mysql -umonitor -pmonitor -h 127.0.0.1 -e "show slave status\G" | grep Running | grep Yes | wc -l)
if (( $slave == 2 ))
then
echo "Slave is OK | Status=${slave}Yes;;;0"
exit 0
else
echo "Slave is Down | Status=${slave}Yes;;;0"
exit 2
fi
给monitor用户赋予mysql权限
GRANT REPLICATION CLIENT ON *.* TO 'monitor'@'127.0.0.1' IDENTIFIED BY 'monitor';