PLANNED MAINTENANCE

Hello, DataStax Community!

We want to make you aware of a few operational updates which will be carried out on the site. We are working hard to streamline the login process to integrate with other DataStax resources. As such, you will soon be prompted to update your password. Please note that your username will remain the same.

As we work to improve your user experience, please be aware that login to the DataStax Community will be unavailable for a few hours on:

  • Wednesday, July 15 16:00 PDT | 19:00 EDT | 20:00 BRT
  • Thursday, July 16 00:00 BST | 01:00 CEST | 04:30 IST | 07:00 CST | 09:00 AEST

For more info, check out the FAQ page. Thank you for being a valued member of our community.

question

michael.guissine_30999 avatar image
michael.guissine_30999 asked ·

Does OpsCenter support restoring data to a different table than the source table?

Hi,

Is it possible to restore a table (cf) to a new table in existing cluster using OpsCenter, for example I'd like to restore keyspace1.table1 to keyspace1.table1_20190101. Essentially I'd like to create a copy of existing table using Backup service.


The use case for me is to be able to periodically test backups integrity without the need to provision a new DSE cluster.


Thanks!

opscenterrestorebackup
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

@michael.guissine_30999 You won't be able to do it via OpsCenter. You will have to do it manually by copying the contents of the relevant snapshot directory to the directory of the new table and running nodetool refresh. See Restoring from a snapshot for details. Cheers!

3 comments Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

michael.guissine_30999 avatar image michael.guissine_30999 ·

Thanks @Erick Ramirez, this is easy when restoring from local but quite challenging if you need to restore from centralized backups because one needs to crawl through backup metadata to find which sstables to restore so would be nice if OpsCenter can help.

0 Likes 0 · ·
Erick Ramirez avatar image Erick Ramirez ♦♦ michael.guissine_30999 ·

@michael.guissine_30999 If you mean S3 for centralised backups, will knowing the directory structure help you? It looks like this:

  bucket_name/
    snapshots/
      id_of_node/
        sstables/
        backup_id-date_of_backup/
          backup.json
          keyspace/schema.json
0 Likes 0 · ·
Erick Ramirez avatar image Erick Ramirez ♦♦ michael.guissine_30999 ·

Within each node's subdirectory is a list of backups. If you are able to locate the date you wish to restore, you can workout from the backup.json file the list of SSTables which belong to that backup.

It isn't ideal but I hope it helps. Cheers!

0 Likes 0 · ·