Mysql-cacti-templates-1.1.2.tar.gz free download cactiMySQL added monitoring

Mysql-cacti-templates-1.1.2.tar.gz free download cactiMySQL added monitoring

Added monitoring for cacti MySQL
1. Install the monitoring plug-in
Wget http://mysql-cacti-templates.googlecode.com/files/mysql-cacti-templates-1.1.2.tar.gz
If you can't download Baidu cloud disk has a http://pan.baidu.com/s/1hqH6VwK
Tar-xzvf mysql-cacti-templates-1.1.2.tar.gz
Mysql-cacti-templates-1.1.2 cp/ss_get_mysql_stats.php/var/www/html/cacti/scripts/
Chown-R cacti. cacti/var/www/html/cacti/scripts
Chmod-R 755/var/www/html/cacti/scripts

Import mysql-cacti-templates-1.1.2/cacti_host_template_x_db_server_ht_0.8.6i.xml using a browser to access the cacti host
Http: // 120.132.78.213/cacti/index. php

The default CactiEZ account and password are admin
Console-Import and Export-template import-browse
Select cacti_host_template_x_db_server_ht_0.8.6i.xml
Save

Configure the mysql plug-in of cacti
Modify ss_get_mysql_stats.php
Vi/var/www/html/scripts/ss_get_mysql_stats.php
Mysqluser = 'cacti ′; Mysql_pass = 'cacti ';

This account and password are the accounts and passwords authorized by the monitoring host to the Cacti host.
Cacti needs the account and password to connect to the monitored machine for status query.

Configure the monitored mysql instance to authorize the cacti host
Mysql-uroot-p
Grant process, super on .To 'cacti' @ '%' identified by 'cacti ';
Grant process, super on .To 'cacti' @ '10. 254.166.60 'identified by 'cacti ';
Flush privileges;

Meaning of this command
Only hosts with IP address 10.254.166.60 can access local data with the account cacti password cacti.

Monitor Mysql on the Cacti host (10.254.166.60)

4.1 Add a mysql module to the host

Console-Manage-device-select the previously created host

Move to the bottom to add a graphical template, select Mysql-related modules, and save

4.2 create a graph for the mysql Module

Console-create-Create Image-select this host-select mysql module-create

4.3 plug-in mysql performance data

Monitor-select the host-view the corresponding mysql

Finished