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

2013-07-09 Thread Ananth Gundabattula
@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto: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 only place the tokens

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 are

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 comom...@gmail.com 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

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

2013-07-08 Thread sankalp kohli
If RF=N or RFN, 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 rc...@eventbrite.com wrote: On Fri, Jul 5, 2013 at 7:54 PM, srmore

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
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 aa...@thelastpickle.comwrote: This might work for user created keyspaces but might not work for system keyspace Leaving the system keyspaces

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-05 Thread Robert Coli
On Thu, Jul 4, 2013 at 10:03 AM, srmore comom...@gmail.com 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

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 rc...@eventbrite.com wrote: On Thu, Jul 4, 2013 at 10:03 AM, srmore comom...@gmail.com 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

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

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 comom...@gmail.com wrote: We are planning to move data from a 2 node cluster to a 3 node cluster. We