A simple Zabbix template i created to monitor essential MySQL Database metrics for an environment consisting of 5-10 different database instances on a single server. I can't guarantee this will work on zabbix versions other than 3.2, 3.4 or 4.2 but there's always only one way to find out isn't there.
-
If you want to use active monitoring with this template, i would advise against having all metrics using the mysqladmin "extended status" command polled on more than 5 instances per server as there is no caching functionality built into the discovery script; unlike the percona template. Having too many metrics polled on many MySQL instances will eat away at your CPU, particularly if you have a lot of insances on a single box and only one CPU.
-
Make sure "Include=/etc/zabbix/zabbix_agentd.d/" exists within the agent's "zabbix_agentd.conf" configuration file.
-
if you have the "skip_name_resolve" system variable enabled on any of the instances you wish to monitor, you will need to create a dedicated MySQL user with the localhost IP address instead of DNS i.e 'zabbix_mysql'@'127.0.0.1' (not 'zabbix_mysql'@'localhost'). Make sure this user is added to every instance you wish to monitor with all privileges on all databases and tables, otherwise monitoring won't work.
-
Install "mysql-lld-discover.sh" under /etc/zabbix/scripts/ ; Make it executable and test it returns the port numbers you expect.
-
Install "userparameters_mysql_multi.conf" under /etc/zabbix/zabbix_agentd.d/ ; Check that you can execute these commands as the zabbix user, then restart zabbix-agent.
sudo systemctl restart zabbix-agentIf restart fails, check you don't have any typos in the .conf file and if the same item keys exist elsewhere.
- Install "zabbix" under /etc/sudoers.d/ to allow Zabbix to run the netstat command with the -p flag as root (Best practice is to use visudo).
sudo visudo -f /etc/sudoers.d/zabbix- Install ".multi.cnf" under /etc/zabbix/ ; Change the credentials to those you desire and make sure this user+password is added to all your mysql instances that you wish to monitor (Refer to Tip 3).
sudo chown zabbix:zabbix /etc/zabbix/scripts/mysql-lld-discover.sh
sudo chmod 600 /etc/zabbix/scripts/mysql-lld-discover.sh- Test the script on the agent.
zabbix_agentd -t multi.questions[3306]
zabbix_agentd -t multi.questions[3307]
zabbix_agentd -t multi.questions[3308]- Test the script on the server.
zabbix_get -s <agent-ip> -P <zabbix-agent-port> -k multi.questions[3306]
zabbix_get -s <agent-ip> -P <zabbix-agent-port> -k multi.questions[3307]
zabbix_get -s <agent-ip> -P <zabbix-agent-port> -k multi.questions[3308]- Import the xml template to the Zabbix web interface.
Select screens options before importing.
Item and Trigger prototypes are listed under the Template's discovery tab, not items or triggers. Once added to a host, Zabbix will start gathering metric data. You might need to restart Zabbix server and/or Agent. Be patient.