Other data migration scenarios

At times you may need to migrate large amounts of data from one cluster to another. A common reason for this is the need to transition data between networks that cannot see each other, or moving from classic Amazon EC2 to a newer Virtual Private Cloud (VPC) infrastructure.

If you find yourself in this situation, you can use these steps to ensure a smooth transition to the new infrastructure:

1. Set up your new cluster using the information you learned from this chapter, configure your cluster, and duplicate the schema from your existing cluster.

2. Change your application to write to both clusters. This is certainly the most significant change, as it likely requires code changes in your application.

3. Verify you are receiving writes to both clusters to avoid potential data loss.

4. Create a snapshot of your old cluster using the nodetool snapshot command.

5. Load the snapshot data into your new cluster using the sstableloader command. This command actually streams the data into...