Zabbix using its own template to monitor MySQL database

　　　　　　　　　　　　　　　　　　　　　　　　　　　Zabbix using its own template to monitor MySQL database

Yun Zhengjie

Some things you don't think it's particularly difficult when you do it, but when you do it you find it so simple ~zabbix powerful I'm not here tell me more, okay?

So that you can use to know, haha ...

In fact, Zabbix monitoring agent side of the MySQL database is very simple principle is that you need to create a new user in the Zabbix client, the user's The account password is stored in

hidden files, (also consider security ~), the server by reading this configuration file user password to log into the database, and then The result of the acquisition is fed back to the client,

Remember that we do not give root access to the user yo ~ (because some companies operation and maintenance of the Monitoring department can not know one person) Well, don't say much nonsense, let's configure it together.

1. Create a new database user and password on the agent side

Log in to the database as an administrator

Test whether the creation was successful:

2. Edit the configuration file, this file does not exist, note that there is a point in front of this file, compared to people do not know a file in front of a hidden file.

3. Save exit and make sure you have this profile in the appropriate directory

4. Copy the configuration file, this is the installation package comes with, so we do not have to customize the template

[Email protected] ~]# cp/yinzhengjie/zabbix-3.0.4/conf/zabbix_agentd/userparameter_mysql.conf/usr/local/zabbix/ etc/zabbix_agentd.conf.d/

[Email protected] ~]# vim/usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf

5. On the server's Web Segment link template, this basically is the monitoring success.

Zabbix using its own template to monitor MySQL database