zabbix监控mysql

200
mysql linux zabbix
  1. zabbix客户端配置
  2. get测试
  3. zabbix web配置

zabbix客户端配置

创建mysql授权用户

1
2
>GRANT PROCESS ON *.* TO 'zabbix'@'localhost' identified BY 'zabbix';
>Flush privileges;

配置zabbix_agent

1
2
$ cat /usr/local/zabbix/etc/zabbix_agentd.conf | grep mysql
UserParameter=mysql.status[*],mysql -h localhost  -uzabbix -pzabbix -P 3006 -e "show global status" 2>/dev/null | grep "^$1\>"| awk '{print $NF}'

get测试

1
2
$ /usr/local/zabbix/bin/zabbix_get -s 127.0.0.1 -k mysql.status[Uptime]
30729

zabbix web配置

mysql监控模版git项目地址