Centos下Zabbix+Fpmmm监控MySQL状态

**

Centos下Zabbix+Fpmmm监控MySQL状态

**
1.部署MySQL数据库，这个就简单叙述

tar  -zxf  mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
mv  mysql-5.7.29-linux-glibc2.12-x86_64  /usr/local/mysql
mkdir  -p /data/mysql/{data,logs,tmp}
useradd  -s  /sbin/nologin  mysql
chown mysql.mysql  -R  /usr/local/mysql  /data/mysql
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize  #初始化数据库
cp  /usr/local/mysql/support-files/mysql.server   /etc/init.d/mysqld  
/etc/init.d/mysqld  start

2.部署zabbix_agent和zabbix_sender

yum -y install zabbix-agent-4.4.7-1.el7.x86_64.rpm 	zabbix-sender-4.4.7-1.el7.x86_64.rpm
vim  /etc/zabbix/zabbix_agentd.conf
zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf
zabbix_sender -vv -c /etc/zabbix/zabbix_agentd.conf -i - -s mes-test-db  #可以忽略不执行

3.部署Fpmmm

wget https://support.fromdual.com/admin/download/fpmmm-0.10.6.tar.gz  #先下载二进制包
tar  -zxf  fpmmm-0.10.6.tar.gz
mv  fpmmm-0.10.6   /opt/fpmmm

1）安装php依赖，需要php的部分插件支持，不然会报错

yum -y  install  php-cli php-process php-mysqli

cat << _EOF >/etc/php.d/fpmmm.ini     ##设置修改时区
variables_order = "EGPCS"
date.timezone = 'Asia/Shanghai'
_EOF   

2）授权数据库

vim /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
sh vim /etc/profile.d/mysql.sh
mysql -e "GRANT ALL  ON *.* TO 'fpmmm'@'192.168.158.130' IDENTIFIED BY 'password';"
mysql -e "GRANT ALL  ON *.* TO 'fpmmm'@'127.0.0.1' IDENTIFIED BY 'password';"

3）修改Fpmmm配置文件并启动

/opt/fpmmm/bin/fpmmm --config=/etc/fpmmm/fpmmm.conf   #返回1代表成功
#监控是时时都需要的，所以建议创个定时任务
* * * * * /opt/fpmmm/bin/fpmmm --config=/etc/fpmmm/fpmmm.conf >/dev/null

4）后面可以登录zabbix去查看监控数据了