Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about how to monitor mysql through the percona plug-in in zabbix. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

1. Install the PHP script runtime environment

Yum install-y php php-mysql

two。 Load the official percona template

[root@cat /] # wget https://www.percona.com/downloads/percona-monitoring-plugins/1.1.6/percona-zabbix-templates-1.1.6-1.noarch.rpm[root@cat /] # rpm-ivh percona-zabbix-templates-1.1.6-1.noarch.rpm

3. If you enter the installed directory, you will see the following two directories

4. Modify database file

[root@cat scripts] # vim get_mysql_stats_wrapper.sh

[root@cat scripts] # vim ss_get_mysql_stats.php (change user and password)

Install the database

Yum install-y mariadb-servermysqladmin-uroot password 123456

5. Load zabbix_agent profile

[root@cat scripts] # cp / var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf / etc/zabbix/zabbix_agentd.d/chown-R zabbix.zabbix / tmp/localhost-mysql_cacti_stats.txt (change owner)

6. test

[root@m03 /] # zabbix_get-s 127.0.0.1-k "MySQL.Sort-scan"

31193

7.web interface

After reading the above, do you have any further understanding of how to monitor mysql through the percona plug-in in zabbix? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.