Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-09 Thread Robert Coli
On Tue, Jul 9, 2013 at 12:36 AM, Ananth Gundabattula < agundabatt...@threatmetrix.com> wrote: > > The thread below makes me wonder "Does RF matter when using sstable loader.?" My assumption was that stable loader will take care of RF when the streaming is done but just wanted to cross check. We ar

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-09 Thread Ananth Gundabattula
cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Migrating data from 2 node cluster to a 3 node cluster Without vnodes the initial_token is stored in the yaml file, as well as the system LocationInfo CF. With vnodes the o

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-08 Thread aaron morton
Without vnodes the initial_token is stored in the yaml file, as well as the system LocationInfo CF. With vnodes the only place the tokens are stored is in the system KS. So moving a node without it's system KS will cause it to generate new ones which will mean data is moved around. Cheers -

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-08 Thread sankalp kohli
"Leaving the system keyspaces behind is OK if you are not using vnodes. " Why is it different for vnodes? On Mon, Jul 8, 2013 at 3:37 PM, aaron morton wrote: > This might work for user created keyspaces but might not work for system > keyspace > > Leaving the system keyspaces behind is OK if yo

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-08 Thread aaron morton
> This might work for user created keyspaces but might not work for system > keyspace Leaving the system keyspaces behind is OK if you are not using vnodes. Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 9/07/2013,

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-08 Thread sankalp kohli
"If RF=N or RF>N, you can just copy all SStables to all nodes, watching out for name collision." This might work for user created keyspaces but might not work for system keyspace On Mon, Jul 8, 2013 at 2:07 PM, Robert Coli wrote: > On Fri, Jul 5, 2013 at 7:54 PM, srmore wrote: > >> RF of old

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-08 Thread Robert Coli
On Fri, Jul 5, 2013 at 7:54 PM, srmore wrote: > RF of old and new cluster is the same RF=3. Keyspaces and schema info is > also same. > You have a cluster where RF=3 and N=2? Does it.. work? What are the tokens of old and new nodes? >> > tokens for old cluster ( 2-node ) > If RF=N or RF>N, you

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-05 Thread srmore
On Fri, Jul 5, 2013 at 6:08 PM, Robert Coli wrote: > On Thu, Jul 4, 2013 at 10:03 AM, srmore wrote: > >> We are planning to move data from a 2 node cluster to a 3 node cluster. >> We are planning to copy the data from the two nodes (snapshot) to the new 2 >> nodes and hoping that Cassandra will

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-05 Thread Robert Coli
On Thu, Jul 4, 2013 at 10:03 AM, srmore wrote: > We are planning to move data from a 2 node cluster to a 3 node cluster. We > are planning to copy the data from the two nodes (snapshot) to the new 2 > nodes and hoping that Cassandra will sync it to the third node. Will this > work ? are there any

Re: Migrating data from 2 node cluster to a 3 node cluster

2013-07-04 Thread Jonathan Haddad
You should run a nodetool repair after you copy the data over. You could also use the sstable loader, which would stream the data to the proper node. On Thu, Jul 4, 2013 at 10:03 AM, srmore wrote: > We are planning to move data from a 2 node cluster to a 3 node cluster. We > are planning to co

Migrating data from 2 node cluster to a 3 node cluster

2013-07-04 Thread srmore
We are planning to move data from a 2 node cluster to a 3 node cluster. We are planning to copy the data from the two nodes (snapshot) to the new 2 nodes and hoping that Cassandra will sync it to the third node. Will this work ? are there any other commands to run after we are done migrating, like