Shulou(Shulou.com)05/31 Report--

This article mainly introduces "zabbix monitoring mysql database". In daily operation, I believe many people have doubts about zabbix monitoring mysql database. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "zabbix monitoring mysql database". Next, please follow the editor to study!

Zabbix monitors MySQL database

Although zabbix itself has its own template for MySQL monitoring, it cannot be used directly. Some additional configurations are needed to take effect.

Monitoring principle: you need to create a user to be monitored, and write the account number and password to a hidden file under the zabbix installation directory (security, the file must be hidden, otherwise the server side still cannot get the data). The server logs in the database by reading the account password in this configuration file to collect data, and then feeds the collected data back to the server, which is then displayed in web after processing by the server.

Zabbix version: 4.0

MySQL version: 5.5

Database-side operations:

Mysqlcheck is a newly created local account

Edit the hidden file:

Because zabbix is downloaded by yum, the path is / etc/zabbix

Restart, zabbix-agent.

You can test it with the zabbix_get command on the zabbix server side to see if you can get the data:

The second one is covered by the watermark: the content is "mysql.status [Uptime]"

Modify the configuration file:

Just put the template on the Web link:

At this point, the study on "zabbix Monitoring mysql Database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.