mysqlrouter_exporter

MySQL Router Exporter

MySQL Router Exporter， 基于 rluisr 大神 mysqlrouter_exporter 的版本重写

重写的原因有两个

1. rluisr 大神的版本是每 2 秒收集一次指标放在内存中，运行时间长了后内存占用会很大，且指标内容过后多会造抓取时间过长
2. 学习下 exporter 的编写

支持的 MySQL Router 版本

理论上 8.0.17 以上版本都支持

具体参考 mysqlrouter-go supported-version

编译

基于 go 1.15 开发

使用 goreleaser 工具进行编译

## 只编译
$ goreleaser build --rm-dist
## 编译并上传附件到github
$ goreleaser release --rm-dist

运行

参数 --mysqlrouter.scrape-uri、--mysqlrouter.username、--mysqlrouter.password 可以分别使用环境变量 MYSQLROUTER_URI、MYSQLROUTER_USERNAME和MYSQLROUTER_PASSWORD 进行覆盖

$ ./mysqlrouter_exporter --help
usage: mysqlrouter_exporter [<flags>]

Flags:
  -h, --help                     Show context-sensitive help (also try --help-long and --help-man).
      --web.listen-address=":49152"
                                 Address to listen on for web interface and telemetry.
      --web.telemetry-path="/metrics"
                                 Path under which to expose metrics.
      --mysqlrouter.scrape-uri="http://localhost:8081"
                                 URI on which to scrape mysqlrouter.
      --mysqlrouter.username=""  Flag that username for the scrape URI
      --mysqlrouter.password=""  Flag that password for the scrape URI
      --mysqlrouter.pid-file=""  Path to mysqlrouter pid file.

                                   If provided, the standard process metrics get exported for the mysqlrouter
                                   process, prefixed with 'mysqlrouter_process_...'. The mysqlrouter_process exporter
                                   needs to have read access to files owned by the mysqlrouter process. Depends on
                                   the availability of /proc.
                                   https://prometheus.io/docs/instrumenting/writing_clientlibs/#process-metrics.
      --log.level=info           Only log messages with the given severity or above. One of: [debug, info, warn, error]
      --log.format=logfmt        Output format of log messages. One of: [logfmt, json]
      --version                  Show application version.

安装步骤

1. 需要开启 mysql router 的 rest api 功能

   参考 A Simple MySQL Router REST API Guide

2. 下载编译好的二进制文件到 /usr/local/bin/

   https://github.com/daixijun/mysqlrouter_exporter/releases

3. 添加用于启动进程的用户(可选)

   $ useradd --comment "mysqlrouter exporter" --no-create-home --system --shell /usr/sbin/nologin mysqlrouter_exporter
   

4. 创建 systemd 配置.

   $ cat > /etc/systemd/system/mysqlrouter_exporter.service <<EOF
   [Unit]
   Description=mysqlrouter-exporter
   Documentation=https://github.com/daixijun/mysqlrouter_exporter
   After=network-online.target
   
   [Service]
   Type=simple
   Environment="MYSQLROUTER_URI=https://mysqlrouter-test.xzy.pw"
   Environment="MYSQLROUTER_USERNAME=luis"
   Environment="MYSQLROUTER_PASSWORD=luis"
   ExecStart=/usr/local/bin/mysqlrouter_exporter
   User=mysqlrouter_exporter
   Group=mysqlrouter_exporter
   Restart=always
   Type=simple
   
   [Install]
   WantedBy=multi-user.target
   EOF
   

5. 设置开机自启动

   systemctl enable --now mysqlrouter_exporter.service
   

Prometheus configuration

scrape_configs:
  - job_name: "mysqlrouter"
    static_configs:
      - targets:
          - 127.0.0.1:49152

Grafana Dashboard

available here.

感谢

• @rluisr