Re: Is this SSTable restore merging scenario possible ?

2018-03-21 Thread Carlos Rolo
As said before, as long as you rename the UUIDs to match you should be good. The Production "win out" depends on the timestamps. In Cassandra last write wins, so as long as, for the same row, the production timestamps are more recent than the secondary cluster, the production data would "win

Re: Is this SSTable restore merging scenario possible ?

2018-03-21 Thread Rahul Singh
If its not on the same “cluster” and you are not using something like OpsCenter, the snapshotted files will have a diferent schema UUID for each entity. If you rename the files to have the matching UUID in the file names, then you should be able to do what you are talking about. On Mar 21,

Is this SSTable restore merging scenario possible ?

2018-03-21 Thread Andrew Voumard
Hi All, I am using Cassandra 3.10 I would like to know if the following SSTable row level merging scenario is possible: 1. On a Production Cluster - Take a full snapshot on every node 2. On a new, empty Secondary Cluster with the same topology - Create a matching schema (keyspaces + tables as