Halo, kalau kamu merasa tulisan saya ngebantu kamu, kamu bisa ucapkan terima kasih lewat saweria .
If you feel this website help you, you can donate at saweria .
Tools yang Saya Gunakan
How To
- Buat user baru khusus mysqld_exporter
CREATE USER 'exporter'@'localhost' IDENTIFIED BY 'XXXXXXXX' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost';
FLUSH PRIVILEGES;
- Setup mysqld_exporter , buat file docker-compose.yml
version: '3'
services:
mysqld-exporter:
image: prom/mysqld-exporter:latest
container_name: mysqld-exporter
restart: always
#if setup firewall was pain just use
#network_mode: host
ports:
- "9104:9104"
environment:
DATA_SOURCE_NAME: "exporter:XXXXXXX@(localhost:3306)/"
Jalankan docker-compose up -d. Untuk mengecek apakah exporter sudah berhasil dijalankan, gunakan docker logs -f mysqld-exporter
mysqld_exporter Running Succesfully
- Selanjutnya, tambahkan job baru di file prometheus.yml
- job_name: 'mysqlexporter'
static_configs:
- targets:
#mysql server location
- 192.168.1.2:3306
- 192.168.1.3:3306
scrape_interval: 5s
relabel_configs:
- source_labels: [__address__]
target_label: __param_target
- source_labels: [__param_target]
target_label: instance
- target_label: __address__
# server who run mysqld_exporter host:port
replacement: 192.168.1.4:9104
Restart container prometheus docker restart prometheus
Exporter Scraped by Prometheus
- Tambahkan rules baru di prometheus
wget https://raw.githubusercontent.com/samber/awesome-prometheus-alerts/master/dist/rules/mysql/mysqld-exporter.yml -O mysqld-exporter.rules
- Masuk ke grafana dashboard, import dashboard 14057
Grafana Dashboard 14057 mysqld_exporter
Referensi:
Awesome Prometheus alerts - mysql