CODEWITHSUNDEEP
cassandra
Nipun
Nipun

Reputation: 4319

Copying Cassandra data from one cluster to another

I have a cluster setup in Cassandra on AWS. Now, I need to move my cluster to some other place. Since taking image is not possible, I will create a new cluster exactly a replica of the old one. Now I need to move the data from this cluster to another. How can I do so?

My cluster has 2 data centers and each data center has 3 Cassandra machines with 1 seed machine.

Upvotes: 0

Views: 3330

Answers (4)

giasuddin
giasuddin

Reputation: 133

In cassandra there are two type of strategy SimpleStrategy and NetworkTopologyStrategy by using NetworkTopologyStrategy you can replicate in different cluster. see this documentation Data replication

You can use COPY command to export and import csv from one table to another Simple data importing and exporting with Cassandra

Upvotes: 0

rsangar1
rsangar1

Reputation: 31

Using SFTP server or through some other way, transfer the SSTables from old cluster to new cluster (one DC is enough) and use SSTableLoader. The data replication to another DC will be taken care by Cassandra.

Upvotes: 0

undefined_variable
undefined_variable

Reputation: 6218

You can take your SSTables from your data directory and then can use sstableloader in new data center to import the data.

Before doing this activity you might consider doing compaction so that you have only one SSTable per table.

SSTable Loader

Upvotes: 0

AlexL
AlexL

Reputation: 761

Do you have connectivity between the old and new cluster? If yes, why not linking the cluster and let cassandra replicate the data to the new cluster? After data is transferred, shut down the old cluster. Ideally you wouldn`t even have any downtime.

Upvotes: 2

Related Questions