Grafana PrometheusでMySQL監視

f:id:mutaonet:20210727195248p:plain

アーカイブをwget

## https://github.com/prometheus/mysqld_exporter/releases/tag/v0.13.0
$ wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-arm64.tar.gz

$ tar xvzf mysqld_exporter-0.13.0.linux-arm64.tar.gz
$ cd mysqld_exporter-0.13.0.linux-arm64
$ cp mysqld_exporter /usr/local/bin/

mysqld_exporter用のユーザ作成

## see https://github.com/prometheus/mysqld_exporter/#required-grants
$ mysql -h localhost -u {username} -p
CREATE USER 'exporter'@'localhost' IDENTIFIED BY '{password}!';

Service化

$ vi /etc/systemd/system/mysqld-exporter.service 
[Unit]
Description=mysqld_exporter

[Service]
Restart=always
User=exporter ##お好みで
Environment="DATA_SOURCE_NAME=exporter:{password}!@(localhost:3306)/"
ExecStart=/usr/local/bin/mysqld_exporter

[Install]
WantedBy=multi-user.target

## 起動
$ systemctl daemon-reload
$ systemctl start mysqld-exporter.service

prometheus.yml修正

$ vi /etc/prometheus/prometheus.yml
## 以下を追記する。
- job_name: 'mysqld_exporter'
    static_configs:
      - targets: ['localhost:9104']
## Prometheus再起動
$ systemctl restart prometheus