cacti 增加 Mysql 监控

1.update yum source
rpm -Uvh   http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm
rpm -Uvh   http://apt.sw.be/redhat/el5/en/x86_64/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm

2.install software
yum install cacti httpd mysql-server net-snmp-utils rrdtool

3.mysql start
service mysqld restart

4. add database cacti for mysql
mysqladmin -user=root -p123456 create cacti
mysql cacti < /var/www/cacti/cacti.sql

5.modify cacti confile file for apache
vim /etc/httpd/conf.d/cacti.conf
delete lines below
deny from all
allow from 127.0.0.1

6.add user cacti for mysql
mysql -u root -p123456
GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY ‘cacti’;
flush privileges;

7.modify cacti config file
vi /var/www/cacti/include/config.php
$database_password = “cacti”;

8.add mysql template and script for cacti
wget http://mysql-cacti-templates.googlecode.com/files/mysql-cacti-templates-1.1.2.tar.gz
tar zxvf mysql-cacti-templates-1.1.2.tar.gz
cd mysql-cacti-templates-1.1.2
cp ss_get_mysql_stats.php cacti/sctipts/
chmod 777 ss_get_mysql_stats.php

9.reference
http://code.google.com/p/mysql-cacti-templates/