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