Cacti監控Linux、Mysql和Apache

來源參考如下：

http://www.percona.com/software/percona-monitoring-plugins/

下載監控插件和文檔

axel http://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-0.9.0.tar.gz

tar zxvf percona-monitoring-plugins-0.9.0.tar.gz

cd release/percona-monitoring-plugins-0.9.0/cacti/scripts/

cp ss_get_* /usr/share/cacti/site/scripts

在cacti的web控制檯導入templates中所有模板

監控Mysql

編輯 /usr/share/cacti/site/scripts/ss_get_mysql_stats.php

$mysql_user = 'username';

$mysql_pass = 'password';

使用有足夠權限查看mysql狀態信息的帳號，建議所有mysql服務器都添加相同的帳號，否則要逐個主機逐個圖形的添加帳號密碼，非常繁瑣

然後為被監控主機添加mysql的圖形即可

監控Linux和Apache前的準備工作

實現使用祕鑰ssh登錄

先確定cacti使用那個帳號運行，Debian上為www-data

debian:~# ssh-keygen

Generating public/private rsa key pair.

Enter file in which to save the key (/root/.ssh/id_rsa): /etc/cacti/id_rsa #這個目錄等會在腳本中需要指定

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /etc/cacti/id_rsa.

Your public key has been saved in /etc/cacti/id_rsa.pub.

以上為生成公鑰和私鑰

chown www-data:www-data /etc/cacti/id_rsa*

修改公鑰和私鑰的屬主為www-data

debian:~# ssh 192.168.1.107 adduser cacti

Adding user ‘cacti’ ...

在被監控的機器上添加一個用於查詢數據的用戶，這裡為cacti

debian:~# ssh-copy-id -i /etc/cacti/id_rsa.pub [email protected]

[email protected]’s password:

Now try logging into the machine, with "ssh ’[email protected]’", and check in:

.ssh/authorized_keys

to make sure we haven’t added extra keys that you weren’t expecting.

將公鑰上傳到被監控主機，主意指定公鑰名稱和登錄的用戶，在被監控主機上，cacti的主目錄下.ssh/authorized_keys存放了公鑰

debian:~# ssh -i /etc/cacti/id_rsa [email protected] echo "it works"

it works

測試使用私鑰登錄被監控主機，用戶名為cacti，如果有回顯，則測試成功

修改文件/usr/share/cacti/site/scripts/ss_get_by_ssh.php

$ssh_user = 'cacti'; # SSH 用戶名

$ssh_port = 22; # SSH 端口

$ssh_iden = '-i /etc/cacti/id_rsa'; # SSH 私鑰存放位置

監控Apache

首先確定Apache啟用了mod_status.so

同時需要修改配置文件，否則只能本地查看狀態信息

<Location /server-status>

SetHandler server-status

Order deny,allow

Deny from all

Allow from 127.0.0.1 ::1

# Allow from 192.0.2.0/24

</Location>

添加Apache相應的圖形模板即可

監控Linux

添加相應的Linux圖形模板即可

這裡mysql使用ss_get_mysql_stats.php腳本監控

其他使用ss_get_by_ssh.php腳本監控