Cacti Monitors multiple MySQL instances

Cacti Monitors multiple MySQL instances

The Cacti official website provides templates for monitoring MySQL. Only the default port 3306 can be monitored, but the current port is not 3306. How can we monitor it?

1. upload ss_get_mysql_stats.php to cacti/scripts/. By default, this script monitors mysql on port 3306. If you use other ports, we recommend that you change the script name to end with a port, ss_get_mysql_stats_3307.php, good habits are important.

2. modify cacti_host_template_mysql.xml, replace </name> with _ 3307 </name>, and change ss_get_mysql_stats.php to ss_get_mysql_stats_3307.php (this step is very important and has been found in many related documents, failed to monitor the plotting)

3. Execute perl change_hash.pl to change the hash value. The original template is not overwritten during the import. After the execution is successful, import cacti_host_template_mysql_3307.xml (skip this step if there is no mysql monitoring image)

4. Configure the monitoring host and wait for the plotting.

Note: The attachment is the required file, but it is not configured. You need to configure it yourself. Manual configuration will increase your memory. Go Brother!

------------------------------------------ Split line ------------------------------------------

Free in http://linux.bkjia.com/

The username and password are both www.bkjia.com

The specific download directory is/July 6,/July 2,/Cacti monitors MySQL multi-instance/

For the download method, see

------------------------------------------ Split line ------------------------------------------

Because there are too many images, only part of them will be uploaded.

-------------------------------------- Split line --------------------------------------

In RHEL6.4, the Cacti + Spine monitoring host is used to send mail alarms.

Configure Cacti to monitor MySQL database status

Use Cacti + Spine to monitor remote hosts in RHEL6.4

CentOS 5.5 complete installation of Cacti + Spine

Cacti construction document under CentOS 6

Detailed description of Cacti monitoring deployment under RHEL5.9

How to install Cacti in CentOS 6.3

Quick installation and configuration of Cacti in CentOS Linux

-------------------------------------- Split line --------------------------------------

Cacti details: click here
Cacti: click here

This article permanently updates the link address: