Re: Refresh from Prod to Dev

[Pradeep Chhetri]

Hi Anshu,

We used to have similar requirements in my workplace.

We tried multiple options like snapshot and restore it but the best one
which worked for us was making a same number of nodes of cas cluster in
preprod and doing a parallel scp of the data directly from production to
preprod and then run a nodetool refresh.

On Fri, 9 Feb 2018 at 12:03 PM, Anshu Vajpayee 
wrote:

> Team ,
>
> I want to validate and POC on production data. Data on production
> is huge.  What could be optimal method to move the data from Prod to Dev
> environment?  I know there are few solutions but what/which is most
> efficient method do refresh for dev env?
>
> --
> *C*heers,*
> *Anshu V*
>
>
>

Re: Refresh from Prod to Dev

[Rahul Singh]

If you have equivalent number of nodes then use snapshot to backup and then 
restore them on Dev. You will need to create the schema on the Dev box. The 
CFiD will be different so at most you may have to rename the Prod sstable dirs 
to match whats on Dev.

Another method is to use sstableloader if you don’t have an equivalent number 
of nodes.

Otherwise if you can throw away Dev , just take everything from Prod and bring 
it up in a new Dev.

--
Rahul Singh
rahul.si...@anant.us

Anant Corporation

On Feb 9, 2018, 1:18 AM -0500, Anshu Vajpayee , wrote:
> Team ,
>
> I want to validate and POC on production data. Data on production is huge.  
> What could be optimal method to move the data from Prod to Dev environment?  
> I know there are few solutions but what/which is most efficient method do 
> refresh for dev env?
>
> --
> C*heers,
> Anshu V
>
>