I'm running a multi-cluster Cassandra setup in the Production environment and I want to create a new environment for Staging.
I managed to create a snapshot of the Production Cassandra databases and restore successfully to the Staging environment. But I'm not sure how to change the Keyspace name when restoring a snapshot.
E.g: if the production Cassandra keyspace is "foo_prod", I want to create a snapshot of this and restore to new keyspaces named "foo_staging", "foo_dev", "foo_testing"
@premuditha_185831 If you previously restored the snapshot using sstableloader , you can effectively do the same thing except you would place the snapshot files in a different directory structure. For example, if you want to restore a table named mytable to a keyspace foo_staging:
foo_staging in the destination cluster/path/to/snapshots/foo_staging/mytablefoo_staging/mytable/Load the data as follows:
$ sstableloader -d node_ip1,node_ip2 /path/to/snapshots/foo_staging/mytable
Let us know if you have any follow up questions. Cheers!
Hello,
I v found an interesting link: https://stackoverflow.com/questions/40548750/restore-cassandra-snapshot-to-new-keyspace-in-same-cluster
Just being tested in my lab .
Regards
Sébastien
Thanks @sebastien.fouquette_160564. It's effectively a variation of the method I proposed with the exception that the procedure you linked is for restoring snapshots to the same cluster. @premuditha_185831 has a different requirement -- restore snapshots from a production cluster to various non-production clusters. Cheers!
5 People are following this question.
