zabbix low-level discovery 监控mysql
当一台服务器上MySQL有多个实例的时候，MySQL占用多个不同端口。利用zabbix的low-level discovery可以轻松监控。思路参考：http://dl528888.blog.51cto.com/2382721/1357713
下面我写了一个简单的脚本，用于一键部署mysql监控。
一、客户端
在被监控端运行此脚本,前提条件已经安装好了zabbix agent(推荐yum安装)。脚本已在CentOS6.2 x86_64环境下测试通过。脚本在附件提供下载。
#!/bin/sh## Filename: autoMonitorMysql.sh# Revision: 1.0# Date: 2014/08/12# Author: Qicheng# Email:# Website: http://qicheng0211.blog.51cto.com/# Description: zabbix low level discovery监控MySQL# Notes: 在被监控客户端运行此脚本,前提条件已经安装好zabbix agent# ROOT_UID=0if [ "$UID" -ne "$ROOT_UID" ];then echo "Error: 必须以root用户运行此程序！" exit 1fi # 自行修改为你的zabbix agent配置文件路径AGENT_CONF="/etc/zabbix/zabbix_agentd.conf" mkdir -p /etc/zabbix/monitor_scripts# 创建 mysql low-level discovery 脚本cat > /etc/zabbix/monitor_scripts/mysql_port_discovery.sh << 'EOF'#!/bin/bash#Function: mysql low-level discovery#Script_name: mysql_port_discovery.shmysql() { port=(`sudo /bin/netstat -tpln | awk -F "[ :]+" '/mysql/ && /0.0.0.0/ {print $5}'`) max_index=$[${#port[@]}-1] printf '{\n' printf '\t"data":[' for key in ${!port[@]} do printf '\n\t\t{' printf "\"{#MYSQLPORT}\":\"${port[${key}]}\"}" if [ $key -ne $max_index ];then printf "," fi done printf '\n\t]\n' printf '}\n'} case "$1" in mysql) "$1" ;; *) echo "Bad Parameter." echo "Usage: $0 mysql" exit 1 ;;esac EOFchown -R zabbix:zabbix /etc/zabbix/monitor_scriptschmod +x /etc/zabbix/monitor_scripts/mysql_port_discovery.sh # 判断配置文件是否存在[ -f "${AGENT_CONF}" ] || { echo "ERROR: File ${AGENT_CONF} does not exist.";exit 1;} include=`grep '^Include' ${AGENT_CONF} | cut -d'=' -f2`# 在配置文件中添加自定义参数if [ -d "$include" ];then cat > $include/mysql_lld.conf << 'EOF'UserParameter=mysql_port_discovery
[*],/bin/bash /etc/zabbix/monitor_scripts/mysql_port_discovery.sh $1UserParameter=mysql_status
[*],mysql -h 127.0.0.1 -P $1 -uzabbix -pzabbix -N -e "show global statuswhere Variable_name='$2'" 2>/dev/null | cut -f2UserParameter=mysql_ping
[*],mysqladmin -h 127.0.0.1 -P $1 -uzabbix -pzabbix ping 2>/dev/null | grep -c aliveEOFelse grep -q '^UserParameter=mysql_port_discovery' ${AGENT_CONF} || cat >> ${AGENT_CONF} << 'EOF'UserParameter=mysql_port_discovery
[*],/bin/bash /etc/zabbix/monitor_scripts/mysql_port_discovery.sh $1UserParameter=mysql_status
[*],mysql -h 127.0.0.1 -P $1 -uzabbix -pzabbix -N -e "show global statuswhere Variable_name='$2'" 2>/dev/null | cut -f2UserParameter=mysql_ping
[*],mysqladmin -h 127.0.0.1 -P $1 -uzabbix -pzabbix ping 2>/dev/null | grep -c aliveEOFfi# 手动MySQL授权，添加zabbix账户echo "请在所有MySQL实例中添加zabbix账户，执行> GRANT PROCESS ON *.* TO 'zabbix'@'127.0.0.1' identified BY 'zabbix';flush privileges;"# 重启agent服务[ -f '/etc/init.d/zabbix-agent' ] && /etc/init.d/zabbix-agent restart || echo "需手动重启zabbix agent服务."# 授权zabbix用户无密码运行netstat命令chmod +w /etc/sudoers sed -i 's/^\(Defaults\s\+requiretty\)/#\1/' /etc/sudoersgrep -q '^zabbix ALL=(ALL).*netstat' /etc/sudoers || echo 'zabbix ALL=(ALL) NOPASSWD: /bin/netstat' >> /etc/sudoerschmod 440 /etc/sudoers# 关闭SELinuxsetenforce 0sed -i '/^SELINUX=/c\SELINUX=disabled' /etc/sysconfig/selinuxsed -i '/^SELINUX=/c\SELINUX=disabled' /etc/selinux/config 脚本执行完毕后，还需要手动MySQL授权，在所有实例中添加zabbix账户：
mysql> GRANT PROCESS ON *.* TO 'zabbix'@'127.0.0.1' identified BY 'zabbix';mysql> flush privileges; 在zabbix server端执行zabbix_get命令测试：
shell# zabbix_get -s 115.238.xxx.xxx -k 'mysql_port_discovery'{ "data":[ {"{#MYSQLPORT}":"3306"} ]}shell# zabbix_get -s 115.238.xxx.xxx -k 'mysql_status'1295092shell# zabbix_get -s 115.238.xxx.xxx -k 'mysql_ping'1 都能返回数据，说明客户端的MySQL监控部署好了。
二、WEB端
1、导入模板
下载附件模板文件(Template App MySQL used LLD.xml)后，导入到zabbix里。
2、创建主机并链接模板
3、数据展示
本文出自 “启程的Linux博客” 博客，请务必保留此出处http://qicheng0211.blog.51cto.com/3958621/1539101
页:
[1]