[Zabbix] Mysql DB 모니터링

1. DB 설정

모니터링 할 DB쪽에 계정을 설정해줍니다.

MariaDB [(none)]> create user 'zabbixagent'@'%' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
 
MariaDB [(none)]> grant usage on *.* to 'zabbixagent'@'%';
Query OK, 0 rows affected (0.00 sec)
 
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
 
MariaDB [(none)]> quit
Bye

 

2. zabbix-agent 설정

$ mkdir -p /var/lib/zabbix
$ cat /var/lib/zabbix/.my.cnf
[client]
user=zabbixagent
password=password

$ cp -arp /usr/share/doc/zabbix-agent-5.2.5/userparameter_mysql.conf /etc/zabbix/zabbix_agentd.d/
$ vi /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
UserParameter=mysql.ping[*], mysqladmin -h"$1" -P"$2" ping
UserParameter=mysql.get_status_variables[*], mysql -h"$1" -P"$2" -sNX -e "show global status"
UserParameter=mysql.version[*], mysqladmin -s -h"$1" -P"$2" version
UserParameter=mysql.db.discovery[*], mysql -h"$1" -P"$2" -sN -e "show databases"
UserParameter=mysql.dbsize[*], mysql -h"$1" -P"$2" -sN -e "SELECT SUM(DATA_LENGTH + INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$3'"
UserParameter=mysql.replication.discovery[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"
UserParameter=mysql.slave_status[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"
 
$ service zabbix-agent restart
Redirecting to /bin/systemctl restart zabbix-agent.service

 

3. 템플릿 설정

 

{$MYSQL.HOST} 매크로 값에 IP를 적어줍니다.

MYSQL 최신 데이터를 갖고옵니다.