본문 바로가기

Monitoring Tools/Zabbix

14. [zabbix agent] mysql

반응형

1. zabbix_agentd.conf

UserParameter=mysql.ping[*], /usr/local/mysql/bin/mysqladmin -h"$1" -P"$2" -u"$3" -p"$4" ping
UserParameter=mysql.get_status_variables[*], /usr/local/mysql/bin/mysql -h"$1" -P"$2" -u"$3" -p"$4" -sNX -e "show global status"
UserParameter=mysql.version[*], /usr/local/mysql/bin/mysqladmin -s -h"$1" -P"$2" -u"$3" -p"$4" version
UserParameter=mysql.db.discovery[*], /usr/local/mysql/bin/mysql -h"$1" -P"$2" -u"$3" -p"$4" -sN -e "show databases"
UserParameter=mysql.dbsize[*], /usr/local/mysql/bin/mysql -h"$1" -P"$2" -u"$3" -p"$4" -sN -e "SELECT COALESCE(SUM(DATA_LENGTH + INDEX_LENGTH),0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$5'"
UserParameter=mysql.replication.discovery[*], /usr/local/mysql/bin/mysql -h"$1" -P"$2" -u"$3" -p"$4" -sNX -e "show all slaves status"
UserParameter=mysql.replication.discovery2[*], /usr/local/etc/scripts/db_replication_name.sh "$1" "$2" "$3" "$4"
UserParameter=mysql.slave_status[*], /usr/local/mysql/bin/mysql -h"$1" -P"$2" -u"$3" -p"$4" -sNX -e "show all slaves status"

 

2. db_replication_name.sh

#!/bin/sh
/usr/local/mysql/bin/mysql -h"$1" -P"$2" -u"$3" -p"$4" -e "show all slaves status \G"| grep "Master_Host" | awk '{print $2}'

 

3. zabbix server template

zbx_export_templates_mysql.xml
0.09MB

반응형

'Monitoring Tools > Zabbix' 카테고리의 다른 글

16. [zabbix agent] 스위치 템플릿  (0) 2021.03.17
15. [zabbix agent] SW huawei CE5850 for snmp  (0) 2021.03.17
13. [zabbix agent] keepalived  (0) 2021.03.17
12. [ zabbix agent] solr  (0) 2021.03.17
11. [zabbix agent] kafka  (0) 2021.03.17