Prometheus 监控MySQL

地铁昌平线

于 2023-12-04 09:21:40 发布

阅读量348

点赞数 10

分类专栏：监控文章标签： prometheus mysql 数据库

本文链接：https://blog.csdn.net/qq_38619478/article/details/134775636

版权

监控专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1. 被采集端安装MySQL exporter

解压mysqld_exporter-0.12.1.linux-amd64.tar.gz
cd /opt/ && tar xf  mysqld_exporter-0.12.1.linux-amd64.tar.gz && ln -s mysqld_exporter-0.12.1.linux-amd64.tar.gz mysql_exporter






[root@hz-prod mysqld_exporter]# cat /usr/lib/systemd/system/mysqld_exporter.service
[Unit]
Description=mysqld_exporter Exporter
Wants=network-online.target
After=network-online.target

[Service]
Environment=DATA_SOURCE_NAME=exporter:Zkong_1234@tcp/
ExecStart=/opt/mysqld_exporter/mysqld_exporter
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=mysqld_exporter
[Install]
WantedBy=default.target

  
  
  
  
  创建采集用户
  CREATE USER 'exporter'@'%' IDENTIFIED BY 'qweasd@123' ;
  GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%';
  FLUSH PRIVILEGES;

2.启动MySQL exporter

systemctl daemon-reload
systemctl restart mysqld_exporter

3.普罗米修斯添加mysql_exporter 至采集池



vim prometheus.yml
  - job_name: MySQL_exporter
    static_configs:
    - targets: ['192.168.0.56:9104']
    - targets: ['192.168.0.107:9104']
    - targets: ['114.55.165.123:9104']