说明: > grant usage on *.* to zabbix@'zabbix agentd的内网ip' identified by 'zabbix'; > flush privileges
# cat /usr/local/zabbix/bin/mysql_status #!/bin/bash #use zabbix to monitor mysql status mysql=/usr/local/mysql/bin/mysql var=$1 MYSQL_USER=$2 MYSQL_PASSWORD=$3 MYSQL_Host=$4 [ "${MYSQL_USER}" = '' ] && MYSQL_USER=zabbix #mysql的zabbix用户 [ "${MYSQL_PASSWORD}" = '' ] && MYSQL_PASSWORD=zabbix #mysql的zabbix密码 [ "${MYSQL_Host}" = '' ] && MYSQL_Host=10.10.10.10 #zabbix agentd的内网ip [ "${var}" = '' ] && echo ""||${mysql} -h${MYSQL_Host} -u${MYSQL_USER} -p${MYSQL_PASSWORD} -e 'show status'|grep -v Variable_name|grep "\b${var}\b"|awk '{print $2}' # chmod +x /usr/local/zabbix/bin/mysql_status
# egrep -v "(^#|^$)" /etc/zabbix/zabbix_agentd.conf LogFile=/tmp/zabbix_agentd.log Server=127.0.0.1,10.10.10.9 #添加本机及zabbix server的ip ServerActive=127.0.0.1,10.10.10.9 #添加本机及zabbix server的ip Hostname=agent1 #agent名 Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/ #扩展配置目录 UnsafeUserParameters=1 #允许自定义key
# cat /usr/local/zabbix/zabbix_agentd.conf.d/mysql_status.conf UserParameter=mysql.status[*],/usr/local/zabbix/bin/mysql_status $1 UserParameter=mysql.ping,/usr/local/mysql/bin/mysqladmin ping -h"mysql IP" -uzabbix -pzabbix|grep alive|wc -l UserParameter=mysql.version,/usr/local/mysql/bin/mysql -h"mysql IP" -uzabbix -pzabbix -e "select version();"|awk 'END {print}'
# zabbix_get -s 10.10.10.10 -k mysql.status[Uptime] 3639025 # zabbix_get -s 10.10.10.10 -k mysql.version 5.5.24-CDB-3.0.0-log
若zabbix server无法获取数据可以zabbix agend上通过测试,
转载请保留固定链接: https://linuxeye.com/Linux/2654.html |