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/
建议继续学习:
- MySQL数据库在实际应用一些方面的介绍 (阅读:35182)
- Mysql监控指南 (阅读:19508)
- 批量添加主机到cacti+nagios的监控报警系统中 (阅读:13090)
- 我常用的主机监控shell脚本 (阅读:11302)
- 7 天打造前端性能监控系统 (阅读:9834)
- 我对技术方向的一些反思 (阅读:9683)
- 如何监控HP服务器硬件状态 (阅读:8917)
- Cacti 添加 Nginx 监控 (阅读:8717)
- 利用脚本分析日志并利用snmp自定义OID,再通过cacti画图 (阅读:8546)
- Linux下三种常用的流量监控软件对比 (阅读:8495)
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:SpawN 来源: SpawN
- 标签: cacti Mysql 监控
- 发布时间:2010-05-26 13:21:48
- [533] Go Reflect 性能
- [17] 正态分布的前世今生(一)
- [12] jQuery性能优化指南
- [12] 什么是DNS劫持和DNS污染?
- [12] Linux Used内存到底哪里去了?
- [12] rsync同步的艺术
- [11] Cuckoo Filter:设计与实现
- [11] Mac下.apk的反编译
- [10] [译]Google Chrome中的高性能网
- [10] 怎样用core文件调试你的linux程序?