Promtheus + MySQL Exporter 연동

MySQL Exporter 설치 및 연동

MySQL Exporter 다운로드

# 버전
MySQL >= 5.6.
MariaDB >= 10.2

# 유저 없으면 추가, 있으면 접속
useradd -m -s /bin/bash prometheus
su - prometheus

# 다운로드
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz
tar zxvf mysql-5.6.51-linux-glibc2.12-x86_64.tar.gz
mv mysqld_exporter-0.13.0.linux-amd64/ mysql_exporter

exit

MySQL 에 권한 추가

# MySQL 권한 추가 (8버전?) 
CREATE USER 'exporter'@'localhost' IDENTIFIED BY 'exporter_password' WITH MAX_USER_CONNECTIONS 2;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost';
FLUSH PRIVILEGES;
EXIT;

# MySQL 권한 추가 (5.6 도...)
CREATE USER 'exporter'@'localhost' IDENTIFIED BY 'exporter_password';
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost' WITH MAX_USER_CONNECTIONS 2;
FLUSH PRIVILEGES;
EXIT;

MySQL my.cnf 설정값 추가

# exporter가 비번 안알려주면 집에 어케 들어감
sudo su

vi /etc/my.cnf

[client]
user=exporter
password=exporter_password

Exporter 서비스 등록

• my.cnf 경로 , 서비스 경로 확인 하도록 하자

# collect 와 config 는 아래서 확인!
# https://github.com/prometheus/mysqld_exporter

# 아래 MySQL my.cnf 경로 확인하도록 하자
vi /etc/systemd/system/mysql_exporter.service

[Unit]
Description=Prometheus MySQL Exporter
After=network.target
User=prometheus
Group=prometheus

[Service]
Type=simple
Restart=always
ExecStart=/home/prometheus/mysql_exporter/mysqld_exporter \
--config.my-cnf /etc/my.cnf \
--collect.global_status \
--collect.info_schema.innodb_metrics \
--collect.auto_increment.columns \
--collect.info_schema.processlist \
--collect.binlog_size \
--collect.info_schema.tablestats \
--collect.global_variables \
--collect.info_schema.query_response_time \
--collect.info_schema.userstats \
--collect.info_schema.tables \
--collect.perf_schema.tablelocks \
--collect.perf_schema.file_events \
--collect.perf_schema.eventswaits \
--collect.perf_schema.indexiowaits \
--collect.perf_schema.tableiowaits \
--collect.slave_status \
--web.listen-address=0.0.0.0:9104

[Install]
WantedBy=multi-user.target

서비스행

systemctl daemon-reload
systemctl start mysql_exporter
systemctl enable mysql_exporter
systemctl status mysql_exporter