Backing up and restoring DSE Graphs in OpsCenter

Guidelines for backing up and restoring DSE Graphs using the OpsCenter Backup Service. DataStax recommends upgrading to OpsCenter 6.5 or later to take advantage of simplified backups and restores for DSE Graphs.

Follow these instructions to backup and restore DSE Graphs using the OpsCenter Backup Service. The steps you need to follow depend on:
  • The versions of DSE and OpsCenter.
  • The type of restore operation (to the same cluster or cloned data to a different cluster).
  • Whether or not a graph was dropped.

DataStax highly recommends upgrading to OpsCenter 6.5 or later to take advantage of improved and simplified backups and restores for DSE Graphs. To restore a graph backup from DSE 5.1 to DSE 6.0 or later, the backup must be taken in OpsCenter 6.5 or later. The graph_name_pvt table has been removed for DSE versions 6.0 and later. When restoring a DSE 5.1.x graph, the _pvt table is removed during the restore process by OpsCenter 6.5 and later.

For example, if a DSE Graph 5.1 backup was taken in OpsCenter 6.5, the DSE Graph 5.1 graph can be restored in DSE 6.0.

Procedure

  1. In OpsCenter, create a backup of the DSE Graph: Run an ad-hoc backup, create a one-off scheduled backup, or set up a recurring scheduled backup.
    Note: If a DSE Graph backup was created in OpsCenter 6.1 or earlier for DSE 5.1 or earlier, OpsCenter cannot restore that legacy backup into DSE 6.0 because the data needed is not present in the older backup schemas. In this case, upgrade to OpsCenter 6.5 or later and create a backup for the DSE 5.1 graph in OpsCenter 6.5.
  2. Restore the backup to the same cluster or a cloned cluster as appropriate. See Restoring a cluster and Cloning cluster data.
  3. For cloned clusters, ensure the topology of the target cluster keyspaces is the same as the topology of source cluster keyspaces.
    Note: Ensure the source and target datacenter names and topology are identical. See Managing datacenter topologies and Cloning cluster data.