Data migration

[skrynnikov_m <sk...@epsysoft.com.ua>]

Hello!!!
Need to migrate data from one C* cluster to another periodically. During
migration schema can change(add or remove one, two fields). Could you
please suggest some tool?

Re: Data migration

[Ben Bromhead <be...@instaclustr.com>]

Use SSTableloader it comes with Cassandra and is designed for moving data
between clusters and is far simpler than sqoop. it "should" even work with
a schema change like you described (changing columns). It would
probably/definitely break if you were dropping tables.

Mind you I've never tried sstableloader while schema changes were occurring
so happy to be wrong.



On 14 April 2015 at 05:40, Prem Yadav <ip...@gmail.com> wrote:

> Look into sqoop. I believe using sqoop you can transfer data between C*
> clusters. I haven't tested it though.
> other option is to write a program to read from one cluster and write the
> required data to another.
>
> On Tue, Apr 14, 2015 at 12:27 PM, skrynnikov_m <
> skrinnikov.m@epsysoft.com.ua> wrote:
>
>> Hello!!!
>> Need to migrate data from one C* cluster to another periodically. During
>> migration schema can change(add or remove one, two fields). Could you
>> please suggest some tool?
>>
>>
>


-- 

Ben Bromhead

Instaclustr | www.instaclustr.com | @instaclustr
<http://twitter.com/instaclustr> | (650) 284 9692

Re: Data migration

[Prem Yadav <ip...@gmail.com>]

Look into sqoop. I believe using sqoop you can transfer data between C*
clusters. I haven't tested it though.
other option is to write a program to read from one cluster and write the
required data to another.

On Tue, Apr 14, 2015 at 12:27 PM, skrynnikov_m <skrinnikov.m@epsysoft.com.ua
> wrote:

> Hello!!!
> Need to migrate data from one C* cluster to another periodically. During
> migration schema can change(add or remove one, two fields). Could you
> please suggest some tool?
>
>