Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Database Backup

...

Expand
titleWindows
  • 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

Info

To Restore Database - psql grafana < grafana_backup

Expand
titleLinux
  • 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

Info

To Restore Database - psql grafana < grafana_backup

Grafana Migration

...

Expand
titleDeprecated 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

Expand
titleGrafana DataSource

Grafana now has two Neo4j DataSource

  • Neo4j

  • Neo4jDataSource(Latest) - Built in 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
Grafana 7.x
Expand
titleDashboard 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

Before Grafana 7.X

Exported Dashboard json file

Compatible changes for Grafana 7.X

Code Block
languagejson
{
  "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
}
Code Block
languagejson
{
  "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

...