zabbix远程mysql数据库_zabbix监控数据库

1. 在zabbix-agent端添加键值

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

UserParameter=mystat[*],/server/scripts/chk_mysql.sh '$1'　　# 键值是mystat[]

2. 服务端命令行测试键值

[root@zabbix ~]# zabbix_get -s 172.16.1.51 -k mystat[Uptime]

496

3. 编写脚本

[root@db01 log]# cat /server/scripts/chk_mysql.sh

1 #!/bin/bash2 # -------------------------------------------------------------------------------

3 # FileName: check_mysql.sh

4 # Revision: 1.0

5 # Date: 2018/01/31

6 # Author: chunk7 # Email:8 # Website:9 # Description:10 # Notes: ~

11 # -------------------------------------------------------------------------------

12 # Copyright:13 # License: GPL14

15 # 用户名16 MYSQL_USER='root'

17

18 # 密码19 MYSQL_PWD='oldboy123'

20

21 # 主机地址/IP22 MYSQL_HOST='10.0.0.51'

23

24 # 端口25 MYSQL_PORT='3306'

26

27 # 数据连接28 MYSQL_CONN="/usr/bin/mysqladmin -u${MYSQL_USER} -p${MYSQL_PWD} -h${MYSQL_HOST} -P${MYSQL_PORT}"

29

3