Grafana 7

Database Backup

Windows

Stop the previous version of Grafana running on the instance and change the start type as Manual
Follow the below steps to backup existing database
- Navigate to <postgres_installation_path>/bin
- Backup DB using by executing the command pg_dump --username=username --password=password grafana > grafana_backup

To Restore Database - psql grafana < grafana_backup

Linux

Stop the previous version of Grafana running on the instance
Follow the below steps to backup existing database
- Navigate to <postgres_installation_path>/bin
- Backup DB using by executing the command pg_dump --username=username --password=password grafana > grafana_backup

To Restore Database - psql grafana < grafana_backup

Grafana Migration

Deprecated plugins

Singlestat and Table plugins are removed in grafana 7.X
Singlestat is replaced with Stat; Stat is a Grafana native plugin which has more features than Singlestat
Table plugin is replaced with Newtable plugin

Please Note Newtable plugin doesnot have pagination in it

Grafana DataSource

Grafana now has two Neo4j DataSource

Neo4j
Neo4jDataSource(Latest) - Built by React

Both these data source will work fine in Grafana 7.X but any feature improvements will be added only to Neo4jDataSource. So it is Recommended to use the latest DataSource Neo4jDataSource for Grafana Migration

Dashboard Migration

Grafana dashboards are backward compatible which can be exported from previous version of Grafana and imported into Garfana 7.X by doing the following changes in the exported json file

Export Dashboards as json file from the previous Grafana version
change the following fields inside targets array of export json file
- “target” to “queryText”
- “rawQuery” to “table”
- “hide”: true to “hide”: false

Exported Dashboard json file

Compatible changes for Grafana 7.X

{
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": "-- Grafana --",
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "type": "dashboard"
      }
    ]
  },
  "editable": true,
  "gnetId": null,
  "graphTooltip": 0,
  "id": 371,
  "links": [],
  "panels": [
    {
      "cacheTimeout": null,
      "colorBackground": false,
      "colorValue": false,
      "colors": [
        "#299c46",
        "rgba(237, 129, 40, 0.89)",
        "#d44a3a"
      ],
      "datasource": "Neo4j_Local",
      "format": "none",
      "gauge": {
        "maxValue": 100,
        "minValue": 0,
        "show": false,
        "thresholdLabels": false,
        "thresholdMarkers": true
      },
      "gridPos": {
        "h": 9,
        "w": 12,
        "x": 0,
        "y": 0
      },
      "id": 2,
      "interval": null,
      "links": [],
      "mappingType": 1,
      "mappingTypes": [
        {
          "name": "value to text",
          "value": 1
        },
        {
          "name": "range to text",
          "value": 2
        }
      ],
      "maxDataPoints": 100,
      "nullPointMode": "connected",
      "nullText": null,
      "postfix": "",
      "postfixFontSize": "50%",
      "prefix": "",
      "prefixFontSize": "50%",
      "rangeMaps": [
        {
          "from": "null",
          "text": "N/A",
          "to": "null"
        }
      ],
      "sparkline": {
        "fillColor": "rgba(31, 118, 189, 0.18)",
        "full": false,
        "lineColor": "rgb(31, 120, 193)",
        "show": false
      },
      "tableColumn": "",
      "targets": [
        {
          "checkQuery": false,
          "hide": true,
          "rawQuery": true,
          "refId": "A",
          "table": true,
          "target": "MATCH (n:ALM)  RETURN count(n)",
          "timeSeries": true
        }
      ],
      "thresholds": "",
      "timeFrom": null,
      "timeShift": null,
      "title": "Panel Title",
      "type": "singlestat",
      "valueFontSize": "80%",
      "valueMaps": [
        {
          "op": "=",
          "text": "N/A",
          "value": "null"
        }
      ],
      "valueName": "avg"
    }
  ],
  "schemaVersion": 18,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": []
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {
    "refresh_intervals": [
      "5s",
      "10s",
      "30s",
      "1m",
      "5m",
      "15m",
      "30m",
      "1h",
      "2h",
      "1d"
    ],
    "time_options": [
      "5m",
      "15m",
      "1h",
      "6h",
      "12h",
      "24h",
      "2d",
      "7d",
      "30d"
    ]
  },
  "timezone": "",
  "title": "New dashboard Copy",
  "uid": "q2Sdbc7Mz",
  "version": 4
}

{
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": "-- Grafana --",
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "type": "dashboard"
      }
    ]
  },
  "editable": true,
  "gnetId": null,
  "graphTooltip": 0,
  "id": 371,
  "links": [],
  "panels": [
    {
      "cacheTimeout": null,
      "colorBackground": false,
      "colorValue": false,
      "colors": [
        "#299c46",
        "rgba(237, 129, 40, 0.89)",
        "#d44a3a"
      ],
      "datasource": "Neo4j_Local",
      "format": "none",
      "gauge": {
        "maxValue": 100,
        "minValue": 0,
        "show": false,
        "thresholdLabels": false,
        "thresholdMarkers": true
      },
      "gridPos": {
        "h": 9,
        "w": 12,
        "x": 0,
        "y": 0
      },
      "id": 2,
      "interval": null,
      "links": [],
      "mappingType": 1,
      "mappingTypes": [
        {
          "name": "value to text",
          "value": 1
        },
        {
          "name": "range to text",
          "value": 2
        }
      ],
      "maxDataPoints": 100,
      "nullPointMode": "connected",
      "nullText": null,
      "postfix": "",
      "postfixFontSize": "50%",
      "prefix": "",
      "prefixFontSize": "50%",
      "rangeMaps": [
        {
          "from": "null",
          "text": "N/A",
          "to": "null"
        }
      ],
      "sparkline": {
        "fillColor": "rgba(31, 118, 189, 0.18)",
        "full": false,
        "lineColor": "rgb(31, 120, 193)",
        "show": false
      },
      "tableColumn": "",
      "targets": [
        {
          "checkQuery": false,
          "hide": false,
          "table": true,
          "refId": "A",
          "table": true,
          "queryText": "MATCH (n:ALM)  RETURN count(n)",
          "timeSeries": true
        }
      ],
      "thresholds": "",
      "timeFrom": null,
      "timeShift": null,
      "title": "Panel Title",
      "type": "singlestat",
      "valueFontSize": "80%",
      "valueMaps": [
        {
          "op": "=",
          "text": "N/A",
          "value": "null"
        }
      ],
      "valueName": "avg"
    }
  ],
  "schemaVersion": 18,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": []
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {
    "refresh_intervals": [
      "5s",
      "10s",
      "30s",
      "1m",
      "5m",
      "15m",
      "30m",
      "1h",
      "2h",
      "1d"
    ],
    "time_options": [
      "5m",
      "15m",
      "1h",
      "6h",
      "12h",
      "24h",
      "2d",
      "7d",
      "30d"
    ]
  },
  "timezone": "",
  "title": "New dashboard Copy",
  "uid": "q2Sdbc7Mz",
  "version": 4
}

Export Dashboards as json file from the previous Grafana version

change the following fields inside targets array of export json file
- “target” to “queryText”
- “rawQuery” to “table”
- “hide”: true to “hide”: false

      "targets": [
        {
          "checkQuery": false,
          "hide": false,
          "table": true,
          "refId": "A",
          "queryText": "<query>"
        }
      ],