zabbix监控mysql mha_zabbix监控mysql脚本

zabbix监控mysql脚本

vim /usr/local/scripts/mysql_status.sh

#!/bin/bash

#Desc：zabbix 监控 MySQL 状态

#Date：2020-09-05

#by：Luojq

#主机

HOST="localhost"

#用户

USER="root"

#密码

PASSWORD="123456"

#端口

PORT="3306"

#MySQL连接

CONNECTION="mysqladmin -h ${HOST} -u ${USER} -P ${PORT} -p${PASSWORD}"

if [ $# -ne "1" ];then

echo "arg error!"

fi

case $1 in

Uptime)

result=`${CONNECTION} status 2>/dev/null |awk '{print $2}'`

echo $result

;;

Questions)

result=`${CONNECTION} status 2>/dev/null |awk '{print $6}'`

echo $result

;;

Com_update)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_update" |awk '{print $4}'`

echo $result

;;

Slow_queries)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Slow_queries" |awk '{print $4}'`

echo $result

;;

Com_select)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_select" |awk '{print $4}'`

echo $result

;;

Com_rollback)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_rollback" |awk '{print $4}'`

echo $result

;;

Com_insert)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_insert" |awk '{print $4}'`

echo $result

;;

Com_delete)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_delete" |awk '{print $4}'`

echo $result

;;

Com_commit)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_commit" |awk '{print $4}'`

echo $result

;;

Bytes_sent)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Bytes_sent" |awk '{print $4}'`

echo $result

;;

Bytes_received)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Bytes_received" |awk '{print $4}'`

echo $result

;;

Com_begin)

result=`${CONNECTION} extended-status 2>/dev/null |grep -w "Com_begin" |awk '{print $4}'`

echo $result

;;*)

echo "Usage:$0(Uptime|Questions|Com_update|Slow_queries|Com_select|Com_rollback|Com_insert|Com_delete|Com_commit|Bytes_sent|Bytes_received|Com_begin)"

;;

esac

vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

#获取MySQL性能指标，这个是上一步编辑好的脚本

UserParameter=mysql.status[*],/usr/local/scripts/mysql_status.sh $1

#获取MySQL运行状态

UserParameter=mysql.ping,mysqladmin -u root -h localhost -p123457 ping 2>/dev/null | grep -c alive

#获取MySQL版本

UserParameter=mysql.version,mysql -V

©著作权归作者所有：来自51CTO博客作者终而有始的原创作品，如需转载，请注明出处，否则将追究法律责任

我们一起来让这个世界有趣一点

赞赏

0人进行了赞赏支持