ZBLOG

prometheus+greenplum_exporter+alertmanager+grafana配置

  1. Prometheus配置:

在 prometheus.yml 文件中添加以下内容:

scrape_configs:
  - job_name: 'greenplum_exporter'
    scrape_interval: 15s
    static_configs:
      - targets: ['<IP address of Greenplum exporter>:9187']
  1. Greenplum Exporter 配置:

在 greenplum_exporter.yml 文件中添加以下内容:

global:
  db_address: <Greenplum master node IP address>
  db_port: <Greenplum master node port>
  db_user: <Greenplum username>
  db_password: <Greenplum password>

metrics:
  query_duration_seconds:
    help: "Duration of the last query executed in seconds."
    sql: "SELECT query_duration_seconds FROM pg_stat_activity WHERE state = 'active' ORDER BY query_start DESC LIMIT 1;"
  queries_running:
    help: "Number of active queries."
    sql: "SELECT COUNT(*) FROM pg_stat_activity WHERE state = 'active';"
  connections:
    help: "Number of database connections."
    sql: "SELECT numbackends FROM pg_stat_database WHERE datname = current_database();"
  1. Alertmanager 配置:

在 alertmanager.yml 文件中添加以下内容:

global:
  slack_api_url: '<Slack webhook URL>'

route:
  group_by: ['alertname', 'severity']
  receiver: 'slack-notifications'
  routes:
    - match:
        severity: critical
      receiver: 'slack-notifications'
    - match:
        severity: warning
      receiver: 'slack-notifications'

receivers:
- name: 'slack-notifications'
  slack_configs:
  - channel: '#<Channel name>'
    send_resolved: true
  1. Grafana 配置:

使用 Grafana UI 创建 dashboard,选择 Prometheus 数据源,并添加以下 query:

greenplum_exporter_queries_running
greenplum_exporter_query_duration_seconds

这将显示当前运行的查询数和最近执行查询的持续时间。

然后可以根据需要添加其他查询和面板。

本站部分文章来源于网络,版权归原作者所有,如有侵权请联系站长删除。
转载请注明出处:https://golang.0voice.com/?id=2531

分享:
扫描分享到社交APP
上一篇
下一篇
发表列表
游客 游客
此处应有掌声~
评论列表

还没有评论,快来说点什么吧~

联系我们

在线咨询: 点击这里给我发消息

微信号:3007537140

上班时间: 10:30-22:30

关注我们
x

注册

已经有帐号?