Shulou(Shulou.com)06/01 Report--

Official website: http://www.fromdual.com fpmmm (FromDual Performance Monitor for MySQL and MariaDB) [root@wallet01 ~] # tar zxvf fpmmm-1.0.1.tar.gz-C / usr/local [root@wallet01 ~] # cd / usr/local/fpmmm-1.0.1/tpl/ [root@wallet01 tpl] # cp fpmmm.conf.template / etc/fpmmm.conf [root@wallet01 ~] # vi / etc/fpmmm.conf # Information for MySQL connections:Username = fpmmmPassword = fpmmmMysqlHost = localhostMysqlPort = 330mm ZabbixServer IP addressZabbixServer = 192.168.1.200 [wxhdb] # This MUST match Hostname in ZabbixroomType = mysqldMysqlPort = 3306Modules = mysql innodbPidFile = / var/run/mysqld/mysqld.pid [root@wallet01 ~] # mysql-uroot-pabcd.1234mysql > grant process on *. * to 'fpmmm'@'localhost' identified by' fpmmm' Mysql > grant replication client on *. * to 'fpmmm'@'localhost'; mysql > grant replication slave on *. * to' fpmmm'@'localhost'; mysql > grant select on mysql.user to 'fpmmm'@'localhost'; mysql > flush privileges [root@wallet01 ~] # yum install php-cli php-process php-mysqli php-posix [root@wallet01 ~] # cat / etc/php.d/fpmmm.inivariables_order = "EGPCS" date.timezone = 'Asia/Shanghai'_EOF [root@wallet01 ~] # useradd zabbix [root@wallet01 ~] # tar zxvf zabbix-3.0.20.tar.gz [root@wallet01 ~] # cd zabbix-3.0.20/ [root@wallet01 zabbix-3.0.20] # / configure-- Enable-agent [root@wallet01 zabbix-3.0.20] # make install [root@wallet01 ~] # ln-s / usr/local/bin/zabbix_sender / usr/bin/zabbix_ sender [root @ wallet01 ~] # / usr/local/fpmmm-1.0.1/bin/fpmmm-- config=/etc/fpmmm.conf1 [root@wallet01 ~] # cat / var/log/fpmmm/fpmmm.log [root@wallet01 ~] # crontab-e * / usr/ Local/fpmmm-1.0.1/bin/fpmmm-- config=/etc/fpmmm.conf [root@wallet01 ~] # crontab-l * / usr/local/fpmmm-1.0.1/bin/fpmmm-- config=/etc/fpmmm.conf deployment zabbix https://blog.51cto.com/13598811/2097609 one Import template 2, create the host and associate the template

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.