bulk uploading

[Rahul Bhardwaj <ra...@indiamart.com>]

Hi All,

We have a cassandra cluster of 3 machines, which has a table containing 50
millions of rows. We are making a new cluster of 5 nodes  and we want to
migrate this table to the new cluster.


Please suggest what would be the best and least time taking process. I know
we can use sstable loader but how will it sync three nodes data into 5
nodes.



Regards:
Rahul Bhardwaj

-- 

Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this 
and more: <https://plus.google.com/+indiamart> 
<https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART> Mobile 
Channel: 
<https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8> 
<https://play.google.com/store/apps/details?id=com.indiamart.m> 
<http://m.indiamart.com/>
<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>
Check out some smart tips to generate more business - *IndiaMART Learning 
Centre* <http://corporate.indiamart.com/quick-learn/>

Re: bulk uploading

["C.B." <co...@coolbsd.com>]

I would like do live migration instead of offline bulk load.

You can make 3-node old cluster as dc1, the 5-node new cluster as dc2, 
then "nodetool rebuild dc1" on dc2, in this way, you don't need to take 
down the cluster to maintain consistency.

On 5/5/15 11:04 AM, Robert Coli wrote:
>
>
> On Tue, May 5, 2015 at 1:22 AM, Rahul Bhardwaj 
> <rahul.bhardwaj@indiamart.com <ma...@indiamart.com>> 
> wrote:
>
>     Hi All,
>
>     We have a cassandra cluster of 3 machines, which has a table
>     containing 50 millions of rows. We are making a new cluster of 5
>     nodes  and we want to migrate this table to the new cluster.
>
>
>     Please suggest what would be the best and least time taking
>     process. I know we can use sstable loader but how will it sync
>     three nodes data into 5 nodes.
>
>
> http://www.pythian.com/blog/bulk-loading-options-for-cassandra/
>
> =Rob
>

Re: bulk uploading

[Robert Coli <rc...@eventbrite.com>]

On Tue, May 5, 2015 at 1:22 AM, Rahul Bhardwaj <rahul.bhardwaj@indiamart.com
> wrote:

> Hi All,
>
> We have a cassandra cluster of 3 machines, which has a table containing 50
> millions of rows. We are making a new cluster of 5 nodes  and we want to
> migrate this table to the new cluster.
>
>
> Please suggest what would be the best and least time taking process. I
> know we can use sstable loader but how will it sync three nodes data into 5
> nodes.
>

http://www.pythian.com/blog/bulk-loading-options-for-cassandra/

=Rob