自己编写Nagios 监控Mysql插件

lakers009

　　主从监控插件编写：
#!/bin/bash
MYSQL="/usr/local/mysql/bin/mysql -uslave -pslave12345 -h127.0.0.1 -P"
VAR_LOG=/tmp/check_mysql_status.log.$2 && >$VAR_LOG
function usage(){
cat  $VAR_LOG
#echo "$mysql_status"
}
function check_mysql_slave_status(){
#echo $MYSQL $@
echo "show slave status\G" | $MYSQL$@ | perl -p -e 's/:\s(.*)$/="$1"/g; s/^\s+//g; s/^\*.*\*//;' >> $VAR_LOG
}
function check_slave_results(){
if [ "$Slave_IO_Running" == "Yes" ] && [ "$Slave_SQL_Running" == "Yes" ];then
if [ $tmp_code -ne 0 ] && [ $Seconds_Behind_Master -gt 100 ] ;then
code=2
elif [ $Seconds_Behind_Master -lt 50 ] ;then
code=0
else
code=1
fi
else
code=2
fi      
}
if [ $# -le 0 ] || [ "$1" == "-h" ];then
usage
fi
if [ "$1" == "-s" ];then
#echo "检查从模式"
check_mysql_slave_status $2
fi
code=0
check_mysql_status $2
. $VAR_LOG
PER_SECOND_QUESTION=`echo "$Uptime $Queries" | awk '{printf ("%4.3f") ,$2/$1}END{if($2/$1