question

mitchell.fish avatar image
mitchell.fish asked Erick Ramirez answered

Is there an easy way to copy a complete Cassandra database from one Linux server to another?

Need to move a TWCloud instance from one server to another

restore
10 |1000

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

In Cassandra, this is referred to as cloning application keyspaces. You will still need to install and configure C* on the destination cluster but cloning the app data is a fairly simple process.

If there's only one node in the destination cluster, you can simply use the import method by copying the application (not system) SSTables from the snapshots of the source cluster to a directory on the destination node then run:

$ nodetool import ks_name table_name -d /path/to/sstables

This is a variation of the "refresh method" in Restoring from a snapshot.

For what it's worth, I've previously documented steps for cloning app keyspaces on multi-node clusters in these posts:

Cheers!

Share
10 |1000

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