Prometheus+mysqld_exporter

mysqld_exporter

mysqld_exporter是Prometheus对MySQL的监控插件

下载地址

这里要选择自己合适的版本

下载并解压

复制
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz
tar -zxvf mysqld_exporter-0.12.1.linux-amd64.tar.gz

ARM版本

复制
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-arm64.tar.gz
tar -zxvf mysqld_exporter-0.12.1.linux-arm64.tar.gz

创建mysqld_exporter配置文件

复制
cd mysqld_exporter-0.12.1.linux-arm64/
vim .my.cnf

复制
[client]
host=localhost
port=3306
user=mysqld_exporter
password=Fwigff+A0T0

创建Prometheus中的mysqld_exporter配置文件

复制
vim mysql.yml

复制
- labels:
    service: mysql
  targets:
  - localhost

创建mysqld_exporter数据库用户并配置数据库权限

复制
create user 'mysqld_exporter'@'%' identified by 'Fwigff+A0T0' with MAX_USER_CONNECTIONS 3 ;

grant process,replication client,select on *.* to 'mysqld_exporter'@'%';


FLUSH PRIVILEGES;

配置启动文件

复制
vim /etc/systemd/system/mysqld_exporter.service

复制
[Unit]
Description=Prometheus Monitoring System
Documentation=Prometheus Monitoring System

[Service]
ExecStart=/opt/monitor/service/mysqld_exporter-0.12.1.linux-arm64/mysqld_exporter \
     --config.my-cnf=/opt/monitor/service/mysqld_exporter-0.12.1.linux-arm64/.my.cnf

[Install]
WantedBy=multi-user.target

刷新文件

复制
systemctl daemon-reload

启动命令

复制
systemctl start mysqld_exporter    #启动
systemctl stop mysqld_exporter     #停止
systemctl restart mysqld_exporter  #重启
systemctl status mysqld_exporter   #查看状态

配置Prometheus配置文件

复制
vim prometheus.yml

复制
- file_sd_configs:
      - files:
          - mysql.yml
    job_name: MySQL
    scrape_interval:     5s
    metrics_path: /metrics
    relabel_configs:
      - source_labels: [__address__]
        regex: (.*)
        target_label: instance
        replacement: $1
      - source_labels: [__address__]
        regex: (.*)
        target_label: __address__
        replacement: $1:9104