aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKumar Damani <me@kumardamani.net>2022-05-10 16:27:34 +0000
committerKumar Damani <me@kumardamani.net>2022-05-10 16:27:34 +0000
commit5981ce5bbd0b3c0d55328a7e968a3b944aa0591e (patch)
tree4bbe2e75ca2f919c2bd4c2d8beb3e88aa3697366
parent74c7d6c3e0e87ebbc4957f0d647e459f3ae1bfd6 (diff)
updated mysql dashboard with host data usage panelHEADmain
-rw-r--r--mysql-cluster-overview.json1295
1 files changed, 681 insertions, 614 deletions
diff --git a/mysql-cluster-overview.json b/mysql-cluster-overview.json
index c92d897..993437e 100644
--- a/mysql-cluster-overview.json
+++ b/mysql-cluster-overview.json
@@ -35,7 +35,7 @@
"type": "grafana",
"id": "grafana",
"name": "Grafana",
- "version": "8.3.3"
+ "version": "8.4.6"
},
{
"type": "panel",
@@ -100,7 +100,7 @@
"gnetId": 15641,
"graphTooltip": 1,
"id": null,
- "iteration": 1643325165890,
+ "iteration": 1652199672111,
"links": [],
"liveNow": false,
"panels": [
@@ -314,7 +314,7 @@
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"targets": [
{
"datasource": {
@@ -579,7 +579,8 @@
"placement": "bottom"
},
"tooltip": {
- "mode": "single"
+ "mode": "single",
+ "sort": "none"
}
},
"pluginVersion": "8.0.1",
@@ -662,7 +663,7 @@
"showThresholdMarkers": true,
"text": {}
},
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"targets": [
{
"datasource": {
@@ -749,7 +750,7 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"targets": [
{
"calculatedInterval": "10m",
@@ -835,7 +836,7 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"targets": [
{
"calculatedInterval": "10m",
@@ -920,7 +921,7 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"targets": [
{
"calculatedInterval": "10m",
@@ -1026,7 +1027,7 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"targets": [
{
"calculatedInterval": "10m",
@@ -1110,7 +1111,7 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"targets": [
{
"datasource": {
@@ -4823,7 +4824,7 @@
"alertThreshold": true
},
"percentage": false,
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"pointradius": 5,
"points": false,
"renderer": "flot",
@@ -4944,7 +4945,7 @@
"alertThreshold": true
},
"percentage": false,
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"pointradius": 5,
"points": false,
"renderer": "flot",
@@ -5100,7 +5101,7 @@
"alertThreshold": true
},
"percentage": false,
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"pointradius": 5,
"points": false,
"renderer": "flot",
@@ -5221,7 +5222,7 @@
"alertThreshold": true
},
"percentage": false,
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"pointradius": 1,
"points": true,
"renderer": "flot",
@@ -5357,7 +5358,7 @@
"alertThreshold": true
},
"percentage": false,
- "pluginVersion": "8.3.3",
+ "pluginVersion": "8.4.6",
"pointradius": 5,
"points": false,
"renderer": "flot",
@@ -5444,54 +5445,15 @@
}
},
{
- "collapsed": false,
- "gridPos": {
- "h": 1,
- "w": 24,
- "x": 0,
- "y": 39
- },
- "id": 407,
- "panels": [],
- "title": "Cluster Replication Health",
- "type": "row"
- },
- {
- "description": "",
+ "description": "The usage % for the /data mount point on the worker node. k8s will start eviction once the /data reaches 85% usage.",
"fieldConfig": {
"defaults": {
"color": {
- "mode": "palette-classic"
- },
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
- },
- "thresholdsStyle": {
- "mode": "off"
- }
+ "mode": "thresholds"
},
"mappings": [],
+ "max": 1,
+ "min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
@@ -5501,30 +5463,35 @@
},
{
"color": "red",
- "value": 80
+ "value": 0.85
}
]
- }
+ },
+ "unit": "percentunit"
},
"overrides": []
},
"gridPos": {
- "h": 6,
- "w": 7,
- "x": 0,
- "y": 40
+ "h": 7,
+ "w": 8,
+ "x": 16,
+ "y": 32
},
- "id": 401,
+ "id": 423,
"options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "orientation": "auto",
+ "reduceOptions": {
+ "calcs": [
+ "lastNotNull"
+ ],
+ "fields": "",
+ "values": false
},
- "tooltip": {
- "mode": "single"
- }
+ "showThresholdLabels": false,
+ "showThresholdMarkers": true,
+ "text": {}
},
+ "pluginVersion": "8.4.6",
"targets": [
{
"datasource": {
@@ -5532,614 +5499,714 @@
"uid": "${DS_PROMETHEUS}"
},
"exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_local_send_queue_avg{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "expr": " sum by (instance) (\n (\n node_filesystem_size_bytes{job=\"node-exporter\", instance=~\"$hosts\", mountpoint=\"/data\"} \n - \n node_filesystem_avail_bytes{job=\"node-exporter\", instance=~\"$hosts\", mountpoint=\"/data\"}\n ) \n / \n node_filesystem_size_bytes{job=\"node-exporter\", instance=~\"$hosts\", mountpoint=\"/data\"}\n )\n",
+ "instant": false,
"interval": "",
- "legendFormat": "{{ pod }}",
+ "legendFormat": "{{instance}}",
"refId": "A"
}
],
- "title": "WSREP Avg. Send Queue",
- "type": "timeseries"
+ "title": "/data Usage Pct.",
+ "type": "gauge"
},
{
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "palette-classic"
- },
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
+ "collapsed": true,
+ "gridPos": {
+ "h": 1,
+ "w": 24,
+ "x": 0,
+ "y": 39
+ },
+ "id": 407,
+ "panels": [
+ {
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
},
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 0,
+ "y": 40
+ },
+ "id": 401,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
},
- "thresholdsStyle": {
- "mode": "off"
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
}
},
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
},
- {
- "color": "red",
- "value": 80
- }
- ]
- }
- },
- "overrides": []
- },
- "gridPos": {
- "h": 6,
- "w": 7,
- "x": 7,
- "y": 40
- },
- "id": 403,
- "options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_local_send_queue_avg{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Avg. Send Queue",
+ "type": "timeseries"
},
- "tooltip": {
- "mode": "single"
- }
- },
- "targets": [
{
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
},
- "exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_local_send_queue_min{job=\"${rel}-${jobsuffix}\"}) by (pod)",
- "interval": "",
- "legendFormat": "{{ pod }}",
- "refId": "A"
- }
- ],
- "title": "WSREP Min. Send Queue",
- "type": "timeseries"
- },
- {
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "palette-classic"
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 7,
+ "y": 40
},
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
+ "id": 403,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
},
- "thresholdsStyle": {
- "mode": "off"
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
}
},
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
},
- {
- "color": "red",
- "value": 80
- }
- ]
- }
- },
- "overrides": []
- },
- "gridPos": {
- "h": 6,
- "w": 7,
- "x": 14,
- "y": 40
- },
- "id": 405,
- "options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_local_send_queue_min{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Min. Send Queue",
+ "type": "timeseries"
},
- "tooltip": {
- "mode": "single"
- }
- },
- "targets": [
{
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
},
- "exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_local_send_queue_max{job=\"${rel}-${jobsuffix}\"}) by (pod)",
- "interval": "",
- "legendFormat": "{{ pod }}",
- "refId": "A"
- }
- ],
- "title": "WSREP Max. Send Queue",
- "type": "timeseries"
- },
- {
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "palette-classic"
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 14,
+ "y": 40
},
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
+ "id": 405,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
},
- "thresholdsStyle": {
- "mode": "off"
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
}
},
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
},
- {
- "color": "red",
- "value": 80
- }
- ]
- }
- },
- "overrides": []
- },
- "gridPos": {
- "h": 6,
- "w": 7,
- "x": 0,
- "y": 46
- },
- "id": 409,
- "options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_local_send_queue_max{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Max. Send Queue",
+ "type": "timeseries"
},
- "tooltip": {
- "mode": "single"
- }
- },
- "targets": [
{
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
},
- "exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_local_recv_queue_avg{job=\"${rel}-${jobsuffix}\"}) by (pod)",
- "interval": "",
- "legendFormat": "{{ pod }}",
- "refId": "A"
- }
- ],
- "title": "WSREP Avg. Recv Queue",
- "type": "timeseries"
- },
- {
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "palette-classic"
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 0,
+ "y": 46
},
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
+ "id": 409,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
},
- "thresholdsStyle": {
- "mode": "off"
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
}
},
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
},
- {
- "color": "red",
- "value": 80
- }
- ]
- }
- },
- "overrides": []
- },
- "gridPos": {
- "h": 6,
- "w": 7,
- "x": 7,
- "y": 46
- },
- "id": 411,
- "options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_local_recv_queue_avg{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Avg. Recv Queue",
+ "type": "timeseries"
},
- "tooltip": {
- "mode": "single"
- }
- },
- "targets": [
{
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
},
- "exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_local_recv_queue_min{job=\"${rel}-${jobsuffix}\"}) by (pod)",
- "interval": "",
- "legendFormat": "{{ pod }}",
- "refId": "A"
- }
- ],
- "title": "WSREP Min. Recv Queue",
- "type": "timeseries"
- },
- {
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "palette-classic"
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 7,
+ "y": 46
},
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
+ "id": 411,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
},
- "thresholdsStyle": {
- "mode": "off"
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
}
},
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
},
- {
- "color": "red",
- "value": 80
- }
- ]
- }
- },
- "overrides": []
- },
- "gridPos": {
- "h": 6,
- "w": 7,
- "x": 14,
- "y": 46
- },
- "id": 413,
- "options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_local_recv_queue_min{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Min. Recv Queue",
+ "type": "timeseries"
},
- "tooltip": {
- "mode": "single"
- }
- },
- "targets": [
{
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
},
- "exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_local_recv_queue_max{job=\"${rel}-${jobsuffix}\"}) by (pod)",
- "interval": "",
- "legendFormat": "{{ pod }}",
- "refId": "A"
- }
- ],
- "title": "WSREP Max. Recv Queue",
- "type": "timeseries"
- },
- {
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "palette-classic"
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 14,
+ "y": 46
},
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
+ "id": 413,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
},
- "thresholdsStyle": {
- "mode": "off"
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
}
},
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
},
- {
- "color": "red",
- "value": 80
- }
- ]
- },
- "unit": "ns"
- },
- "overrides": []
- },
- "gridPos": {
- "h": 6,
- "w": 7,
- "x": 0,
- "y": 52
- },
- "id": 415,
- "options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_local_recv_queue_max{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Max. Recv Queue",
+ "type": "timeseries"
},
- "tooltip": {
- "mode": "single"
- }
- },
- "targets": [
{
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ },
+ "unit": "ns"
+ },
+ "overrides": []
},
- "exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_flow_control_paused_ns{job=\"${rel}-${jobsuffix}\"}) by (pod)",
- "interval": "",
- "legendFormat": "{{ pod }}",
- "refId": "A"
- }
- ],
- "title": "WSREP Flow Control Paused NS",
- "type": "timeseries"
- },
- {
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "palette-classic"
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 0,
+ "y": 52
},
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 5,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
+ "id": 415,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
},
- "thresholdsStyle": {
- "mode": "off"
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
}
},
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
},
- {
- "color": "red",
- "value": 80
- }
- ]
- }
- },
- "overrides": []
- },
- "gridPos": {
- "h": 6,
- "w": 7,
- "x": 7,
- "y": 52
- },
- "id": 417,
- "options": {
- "legend": {
- "calcs": [],
- "displayMode": "list",
- "placement": "bottom"
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_flow_control_paused_ns{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Flow Control Paused NS",
+ "type": "timeseries"
},
- "tooltip": {
- "mode": "single"
- }
- },
- "targets": [
{
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 5,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green"
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
},
- "exemplar": true,
- "expr": "sum (mysql_global_status_wsrep_cert_deps_distance{job=\"${rel}-${jobsuffix}\"}) by (pod)",
- "interval": "",
- "legendFormat": "{{ pod }}",
- "refId": "A"
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 7,
+ "y": 52
+ },
+ "id": 417,
+ "options": {
+ "legend": {
+ "calcs": [],
+ "displayMode": "list",
+ "placement": "bottom"
+ },
+ "tooltip": {
+ "mode": "single",
+ "sort": "none"
+ }
+ },
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
+ },
+ "exemplar": true,
+ "expr": "sum (mysql_global_status_wsrep_cert_deps_distance{job=\"${rel}-${jobsuffix}\"}) by (pod)",
+ "interval": "",
+ "legendFormat": "{{ pod }}",
+ "refId": "A"
+ }
+ ],
+ "title": "WSREP Cert Deps Distance",
+ "type": "timeseries"
}
],
- "title": "WSREP Cert Deps Distance",
- "type": "timeseries"
+ "title": "Cluster Replication Health",
+ "type": "row"
}
],
"refresh": "",
- "schemaVersion": 34,
+ "schemaVersion": 35,
"style": "dark",
"tags": [
"MySQL",
@@ -6350,6 +6417,6 @@
"timezone": "browser",
"title": "MySQL Cluster Overview",
"uid": "in6QqGJn7",
- "version": 19,
+ "version": 2,
"weekStart": ""
} \ No newline at end of file