MaxScale Query Routing Monitor - Grafana dashboard for log-tailer metrics (slave reads, master writes, transaction routing)

maxscale-routing-dashboard.json

{
  "annotations": {
    "list": []
  },
  "description": "MaxScale Prometheus Metrics Dashboard",
  "editable": true,
  "gnetId": null,
  "graphTooltip": 0,
  "id": null,
  "links": [],
  "panels": [
    {
      "type": "graph",
      "title": "Queries Routed by Category",
      "gridPos": {
        "x": 0,
        "y": 0,
        "w": 12,
        "h": 8
      },
      "targets": [
        {
          "expr": "maxscale_queries_routed_total{category=\"transaction_write\"}",
          "legendFormat": "Transaction Write",
          "refId": "A"
        },
        {
          "expr": "maxscale_queries_routed_total{category=\"transaction_read\"}",
          "legendFormat": "Transaction Read",
          "refId": "B"
        },
        {
          "expr": "maxscale_queries_routed_total{category=\"slave_read\"}",
          "legendFormat": "Slave Read",
          "refId": "C"
        },
        {
          "expr": "maxscale_queries_routed_total{category=\"master_read\"}",
          "legendFormat": "Master Read",
          "refId": "D"
        }
      ],
      "lines": true,
      "linewidth": 2,
      "fill": 1,
      "yaxes": [
        {
          "format": "short",
          "label": "Queries",
          "logBase": 1,
          "min": 0
        },
        {
          "format": "short",
          "show": true
        }
      ]
    },
    {
      "type": "stat",
      "title": "CCR Forced Master Reads",
      "gridPos": {
        "x": 12,
        "y": 0,
        "w": 6,
        "h": 4
      },
      "targets": [
        {
          "expr": "maxscale_ccr_forced_master_reads_total",
          "refId": "A"
        }
      ],
      "colorMode": "value",
      "graphMode": "none",
      "unit": "short"
    },
    {
      "type": "stat",
      "title": "Transactions Started",
      "gridPos": {
        "x": 12,
        "y": 4,
        "w": 6,
        "h": 4
      },
      "targets": [
        {
          "expr": "maxscale_transactions_started_total",
          "refId": "A"
        }
      ],
      "colorMode": "value",
      "graphMode": "none",
      "unit": "short"
    }
  ],
  "schemaVersion": 36,
  "style": "dark",
  "tags": [
    "maxscale",
    "prometheus"
  ],
  "templating": {
    "list": []
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {
    "refresh_intervals": [
      "5s",
      "10s",
      "30s",
      "1m",
      "5m",
      "15m",
      "1h",
      "6h",
      "12h",
      "24h"
    ],
    "time_options": [
      "5m",
      "15m",
      "1h",
      "6h",
      "12h",
      "24h",
      "2d",
      "7d",
      "30d"
    ]
  },
  "timezone": "",
  "title": "MaxScale Prometheus Dashboard",
  "version": 1
}