2

Requirement: Cassandra PROD container runs in one reqion and DR container runs in another region.

  1. Take full snapshot of data folder and incremental snapshot of data folder
  2. If PROD region goes down, make DR container up pointing to data folder copied from PROD region.

will above scenario work? Because PROD and DR cluster nodes numbers are different, we cannot use nodetool and sstableloader ?

Erick Ramirez
  • 4,590
  • 1
  • 8
  • 30
naxoki
  • 21
  • 1

1 Answers1

1

You cannot just copy the data/ directory of a production node in one cluster to another node in a DR cluster. You can only clone the data in application keyspaces from one cluster to another. The system tables (particularly system.local) is universally unique to each node and cannot be duplicated.

What you need to do is build a fresh cluster in DR that is configured as its own separate cluster. Once it is up and running, you can then start cloning the tables of the application keyspaces of the production DR from snapshots.

For details of how to clone application data, see the detailed procedured I documented in How do I migrate data in tables to a new Cassandra cluster?. Cheers!

Erick Ramirez
  • 4,590
  • 1
  • 8
  • 30