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

Note:

Experimental environment

CentOS Linux release 7.0.1406 (Core)

[root@localhost scripts] # mysql-v

Welcome to the MariaDB monitor. Commands end with; or\ g.

Your MariaDB connection id is 10683

Server version: 5.5.52-MariaDB MariaDB Server

Because I did it on a server, I need the following:

Zabbix_agentd httpd mysqld zabbix_server

1. Use the percona monitoring plug-in to monitor MySQL

[root@localhost alertscripts] # yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm

2. Percona components

PHP script

Shell script to call PHP script

Zabbix profile

Zabbix template file

3. Install percona-zabbix template PHP PHP-MySQL

[root@localhost alertscripts] # yum install percona-zabbix-templates php php-mysql

4. Check what software is installed

[root@localhost alertscripts] # rpm-qa php

[root@localhost scripts] # rpm-ql percona-zabbix-templates

/ var/lib/zabbix/percona

/ var/lib/zabbix/percona/scripts

/ var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh

/ var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php

/ var/lib/zabbix/percona/templates

/ var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf

/ var/lib/zabbix/percona/templates/zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.7.xml

[root@localhost scripts] #

5. Import template

/ var/lib/zabbix/percona/templates/zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.7.xml

6. Copy the configuration file

[root@localhost alertscripts] # cp / var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf / etc/zabbix/zabbix_agentd.d/

7. Where the script is stored

[root@localhost scripts] # pwd

/ var/lib/zabbix/percona/scripts

8. Restart the service

[root@localhost scripts] # systemctl restart zabbix-agent

9. Create a configuration file, content, user name, password.

[root@localhost scripts] # vim ss_get_mysql_stats.php.cnf

[root@localhost scripts] # cat ss_get_mysql_stats.php.cnf

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.