【MySQL】數(shù)據(jù)庫(kù)監(jiān)控--fpmmm（zabbix）

官網(wǎng)：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??????=?fpmmm
Password??????=?fpmmm
MysqlHost?????=?localhost
MysqlPort?????=?3306

#?Zabbix?Server?IP?address
ZabbixServer??=?192.168.1.200

[wxhdb]??????????#?This?MUST?match?Hostname?in?Zabbix!
Type??????????=?mysqld
MysqlPort?????=?3306
Modules???????=?mysql?innodb
PidFile???????=?/var/run/mysqld/mysqld.pid

[root@wallet01?~]#?mysql?-uroot?-pabcd.1234
mysql>?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?<<?_EOF?>/etc/php.d/fpmmm.ini
variables_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.conf
1
[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

部署zabbix
https://blog.51cto.com/13598811/2097609
一，導(dǎo)入模板
二，創(chuàng)建主機(jī)并關(guān)聯(lián)模板