mysql主从检测shell脚本
#!/bin/bash# check mysql slave status
while [ 1 ]
do
MAILTO=testwhocare@163.com
USER="check"
PSW="***"
WAITTIME=1800
#ADDR=""192.168.*.*" "192.168.*.*""
ADDR="192.168.*.*"
declare -a slave_is
for IP in $ADDR
do
slave_is=($(/usr/local/mysql/bin/mysql -h$IP -u${USER} -p${PSW} -e "show slave status\G"|grep Running|awk '{print $2}'))
if [ "${slave_is}" = "Yes" -a "${slave_is}" = "Yes" ]
then
echo -e "${IP} - Slave Status: \e \e[0m" > /app/sqlstatus
else
echo "${IP} - Slave Status: \e \e[0m" > /app/sqlstatus
cat "/app/sqlstatus" |mutt -s "mysql slave" $MAILTO
fi
sleep $WAITTIME
done
done
页:
[1]