监控MYSQL主从复制时,SLAVE状态的简单脚本

#!/bin/bash
user=***
password=***

echo -e "please inpute slave portarl ip:"
read host

cd `dirname $0`
mysql -u$user -p$password -h$host -e "show slave status\G;" | grep -i running >slave.log
#grep -i, --ignore-case       
#            忽略大小写，包含要搜寻的样式及被搜寻的档案。

if [ `cat slave.log | grep -i io | awk '{print $2}'` = Yes ]
  then
     echo "slave IO process is OK"
else
     echo "slave IO process is error"
fi

if [ `cat slave.log | grep -i sql | awk '{print $2}'` = Yes ]
  then
     echo "slave SQL process is OK"
else
     echo "slave SQL process is error"
fi

rm -rf slave_status