question

adampaul avatar image
adampaul asked Erick Ramirez commented

Can someone guide me for the exact procedure for backup and restore?

I want to backup and restore keyspace please guide me the steps for following scenarios.

I tried few documents but not working in my case.

Requirments :

I have one 3 node test cluster-1 having 2 keyspace with 2 tables each. I want to backup and restore these 2 keyspace to cluster 2 which has different number of nodes i.e 2 nodes and i want to restore keyspace with different name than source node.

For eg. Cluster-1 ks names : testks_23082020 and testks_24082020

Want cluster-2 keyspace names as testks_21092020_adam and testks_23092020 but data same as that of cluster-1.

I tried using schema creation and loading sstables by stopping dse and starting post copying and sstableloader also but post restoration i am getting incompatible version for few columns .

I am using dse 6.7.4 version please guide exact steps and method. Please note node configuration is different on both cluster

dsebackup
10 |1000
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 Erick Ramirez commented

As I stated in your other post (#8519), you cannot restore tables with user-defined types (UDTs) to another keyspace.

The UDT definition is part of a keyspace so it is encoded with the data in the SSTables. As such, you can only restore data to the same keyspace. Cheers!

2 comments Share
10 |1000
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.

adampaul avatar image adampaul commented ·

Thanks for the valuable support. appreciate quick response.

0 Likes 0 ·
Erick Ramirez avatar image Erick Ramirez ♦♦ adampaul commented ·

Glad to help. Cheers!

0 Likes 0 ·