Zabbix using its own template to monitor MySQL database

Source: Internet
Author: User
Tags root access

                           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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.