monitoring mysql with cacti

By default, cacti don't come with mysql graphing template. Here is the plugin that help you graphing mysql important data.

The installation is like the other plugins.
1) copy php script to cacti host /script directory
2) import template using web interface
3) add mysql user to mysql host
4) have fun :)


plugin document/download :
http://code.google.com/p/mysql-cacti-templates/wiki/InstallingTemplates

author blog:
http://www.xaprb.com/blog/2009/10/25/version-1-1-4-of-improved-cacti-templates-released/

rrdtool tune rra file

Using SNMP and cacti, you need to adjust rrd file manually for displaying graph correctly.

/cacti/rra
show file info to see the limitation of value
#rrdtool info filename.rrd

tunning it
#rrdtool tune filename.rrd --maximum cpu_user:800

gentoo SNMP

Installing SNMP in gentoo for system monitoring.


#emerge net-snmp

edit /etc/snmp/snmpd.conf add the following
com2sec Mybox localhost public
com2sec cacti 192.168.1.0/24 public

group RWGroup v2c Mybox
group ROGroup v1 cacti
group ROGroup v2c cacti

view all included .1 80
view system included system fe

access ROGroup "" any noauth exact all none none
access RWGroup "" v2c noauth exact all all all

#rc-update add snmpd default