Prometheus+Grafana监控MySQL

最新推荐文章于 2026-05-19 09:37:42 发布

原创最新推荐文章于 2026-05-19 09:37:42 发布 · 775 阅读

2 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#Prometheus

监控专栏收录该内容

5 篇文章

订阅专栏

本文详细介绍了Prometheus监控系统的安装配置过程，包括Go语言、Prometheus Server及exporters的安装，并演示了如何配置Prometheus.yml来监控多个节点和数据库。此外，还介绍了Grafana的安装和配置，以及如何通过它展示Prometheus收集的数据。

一、Prometheus Server安装

1、安装go

wget -c https://dl.google.com/go/go1.13.5.linux-amd64.tar.gz

tar zxvf go1.13.5.linux-amd64.tar.gz -C /usr/local/

cd /usr/local/sbin

ln -s /usr/local/go/bin/go go

go version

输出：go version go1.13.5 linux/amd64，表示安装成功

2、安装Prometheus

server端和client端都从此地址下载：https://prometheus.io/download/

tar zxvf prometheus-2.15.2.linux-amd64.tar.gz -C /usr/local

ln -s prometheus-2.15.2.linux-amd64 prometheus

cd prometheus

修改配置文件 prometheus.yml

添加DB连接信息

# my global config
global:
  scrape_interval:     15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.
  evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.
  # scrape_timeout is set to the global default (10s).

# Alertmanager configuration
alerting:
  alertmanagers:
  - static_configs:
    - targets:
      # - alertmanager:9093

# Load rules once and periodically evaluate them according to the global 'evaluation_interval'.
rule_files:
  # - "first_rules.yml"
  # - "second_rules.yml"

# A scrape configuration containing exactly one endpoint to scrape:
# Here it's Prometheus itself.
scrape_configs:
  # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.
  - job_name: 'prometheus'

    # metrics_path defaults to '/metrics'
    # scheme defaults to 'http'.

    static_configs:
    - targets: ['localhost:9090']

# node1
  - job_name: 'linux_node1'
    static_configs:
    - targets: ['192.168.222.76:9100']
      labels:
        alias: 'node1'

  - job_name: 'mysql_node1'
    static_configs:
    - targets: ['192.168.222.76:9104']
      labels:
        alias: 'node1'

# node2
  - job_name: 'linux_node2'
    static_configs:
    - targets: ['192.168.222.77:9100']
      labels:
        alias: 'node2'

  - job_name: 'mysql_node2'
    static_configs:
    - targets: ['192.168.222.77:9104']
      labels:
        alias: 'node2'

# node3
  - job_name: 'linux_node3'
    static_configs:
    - targets: ['192.168.222.78:9100']
      labels:
        alias: 'node3'

  - job_name: 'mysql_node3'
    static_configs:
    - targets: ['192.168.222.78:9104']
      labels:
        alias: 'node3'

./prometheus --web.enable-lifecycle & 启动

输出以下日志：

level=info ts=2020-01-10T09:22:19.149Z caller=main.go:734 msg="Loading configuration file" filename=prometheus.yml
level=info ts=2020-01-10T09:22:19.152Z caller=main.go:762 msg="Completed loading of configuration file" filename=prometheus.yml
level=info ts=2020-01-10T09:22:19.152Z caller=main.go:617 msg="Server is ready to receive web requests."

web页面：IP:9090

由于被监控机器上尚未部署Prometheus客户端，导致Target的State均为down

Tip：

1、重载Prometheus配置文件的方法（需要使用 ./prometheus --web.enable-lifecycle & 方式启动）：

curl -XPOST http://localhost:9090/-/reload，正常提示如下：

[root@test02 prometheus]# curl -XPOST http://localhost:9090/-/reload
level=info ts=2020-01-13T08:36:45.046Z caller=main.go:734 msg="Loading configuration file" filename=prometheus.yml
level=info ts=2020-01-13T08:36:45.048Z caller=main.go:762 msg="Completed loading of configuration file" filename=prometheus.yml

2、关闭Prometheus的方法：

curl -X POST http://localhost:9090/-/quit