Cacti MySQL Template

Cacti MySQL Template

Percona MySQL Monitoring Template for Cacti

Percona MySQL Monitoring Template for Cacti

plugin download : http://www.percona.com/downloads/percona-monitoring-plugins/

Download & Installing

mkdir /usr/share/cacti/resource/percona
cd /usr/share/cacti/resource/percona

wget http://www.percona.com/downloads/percona-monitoring-plugins/1.1.4/percona-monitoring-plugins-1.1.4.tar.gz
tar zxf percona-monitoring-plugins-1.1.4.tar.gz
cd percona-monitoring-plugins-1.1.4/cacti/
cp scripts/ss_get_mysql_stats.php /usr/share/cacti/site/scripts

Configuring

vi scripts/ss_get_mysql_stats.php
-- OLD --
line 30:    $mysql_user = 'cactiuser';
line 31:    $mysql_pass = 'cactiuser';
line 32:    $mysql_port = 3306;
-- NEW --
line 30:    $mysql_user = 'mysqlID';
line 31:    $mysql_pass = 'mysqlPASSWORD';
line 32:    $mysql_port = 3306;

Import template

php /usr/share/cacti/cli/import_template.php --filename=/usr/share/cacti/resource/percona-monitoring-plugins-1.1.4/cacti/templates/cacti_host_template_percona_gnu_linux_server_ht_0.8.6i-sver1.1.4.xml --with-user-rras='1:2:3:4'

mysql setting

mysql -u root -p

mysql> GRANT SUPER, PROCESS ON *.* TO 'cacti'@'%' IDENTIFIED BY "mysqlPASSWORD";
mysql> flush privileges;
mysql> quit

Testing the Setup

 /usr/bin/php -q /usr/share/cacti/site/scripts/ss_get_mysql_stats.php --host localhost --items mm,mw,mx,my

data Template : search (percona검색후 나오는 모든 Template에 대해서 아래와 같이 DB설정