监控mysql只需要用到两个文件:
cacti_host_template_x_mysql_server_ht_0.8.6i-sver1.1.8.xml
ss_get_mysql_stats.php
2、修改ss_get_mysql_stats.php文件
$mysql_user = 'cacti';
$mysql_pass = 'cacti';
mysql> grant process,super on *.* to 'cacti'@'192.168.20.12' identified by 'cacti';
mysql> grant all privileges on cacti.* to cacti@"192.168.20.12" identified by "cacti";
mysql> flush privileges;
4、将cacti_host_template_x_mysql_server_ht_0.8.6i-sver1.1.8.xml模版导入cacti,即可添加各项mysql监控
备注:一定要注释my.conf的bind-address = 127.0.0.1
cacti_host_template_x_mysql_server_ht_0.8.6i-sver1.1.8.xml
ss_get_mysql_stats.php
模版下载地址:http://code.google.com/p/mysql-cacti-templates/
2、修改ss_get_mysql_stats.php文件
$mysql_user = 'cacti';
$mysql_pass = 'cacti';
很显然看到第一个是监控mysql用的帐号,第二个则是密码
mysql> grant process,super on *.* to 'cacti'@'192.168.20.12' identified by 'cacti';
mysql> grant all privileges on cacti.* to cacti@"192.168.20.12" identified by "cacti";
mysql> flush privileges;
4、将cacti_host_template_x_mysql_server_ht_0.8.6i-sver1.1.8.xml模版导入cacti,即可添加各项mysql监控
备注:一定要注释my.conf的bind-address = 127.0.0.1