Prometheus+Grafana+mysqld_exporter 监控 MySQL
Prometheus Grafana DevOps 大约 2049 字创建用户
仅限本机登录
CREATE USER 'exporter'@'localhost' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost';
限制指定IP
登录
CREATE USER 'exporter'@'192.168.0.100' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'192.168.0.100';
限制指定网段登录
CREATE USER 'exporter'@'192.168.0.%' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'192.168.0.%';
任意主机都可登录
CREATE USER 'exporter'@'%' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%';
下载 mysqld_exporter
https://github.com/prometheus/mysqld_exporter/releases
新建配置文件
命名为my.cnf
。
[client]
host=192.168.0.100
port=3306
user=exporter
password=123456
后台启动
nohup /root/exporter/mysqld_exporter-0.13.0/mysqld_exporter --config.my-cnf="my.cnf" > mysqld_exporter.out 2>&1 &
设置开机启动
编辑
vim /etc/systemd/system/mysqld_exporter.service
内容:ExecStart
需要修改为mysqld_exporter
二进制文件的绝对路径
[Unit]
Description=mysqld_exporter
Documentation=https://github.com/prometheus/mysqld_exporter
After=network.target
[Service]
Type=simple
User=root
ExecStart= /root/exporter/mysqld_exporter-0.13.0/mysqld_exporter
Restart=on-failure
[Install]
WantedBy=multi-user.target
设为开机启动
sudo systemctl enable mysqld_exporter.service
启动mysqld_exporter
sudo systemctl start mysqld_exporter.service
mysqld_exporter 默认端口
修改 Prometheus 配置
scrape_configs
下新增job_name
为mysql
(名称随意)
- job_name: 'mysql'
static_configs:
- targets: ['192.168.0.100:9104']
完整的scrape_configs
如下
scrape_configs:
- job_name: "prometheus"
static_configs:
- targets: ["localhost:9090"]
- job_name: 'mysql'
static_configs:
- targets: ['192.168.0.100:9104']
重启 Prometheus
重启后可查看mysqld_exporter
是否上线。
Grafana Dashboard
MySQL Overview: https://grafana.com/grafana/dashboards/7362
开源地址
阅读 874 · 发布于 2022-02-22
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb扫描下方二维码关注公众号和小程序↓↓↓

昵称:
随便看看
换一批
-
IDEA ESLint: Delete `␍` (prettier/prettier) 解决办法阅读 881
-
IDEA Debug 时对象莫名其妙被修改了阅读 301
-
软考-系统架构设计师:数据备份阅读 1721
-
wget ERROR The certificate was signed using an insecure algorithm阅读 2090
-
Vue 父组件中修改子组件样式阅读 103
-
Java7 文件变动监听阅读 1368
-
Docker 部署 PostgreSQL阅读 833
-
Linux 命令之查看进程启动时间阅读 2047
-
Nginx 使用 Basic Auth 认证做资源访问限制阅读 2637
-
Kubernetes Service 对外提供访问阅读 759