The method of mysql3.0 Monitoring mysql Database change

This article mainly gives you a brief talk about mysql3.0 monitoring mysql database changes method, related technical terms you can check online or find some related books to add, here will not dabble, we will go straight to the topic, hope mysql3.0 monitoring mysql database changes method This article can bring you some practical help.

1. Install Percona source first

# yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

2. Install zabbix Agent related components

# yum install -y percona-zabbix-templates

Also install:

# yum install php php-mysql -y

3. Copy configuration files

# cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/

4. Go to/var/lib/zabbix/percona/scripts directory and there are two configuration files to configure:

# vim get_mysql_stats_wrapper.sh

HOST=X.X (IP address of mysql)

vim ss_get_mysql_stats.php

$mysql_user = 'xx';

$mysql_pass = 'xx';

$mysql_port = xx;

/var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf The path to the get_mysql_stats_wrapper.sh file must be clearly seen, and write the path where you have this file locally!

After setting, you need to restart zabbix-agent to take effect

5. This scheme depends on php and php-mysql

# yum install php-mysql php -y

6. Testing

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

If there is any return data, it is OK.

After testing delete the *-mysql_cacti_status.txt file generated by/tmp and let the program call itself to create a new file (remember to remember)

7. Import template

Import zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.6.xml from/var/lib/zabbix/percona/templates into zabbix_server

Configuration --> Templates --> Import --> Select File

mysql3.0 monitoring mysql database changes method will first give you to talk about here, for other related issues we want to know can continue to pay attention to our industry information. Our section content captures some industry news and expertise to share with you every day.