반응형
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
반응형
'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 |