cacti-0.8.7i使用percona-monitoring-plugins监控mysql等

jy166102

　　注意文中RemoteServerIP，cactiserverIP，remoteIP等替换为自己的IP
　　
　　1.MySQL主机添加监控账号，建议所有被监控MySQL服务的主机设置统一的账号和密码

1.1   使用root登录到mysq的命令行

1.2   GRANT SUPER, PROCESS ON *.* TO 'cactiuser'@'cactiserverIP' IDENTIFIED BY "cactipassword";
　　1.3   flush privileges;

1.4   在cacti服务器上测试账号，mysql -h RemoteServerIP -e "SELECT VERSION()" -u cactiuser -pcactipassword     

     

2.ssh远程自动登录配置

2.1   在cacti服务器上生成ssh的key

      [iyunv@cactiserver ~]# mkdir /etc/cactiuser

      [iyunv@cactiserver ~]# ssh-keygen

      Generating public/private rsa key pair.
Enter file in which to save the key (/root/.ssh/id_rsa): /etc/cactiuser/id_rsa
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /etc/cactiuser/id_rsa.
Your public key has been saved in /etc/cactiuser/id_rsa.pub.
The key fingerprint is:
7c:34:8d:33:a0:1c:a0:43:cd:89:41:5e:81:66:2e:84 root@cactiserver.localdomain
 　　
      [iyunv@cactiserver ~]# cd /etc/cactiuser/

      [iyunv@cactiserver cactiuser]# ls

      id_rsa  id_rsa.pub

      [iyunv@cactiserver cactiuser]# chown -R cactiuser id_rsa

      [iyunv@cactiserver cactiuser]# chown -R cactiuser id_rsa.pub

      [iyunv@cactiserver cactiuser]# chown -R cactiuser:cactiuser id_rsa.pub

      [iyunv@cactiserver cactiuser]# chown -R cactiuser:cactiuser id_rsa

      [iyunv@cactiserver cactiuser]# chmod -R 0400 /etc/cactiuser/id_rsa

     

2.2   在被监控的主机上增加用户cactiuser

      [iyunv@remoteServer ~]# cd /home

      [iyunv@remoteServer home]# groupadd cactiuser

      [iyunv@remoteServer home]# useradd cactiuser -g cactiuser

      [iyunv@remoteServer home]# cd /home/cactiuser/

      [iyunv@remoteServer cactiuser]# mkdir .ssh

     

2.3   用SCP把cacti服务器上cactiuser的公共key复制到被监控的主机

      [iyunv@remoteServer cactiuser]# scp id_rsa.pub root@remoteIP:/home/cactiuser/.ssh/

     

2.4   被监控主机配置
　　[iyunv@remoteServer ~]# cd /home/cactiuser/.ssh/

      [iyunv@remoteServer .ssh]# mv id_rsa.pub authorized_keys
　　[iyunv@remoteServer .ssh]# cd /home/cactiuser
　　
      [iyunv@remoteServer cactiuser]# chown -R cactiuser:cactiuser .ssh

     

2.5   在cacti服务器上测试

      ssh -i /etc/cactiuser/id_rsa cactiuser@remoteIP echo "it works"

     

3.配置文件修改


3.1   把percona-monitoring-plugins-0.9.0\cacti\scripts下ss_get_by_ssh.php和ss_get_mysql_stats.php复制到cacti的scripts文件夹下

3.2   vi ss_get_by_ssh.php

      $ssh_user   = 'cactiuser';                      # SSH username

      $ssh_port   = 22;                               # SSH port

      $ssh_iden   = '-i /etc/cactiuser/id_rsa';       # SSH identity

3.3   $mysql_user = 'cactiuser';

      $mysql_pass = 'cactipassword';

      $mysql_port = 3306;

3.4  测试 

su -cactiuser -c 'php /usr/local/apache/htdocs/cacti/scripts/ss_get_by_ssh.php --type memory --host RemoteIP --items gu,gv'
gu:611717120 gv:841474048
 　　
　　
　　

4.导入模板，新建图像
　　
　　5.图像截图
　　

　　
　　参考链接：
　　http://www.percona.com/doc/percona-monitoring-plugins/cacti/mysql-templates.html
　　http://www.percona.com/doc/percona-monitoring-plugins/cacti/ssh-based-templates.html