Re: Restoring keyspace using snapshots

2014-01-30 Thread Robert Coli
On Wed, Jan 29, 2014 at 9:45 PM, Senthil, Athinanthny X. -ND < athinanthny.x.senthil@disney.com> wrote: > Plan to backup and restore keyspace from PROD to PRE-PROD cluster which > has same number of nodes. Keyspace will have few hundred millions of rows. > We need to do this every other week.

Re: Restoring keyspace using snapshots

2014-01-30 Thread John Anderstedt
In this case I would go on with the nodetool refresh, simply because you use the machines in a more effective way.(copy data from one node to another, each node cleans/refresh the data itself) if the clustersetup is the same with nodes/tokens there’s no need to copy all the data to one point an

Restoring keyspace using snapshots

2014-01-29 Thread Senthil, Athinanthny X. -ND
Plan to backup and restore keyspace from PROD to PRE-PROD cluster which has same number of nodes. Keyspace will have few hundred millions of rows. We need to do this every other week. Which one of the below options most time-efficient and puts less stress on target cluster ? We want to finish