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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.