prometheus mysql 主从_prometheus监控MySQL-server

1 创建mysql导出器的用户和密码

GRANT REPLICATION CLIENT, PROCESS ON *.* TO 'prom'@'localhost' identified by '$password';

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

2 下载导出器

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

tar xf mysqld_exporter-0.11.0.linux-amd64.tar.gz

3 运行导出器

1)创建 .my.cnf

$ cat .my.cnf

[client]

user=prom

password=abc123

2) 运行导出器

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

4 配置展示页面

1)配置grafana

cat /etc/grafana/grafana.ini

[dashboards.json]

enabled = true

path = /etc/grafana/dashboards

2)下载dashboards

git clone https://github.com/percona/grafana-dashboards.git

cp -r grafana-dashb