Configure Cacti to monitor MySQL database status

MySQL itself is not powerful in performance monitoring, which makes many MySQLDBA sleep at night, fortunately, through Cacti monitoring (note that it is monitoring rather than monitoring) MySQ

MySQL itself is not powerful in performance monitoring, which makes many MySQL DBAs sleep at night. Fortunately, it is MySQ through Cacti monitoring (note that it is monitoring rather than monitoring ).

Homepage → Database Technology

Background:

Read News

Configure Cacti to monitor MySQL database status

[Date:] Source: Linux community Author: linwaterbin [Font:]

MySQL itself is not powerful in performance monitoring, which makes many MySQL DBAs sleep at night. Fortunately, the MySQL database status is monitored through Cacti (monitoring rather than monitoring.

With the powerful drawing function of cacti + rrdtool and dedicated mysql templates, You can flexibly and quickly create and monitor multiple MySQL instances.

(I) For RPM installation, the following RPM packages are required:

Httpd

Php

Php-mysql

Php-snmp

Mysql

Mysql-server

Net-snmp *

(Ii) install RRDTool

# Wget

# Tar-zxv-f rrdtool-1.4.4.tar.gz

#./Configure -- prefix =/usr/local/rrdtool -- disable-python -- disable-tcl

# Make

# Make install

Possible faults:

Configure: error: Please fix the library issues listed above and try again

See → troubleshoting

(Iii) install CACTI

# Wget

# Useradd cacti

# Tar-zxv-f cacti-0.8.7i.tar.gz

# Music cacti-0.8.7i/var/www/cacti

# Chown-R cacti: cacti/var/www/cacti

(Iv) configure the apache module

Edit apache configuration file: vim httpd. conf

① Modify the service name:

ServerAdmin 192.168.1.113: 80

② Modify the site's start directory:

DocumentRoot "/var/www"

③ Modify the directory:

④ Add the default homepage File Name:

DirectoryIndex index.html index. php

⑤ Added support for the php type:

AddType application/x-httpd-php. php

AddType application/x-httpd-php-source. phps

Then: wq save and quit!

Run apachectl-t to check the Configuration File Syntax. Normally, Syntax OK is returned:

Start snmp service: service snmpd start

Start apache service: apachectl start

0

Oracle's simplest method of querying table space usage and remaining amount

How to synchronize two databases in Oracle (using the materialized view) (Oracle snapshot instance)

Related information CACTI Cacti configuration Cacti monitoring MySQL

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2014 Linux community All rights reserved Zhejiang ICP backup No. 06018118