Grafana+prometheus+MySQL监控搭建

原创

已于 2024-05-10 22:43:25 修改

· 1.3k 阅读

25 ·

版权

文章标签：

#grafana #prometheus #mysql

于 2024-01-12 12:37:02 首次发布

本文详细介绍了如何下载、安装和配置Prometheus及node_exporter，添加监控目标，以及与Grafana集成，展示MySQL监控信息的全过程，包括安装Grafana、设置数据源和导入模板。

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

prometheus搭建

1、下载prometheus安装包

链接：https://pan.baidu.com/s/1iAwmmcuPivqhTPjSY2gEaw
提取码：g7oa

注：文章中的按照包都在该百度网盘链接中

[root@k8s01 ~]# cd /usr/local/
[root@k8s01 local]# tar -xvzf prometheus-2.16.0.linux-amd64.tar.gz
[root@k8s01 local]# mkdir -p /usr/local/prometheus
[root@k8s01 local]# mv prometheus-2.16.0.linux-amd64  prometheus
[root@k8s01 prometheus]# cd /usr/local/prometheus
[root@k8s01 prometheus]# ./prometheus --version
prometheus, version 2.16.0 (branch: HEAD, revision: b90be6f32a33c03163d700e1452b54454ddce0ec)
  build user:       root@7ea0ae865f12
  build date:       20200213-23:50:02
  go version:       go1.13.8

2、配置Prometheus

[root@k8s01 prometheus]# grep -vE "^$|^[\t| ]*#" prometheus.yml
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.
alerting:
  alertmanagers:
- static_configs:
    - targets:
rule_files:
scrape_configs:
- job_name: 'prometheus'
    static_configs:
    - targets: ['localhost:9090']

3、启动服务

cat > /usr/lib/systemd/system/prometheus.service <<EOF
[Unit]
Description=prometheus
After=network.target
[Service]
ExecStart=/usr/local/prometheus/prometheus \
          --config.file=/usr/local/prometheus/prometheus.yml \
          --storage.tsdb.path=/var/lib/prometheus
ExecReload=/bin/kill -s HUP $MAINPID
Restart=on-failure
[Install]
WantedBy=multi-user.target
EOF




然后就可以通过systemctl命令设置开机启动，并启动服务了。
systemctl enable prometheus && systemctl start prometheus

一切正常的情况下，就能在/var/log/messages中看到如下打印，

Mar 10 10:08:55 k8s01 systemd: Started prometheus.

Mar 10 10:08:55 k8s01 systemd: Starting prometheus...

...

Mar 10 10:08:55 centos7 prometheus: level=info ts=2024-01-10T14:08:55.895Z caller=main.go:630