大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
主从监控插件编写:
大祥网站建设公司创新互联建站,大祥网站设计制作,有大型网站制作公司丰富经验。已为大祥近1000家提供企业网站建设服务。企业网站搭建\成都外贸网站建设要多少钱,请找那个售后服务好的大祥做网站的公司定做!
#!/bin/bash MySQL="/usr/local/mysql/bin/mysql -uslave -pslave12345 -h227.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<0.05) exit 0 ;else exit 1;}'` tmp_code=$? if [ -z $Uptime ];then echo "$MYSQL $@ 连接失败,请检查服务" && exit 2 fi if [ "$1" == "-s" ];then ##输出不同的信息 check_slave_results printf "主库:$Master_Host:$Master_Port Uptime:$Uptime Threads:$Threads_running Questions:$Questions Slow_queries:$Slow_queries Open_tables:$Open_tables Queries per second avg:%s Slave_IO_Running:$Slave_IO_Running Slave_SQL_Running:$Slave_SQL_Running Seconds_Behind_Master:$Seconds_Behind_Master|Threads=$Threads_running Questions=$Questions Slowqueries=$Slow_queries Opens=$Opened_tables Opentables=$Open_tables Queriespersecondavg=%s BehindMaster=$Seconds_Behind_Master" $PER_SECOND_QUESTION $PER_SECOND_QUESTION else ##输出不同的状态信息 printf "Uptime:$Uptime Threads:$Threads_running Questions:$Questions Slow_queries:$Slow_queries Open_tables:$Open_tables Queries per second avg:%s|Threads=$Threads_running Questions=$Questions Slowqueries=$Slow_queries Opens=$Opened_tables Opentables=$Open_tables Queriespersecondavg=%s" $PER_SECOND_QUESTION $PER_SECOND_QUESTION fi exit $code
mysql连接数监控:(监控mysql的最大连接数(最大连接数小于1000报警),和当前连接数 ,可用连接数少于50报警)
#!/bin/bash #MYSQL="/usr/local/mysql/bin/mysql -unagios -pmonitor_slave#status -h$3 -P" MYSQL="/usr/local/mysql/bin/mysql -unagios -pmonitor_slave#status -h227.0.0.1 -P" VAR_LOG=/tmp/check_mysql_status_con_$2.log && >$VAR_LOG #Threads_con_log=/tmp/check_mysql_tread_conn.log.$2 && >$Threads_con_log #Max_conn_log=/tmp/check_mysql_max_con.log.$2 && >$Max_conn_log function usage(){ cat <> $VAR_LOG #echo "$mysql_status" } function check_mysql_con_status(){ #echo $MYSQL $@ echo "show status like 'Threads_connected';" | $MYSQL$@ | perl -p -e 's/\s+(\w+)/="$1"/g' >> $VAR_LOG echo "show variables like 'max_connections';" |$MYSQL$@ | perl -p -e 's/\s+(\w+)/="$1"/g' >> $VAR_LOG #echo "$mysql_status" } function check_mysql_con_results(){ #echo "$max_connections,$Threads_connected" Residue_conn=$(($max_connections-$Threads_connected)) #echo $Residue_conn if [ $max_connections -lt 1000 ];then if [ $Residue_conn -lt 50 ] ;then code=2 else code=1 fi else code=0 fi } if [ $# -le 0 ] || [ "$1" == "-h" ];then usage fi code=0 check_mysql_status $2 check_mysql_con_status $2 . $VAR_LOG Residue_conn=$max_connections check_mysql_con_results $2 PER_SECOND_QUESTION=`echo "$Uptime $Queries" | awk '{printf ("%4.3f") ,$2/$1}END{if($2/$1<0.05) exit 0 ;else exit 1;}'` tmp_code=$? # if [ -z $Uptime ];then echo "$MYSQL $@ Connect Failed,Please check!" && exit 2 fi # printf "Uptime:$Uptime Threads_connected:$Threads_connected Max_connections:$max_connections Residue_connectios:$Residue_conn Open_tables:$Open_tables Queries per second avg:%s|Threads=$Threads_running Questions=$Questions Slowqueries=$Slow_queries Opens=$Opened_tables Opentables=$Open_tables Queriespersecondavg=%s" $PER_SECOND_QUESTION $PER_SECOND_QUESTION # exit $code