Jan: sstableloader will only stream to nodes that are supposed to hold the data. The nodes on the new DC have different token ranges, so I can't simply copy the sstables.
Surbhi: Because 2-5 minutes of connectivity issues (VPN downtime) between the DCs breaks the bootstrap process. /J On Fri, Apr 22, 2016 at 3:40 PM Surbhi Gupta <surbhi.gupt...@gmail.com> wrote: > Why dont you use nodetool rebuild ? > > On 21 April 2016 at 09:16, Jan <cne...@yahoo.com> wrote: > >> Jens; >> >> I am unsure that you need to enable Replication & also use the sstable >> loader. >> You could load the data into the new DC and susbsequently alter the >> keyspace to replicate from the older DC. >> >> Cheers >> Jan >> >> >> -------------------------------------------- >> On Thu, 4/21/16, Jens Rantil <jens.ran...@tink.se> wrote: >> >> Subject: Re: Alternative approach to setting up new DC >> To: user@cassandra.apache.org >> Date: Thursday, April 21, 2016, 9:00 AM >> >> Hi, >> I never got >> any response here, but just wanted to share that I went to a >> Cassandra meet-up in Stockholm yesterday where I talked to >> two knowledgable Cassandra people that verified that the >> approach below should work. The most important thing is that >> the backup must be fully imported before gc_grace_seconds >> after when the backup is taken. >> As of me, I managed to a get a more >> stable VPN setup and did not have to go down this >> path. >> Cheers,Jens >> >> On Mon, Apr >> 18, 2016 at 10:15 AM Jens Rantil <jens.ran...@tink.se> >> wrote: >> Hi, >> I am >> provisioning a new datacenter for an existing cluster. A >> rather shaky VPN connection is hindering me from making a >> "nodetool rebuild" bootstrap on the new DC. >> Interestingly, I have a full fresh database snapshot/backup >> at the same location as the new DC (transferred outside of >> the VPN). I am now considering the following >> approach:Make >> sure my clients are using the old DC. >> Provision the new nodes in new >> DC. >> ALTER the keyspace to enable >> replicas on the new DC. This will start replicating all >> writes from old DC to new DC. >> Before >> gc_grace_seconds after operation 3) above, use sstableloader >> to stream my backup to the new nodes. >> For >> safety precaution, do a full repair. >> Could you see any issues with >> doing this? >> Cheers,Jens-- >> >> >> >> >> >> >> >> >> Jens Rantil >> Backend Developer @ Tink >> Tink AB, Wallingatan 5, 111 60 Stockholm, Sweden >> For urgent matters you can reach me at >> +46-708-84 18 >> 32.-- >> >> >> >> >> >> >> >> >> Jens Rantil >> Backend Developer @ Tink >> Tink AB, Wallingatan 5, 111 60 >> Stockholm, Sweden >> For urgent matters you can >> reach me at +46-708-84 18 32. >> > > -- Jens Rantil Backend Developer @ Tink Tink AB, Wallingatan 5, 111 60 Stockholm, Sweden For urgent matters you can reach me at +46-708-84 18 32.
