CACTI :使用模板监控本地或其他服务器上的mysql
来源:程序员人生 发布时间:2015-07-24 09:50:59 阅读次数:4507次
mysql 的模板,网上都在使用的这个地址http://mysql-cacti-templates.googlecode.com 已访问不到了
Google找到这个网址:
介绍篇:
http://www.percona.com/doc/percona-monitoring-plugins/1.0/cacti/mysql-templates.html
下载页:http://www.percona.com/downloads/percona-monitoring-plugins/
为了方便大家下载,上传到csdn可供下载: http://download.csdn.net/detail/kk185800961/8651279
当前下载的文件:percona-cacti-templates⑴.1.4⑴.noarch.rpm
本地服务器监控本地mysql:
进入到cacti所在目录
cd /var/www/html
将紧缩文件移到当前目录(放那都行):
mv percona-cacti-templates⑴.1.4⑴.noarch.rpm .
解压文件:
rpm2cpio percona-cacti-templates⑴.1.4⑴.noarch.rpm | cpio -div
在当前目录下将生产以下目录及文件:
./usr/share/cacti/resource/percona
./usr/share/cacti/resource/percona/bin
./usr/share/cacti/resource/percona/bin/pmp-cacti-extract-template
./usr/share/cacti/resource/percona/bin/pmp-cacti-graph-defs
./usr/share/cacti/resource/percona/bin/pmp-cacti-make-hashes
./usr/share/cacti/resource/percona/bin/pmp-cacti-template
./usr/share/cacti/resource/percona/definitions
./usr/share/cacti/resource/percona/definitions/apache.def
./usr/share/cacti/resource/percona/definitions/galera.def
./usr/share/cacti/resource/percona/definitions/gnu_linux.def
./usr/share/cacti/resource/percona/definitions/jmx.def
./usr/share/cacti/resource/percona/definitions/memcached.def
./usr/share/cacti/resource/percona/definitions/mongodb.def
./usr/share/cacti/resource/percona/definitions/mysql.def
./usr/share/cacti/resource/percona/definitions/nginx.def
./usr/share/cacti/resource/percona/definitions/openvz.def
./usr/share/cacti/resource/percona/definitions/rds.def
./usr/share/cacti/resource/percona/definitions/redis.def
./usr/share/cacti/resource/percona/misc
./usr/share/cacti/resource/percona/misc/jmx-monitor.xml
./usr/share/cacti/resource/percona/templates
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_apache_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_galera_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_gnu_linux_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_jmx_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_memcached_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_mongodb_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_mysql_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_nginx_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_openvz_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_rds_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/resource/percona/templates/cacti_host_template_percona_redis_server_ht_0.8.6i-sver1.1.4.xml
./usr/share/cacti/scripts/ss_get_by_ssh.php
./usr/share/cacti/scripts/ss_get_mysql_stats.php
./usr/share/cacti/scripts/ss_get_rds_stats.py
现在只要mysql的两个文件:
ss_get_mysql_stats.php
cacti_host_template_percona_mysql_server_ht_0.8.6i-sver1.1.4.xml
拷贝ss_get_mysql_stats.php到cacti目录中:
cp ./usr/share/cacti/scripts/ss_get_mysql_stats.php /var/www/html/cacti/scripts/
编辑文件,确认用户名和密码正确:
vi /var/www/html/cacti/scripts/ss_get_mysql_stats.php
$mysql_user = 'cacti';
$mysql_pass = 'cacti';
导入模板:打开cactiy页面――>Console――>Import Templates――>阅读添加
导入结果:
Import Results
Cacti has imported the following items:
CDEF
[success] Percona Turn Into Bits CDEF [new]
[success] Percona Negate CDEF [new]
GPRINT Preset
[success] Percona MySQL Server Checksum 523e4d8178a000df8df3a9825c4e7e1e [new]
[success] Percona MySQL Server Version t1.1.4:s1.1.4 [new]
[success] Percona Normal [new]
Data Input Method
[success] Percona Get MySQL Stats/MyISAM Indexes IM [new]
[success] Percona Get MySQL Stats/MyISAM Key Cache IM [new]
[success] Percona Get MySQL Stats/InnoDB Buffer Pool IM [new]
[success] Percona Get MySQL Stats/InnoDB I/O IM [new]
[success] Percona Get MySQL Stats/InnoDB Insert Buffer IM [new]
[success] Percona Get MySQL Stats/InnoDB Insert Buffer Usage IM [new]
[success] Percona Get MySQL Stats/InnoDB Semaphores IM [new]
[success] Percona Get MySQL Stats/InnoDB Row Operations IM [new]
[success] Percona Get MySQL Stats/MySQL Table Locks IM [new]
[success] Percona Get MySQL Stats/MySQL Connections IM [new]
[success] Percona Get MySQL Stats/MySQL Replication IM [new]
[success] Percona Get MySQL Stats/MySQL Query Cache IM [new]
[success] Percona Get MySQL Stats/MySQL Query Cache Memory IM [new]
[success] Percona Get MySQL Stats/MySQL Command Counters IM [new]
[success] Percona Get MySQL Stats/MySQL Select Types IM [new]
[success] Percona Get MySQL Stats/MySQL Sorts IM [new]
[success] Percona Get MySQL Stats/MySQL Temporary Objects IM [new]
[success] Percona Get MySQL Stats/MySQL Network Traffic IM [new]
[success] Percona Get MySQL Stats/InnoDB Buffer Pool Activity IM [new]
[success] Percona Get MySQL Stats/InnoDB I/O Pending IM [new]
[success] Percona Get MySQL Stats/InnoDB Log IM [new]
[success] Percona Get MySQL Stats/MySQL Binary/Relay Logs IM [new]
[success] Percona Get MySQL Stats/InnoDB Transactions IM [new]
[success] Percona Get MySQL Stats/InnoDB Transactions Active/Locked IM [new]
[success] Percona Get MySQL Stats/MySQL Files and Tables IM [new]
[success] Percona Get MySQL Stats/MySQL Threads IM [new]
[success] Percona Get MySQL Stats/InnoDB Memory Allocation IM [new]
[success] Percona Get MySQL Stats/InnoDB Adaptive Hash Index IM [new]
[success] Percona Get MySQL Stats/InnoDB Internal Hash Memory Usage IM [new]
[success] Percona Get MySQL Stats/InnoDB Tables In Use IM [new]
[success] Percona Get MySQL Stats/InnoDB Current Lock Waits IM [new]
[success] Percona Get MySQL Stats/InnoDB Lock Structures IM [new]
[success] Percona Get MySQL Stats/InnoDB Checkpoint Age IM [new]
[success] Percona Get MySQL Stats/InnoDB Row Lock Time IM [new]
[success] Percona Get MySQL Stats/InnoDB Row Lock Waits IM [new]
[success] Percona Get MySQL Stats/InnoDB Semaphore Waits IM [new]
[success] Percona Get MySQL Stats/InnoDB Semaphore Wait Time IM [new]
[success] Percona Get MySQL Stats/MySQL Processlist IM [new]
[success] Percona Get MySQL Stats/MySQL Transaction Handler IM [new]
[success] Percona Get MySQL Stats/MySQL Handlers IM [new]
[success] Percona Get MySQL Stats/MySQL Query Time Histogram (Count) IM [new]
[success] Percona Get MySQL Stats/MySQL Query Response Time (Microseconds) IM [new]
[success] Percona Get MySQL Stats/InnoDB Buffer Pool Efficiency IM [new]
Data Template
[success] Percona MyISAM Indexes DT [new]
[success] Percona MyISAM Key Cache DT [new]
[success] Percona InnoDB Buffer Pool DT [new]
[success] Percona InnoDB I/O DT [new]
[success] Percona InnoDB Insert Buffer DT [new]
[success] Percona InnoDB Insert Buffer Usage DT [new]
[success] Percona InnoDB Semaphores DT [new]
[success] Percona InnoDB Row Operations DT [new]
[success] Percona MySQL Table Locks DT [new]
[success] Percona MySQL Connections DT [new]
[success] Percona MySQL Replication DT [new]
[success] Percona MySQL Query Cache DT [new]
[success] Percona MySQL Query Cache Memory DT [new]
[success] Percona MySQL Command Counters DT [new]
[success] Percona MySQL Select Types DT [new]
[success] Percona MySQL Sorts DT [new]
[success] Percona MySQL Temporary Objects DT [new]
[success] Percona MySQL Network Traffic DT [new]
[success] Percona InnoDB Buffer Pool Activity DT [new]
[success] Percona InnoDB I/O Pending DT [new]
[success] Percona InnoDB Log DT [new]
[success] Percona MySQL Binary/Relay Logs DT [new]
[success] Percona InnoDB Transactions DT [new]
[success] Percona InnoDB Transactions Active/Locked DT [new]
[success] Percona MySQL Files and Tables DT [new]
[success] Percona MySQL Threads DT [new]
[success] Percona InnoDB Memory Allocation DT [new]
[success] Percona InnoDB Adaptive Hash Index DT [new]
[success] Percona InnoDB Internal Hash Memory Usage DT [new]
[success] Percona InnoDB Tables In Use DT [new]
[success] Percona InnoDB Current Lock Waits DT [new]
[success] Percona InnoDB Lock Structures DT [new]
[success] Percona InnoDB Checkpoint Age DT [new]
[success] Percona InnoDB Row Lock Time DT [new]
[success] Percona InnoDB Row Lock Waits DT [new]
[success] Percona InnoDB Semaphore Waits DT [new]
[success] Percona InnoDB Semaphore Wait Time DT [new]
[success] Percona MySQL Processlist DT [new]
[success] Percona MySQL Transaction Handler DT [new]
[success] Percona MySQL Handlers DT [new]
[success] Percona MySQL Query Time Histogram (Count) DT [new]
[success] Percona MySQL Query Response Time (Microseconds) DT [new]
[success] Percona InnoDB Buffer Pool Efficiency DT [new]
Graph Template
[success] Percona MyISAM Indexes GT [new]
[success] Percona MyISAM Key Cache GT [new]
[success] Percona InnoDB Buffer Pool GT [new]
[success] Percona InnoDB I/O GT [new]
[success] Percona InnoDB Insert Buffer GT [new]
[success] Percona InnoDB Insert Buffer Usage GT [new]
[success] Percona InnoDB Semaphores GT [new]
[success] Percona InnoDB Row Operations GT [new]
[success] Percona MySQL Table Locks GT [new]
[success] Percona MySQL Connections GT [new]
[success] Percona MySQL Replication GT [new]
[success] Percona MySQL Query Cache GT [new]
[success] Percona MySQL Query Cache Memory GT [new]
[success] Percona MySQL Command Counters GT [new]
[success] Percona MySQL Select Types GT [new]
[success] Percona MySQL Sorts GT [new]
[success] Percona MySQL Temporary Objects GT [new]
[success] Percona MySQL Network Traffic GT [new]
[success] Percona InnoDB Buffer Pool Activity GT [new]
[success] Percona InnoDB I/O Pending GT [new]
[success] Percona InnoDB Log GT [new]
[success] Percona MySQL Binary/Relay Logs GT [new]
[success] Percona InnoDB Transactions GT [new]
[success] Percona InnoDB Transactions Active/Locked GT [new]
[success] Percona MySQL Files and Tables GT [new]
[success] Percona MySQL Threads GT [new]
[success] Percona InnoDB Memory Allocation GT [new]
[success] Percona InnoDB Adaptive Hash Index GT [new]
[success] Percona InnoDB Internal Hash Memory Usage GT [new]
[success] Percona InnoDB Tables In Use GT [new]
[success] Percona InnoDB Current Lock Waits GT [new]
[success] Percona InnoDB Lock Structures GT [new]
[success] Percona InnoDB Checkpoint Age GT [new]
[success] Percona InnoDB Row Lock Time GT [new]
[success] Percona InnoDB Row Lock Waits GT [new]
[success] Percona InnoDB Semaphore Waits GT [new]
[success] Percona InnoDB Semaphore Wait Time GT [new]
[success] Percona MySQL Processlist GT [new]
[success] Percona MySQL Transaction Handler GT [new]
[success] Percona MySQL Handlers GT [new]
[success] Percona MySQL Query Time Histogram (Count) GT [new]
[success] Percona MySQL Query Response Time (Microseconds) GT [new]
[success] Percona InnoDB Buffer Pool Efficiency GT [new]
Host Template
[success] Percona MySQL Server HT [new]
打开Devices――>选择主机(没有则创建)――>下拉到底部
选择相应的图象模板添加到主机:
当前测试添加了3个:
Percona InnoDB Log GT
Percona MySQL Connections GT
Percona MySQL Threads GT
上拉到页面顶部,点击“为主机创建图象(Create Graphs for this Host)”,选择刚才的3个图象模板,创建。
创建目录树并添加图象到树中:
点击 “图象树(Graph Trees)”――>选择 “默许树(Default Tree)”――>添加子树(Mysql_local)
点击树Mysql_local旁边的“添加(Add)”,子树类型为“图象(Graph)”,将mysql的3个监控图象放在该目录结构中显示:
几分钟后查看。图象出现!
跨服务器监控centos中的mysql :
cacti监控服务器:192.168.1.151
被监控的客户端:192.168.1.152
相互ping1下,确认网络畅通。
在客户端152中安装snmp:
yum -y install net-snmp net-snmp-utils
#更改配置文件以下信息:第41行,第62行,第85行
vi /etc/snmp/snmpd.conf
#com2sec notConfigUser default public
com2sec notConfigUser 192.168.1.151 public
#
access notConfigGroup "" any noauth exact systemview none none
access notConfigGroup "" any noauth exact all none none
#将 #view all included .1 80 前面的 # 注释去掉
view all included .1 80
最后启动或重启客户端snmp服务:
service snmpd restart
在客户端152的mysql添加cacti用户允许151访问:
grant process,super on *.* to 'cacti'@'192.168.1.151' identified by 'cacti';
flush privileges;
在服务端151履行,测试152的snmp是不是启用成功:
snmpwalk -c public -v 2c 192.168.1.152
主要防火墙问题,把客户端snmp服务也添加到自启动中:ntsysv
点击:装备(Devices)――>add(右上角)
其他添加的步骤和方法,和本机使用的1样。
没有图象是,注意cacti目录下是不是有权限:
ll /var/www/html/cacti/rra
很快图象数据距出现了:
生活不易,码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠