新版prometheus+grafana监控mysql

原创已于 2022-11-21 16:40:56 修改 · 508 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#云计算 #prometheus #数据库

于 2022-11-18 09:47:34 首次发布

Prometheus 专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何使用Prometheus和mysql_exporter实现MySQL监控部署过程，包括安装配置mysql_exporter、MySQL用户授权、systemd服务配置及Prometheus配置更新等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

prometheus:v2.36.2
grafana:9.0.7

1、安装mysql_exporter

[root@mysqld ~]# wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz [root@mysqld ~]# tar xf mysqld_exporter-0.12.1.linux-amd64.tar.gz -C /usr/local/ [root@mysqld ~]# ln -sv /usr/local/mysqld_exporter-0.12.1.linux-amd64/ /usr/local/prometheus_mysqld

2、在MySQL中创建用户并授权

mysql> CREATE USER 'mysqld_exporter'@'%' IDENTIFIED BY 'mysqld_exporter';
mysql> GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'mysqld_exporter'@'%' identified by 'mysqld_exporter'; 
mysql> GRANT SELECT ON *.* TO 'mysqld_exporter'@'%';

3、编写mysqld_exporter的配置文件

vim /usr/local/prometheus_mysqld/.my.cnf 
[client]
user=mysqld_exporter
password=mysqld_exporter
port=3306

4、配置systemd启动mysqld_exporter

vim /lib/systemd/system/mysqld_exporter.service
[Unit]
Description=Mysqld_exporter
After=network.target
[Service]
ExecStart=/usr/local/prometheus_mysqld/mysqld_exporter --config.my-cnf=/usr/local/prometheus_mysqld/.my.cnf
[Install]
WantedBy=multi-user.target

systemctl启动

systemctl daemon-reload
systemctl start mysqld_exporter
systemctl enable mysqld_exporter

5、在Prometheus-configmap端添加监控端

    - job_name: 'mysql_db'
      static_configs:
      - targets:
        - 192.168.20.230:9104

重载prometheus

curl -XPOST http://192.168.20.20:32471/-/reload

访问prometheus的targets