Prometheus Grafana 监控MySQL

1.Prometheus的架构

在被监控服务器10.0.0.201安装exporter

安装node_exporter

wgethttps://github.com/prometheus/node_exporter/releases/download/v0.15.1/node_exporter-0.15.1.linux-amd64.tar.gz

tar zxvf node_exporter-0.15.1.linux-amd64.tar.gz

cd node_exporter-0.15.1.linux-amd64

nohup ./node_exporter &

 

安装mysqld_exporter

连接mysql授予权限mysql -uroot -p

GRANT REPLICATION CLIENT, PROCESS ON *.* TO'exporter'@'localhost' identified by'123456';

GRANT SELECT ON performance_schema.* TO 'exporter'@'localhost';

flush privileges;

 

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.11.0/mysqld_exporter-0.11.0.linux-amd64.tar.gz

tar zxvf mysqld_exporter-0.11.0.linux-amd64

cd mysqld_exporter-0.11.0.linux-amd64

建立配置文件my.cnf

[client]

user=exporter

password=123456

运行mysqld exporter

nohup ./mysqld_exporter -config.my-cnf="my.cnf" &

mysqld_exporter可以用docker安装，但是因为我用的是centos6.x，如果想安装最新版本的docker要升级内核，所以放弃了，如果想尝试的话可以参考

https://www.cnblogs.com/zhangzhen894095789/p/6641981.html?utm_source=itdadao&utm_medium=referral

https://github.com/prometheus/mysqld_exporter

 

prometheus和grafana的安装方法请看

https://blog.youkuaiyun.com/liufei198613/article/details/82460883