1. 被采集端安装MySQL exporter

  1. 解压mysqld_exporter-0.12.1.linux-amd64.tar.gz
  2. 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
  9. [root@hz-prod mysqld_exporter]# cat /usr/lib/systemd/system/mysqld_exporter.service
  10. [Unit]
  11. Description=mysqld_exporter Exporter
  12. Wants=network-online.target
  13. After=network-online.target
  15. [Service]
  16. Environment=DATA_SOURCE_NAME=exporter:Zkong_1234@tcp/
  17. ExecStart=/opt/mysqld_exporter/mysqld_exporter
  18. StandardOutput=syslog
  19. StandardError=syslog
  20. SyslogIdentifier=mysqld_exporter
  21. [Install]
  22. WantedBy=default.target
  28.   创建采集用户
  29.   CREATE USER 'exporter'@'%' IDENTIFIED BY 'qweasd@123' ;
  30.   GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%';
  31.   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']

4.普罗米修斯 targets查看状态

image.png

image.png
/