mysql-exporter

【前言】

prometheus+grafana搭建监控体系，

本文介绍监控mysql。

【步骤】

修改mysql exporter配置文件

[client]
user=exporter
password=xxx
host=172.31.44.128
port=3306
database=mysql

安装mysql exporter

docker run -d \
  --name mysqld_exporter \
  -p 9104:9104 \
  -v /home/ec2-user/prometheus-mysql-exporter.cnf:/.my.cnf \
  docker_url

mysql授权

CREATE USER 'exporter'@'localhost' IDENTIFIED BY 'XXXXXXXX' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost';

修改prometheus配置文件

- job_name: 'mysql'
    static_configs:
      - targets: ['172.31.44.128:9104']
        labels:
          instance: 'mysql-server-test'

添加grafana看板

grafana添加mysql监控看板，

地址： https://grafana.com/grafana/dashboards/14057-mysql/