cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Gadhiya <ankitgadh...@gmail.com>
Subject Re: *URGENT* Migration across different Cassandra cluster few having same keyspace/table names
Date Fri, 17 Jan 2020 13:28:54 GMT
Thanks but there’s no DSE License.
Wondering how sstableloader will help as some oh the Keyspace and tables
names are same. Also how do i sync few system keyspaces.


Thanks & Regards,
Ankit

On Fri, Jan 17, 2020 at 1:11 AM Vova Shelgunov <vvshvv@gmail.com> wrote:

> Loader*
>
> https://www.datastax.com/blog/2018/05/introducing-datastax-bulk-loader
>
> On Fri, Jan 17, 2020, 09:09 Vova Shelgunov <vvshvv@gmail.com> wrote:
>
>> DataStax bulk loaded can be an option if data is large.
>>
>> On Fri, Jan 17, 2020, 07:33 Nitan Kainth <nitankainth@gmail.com> wrote:
>>
>>> If the keyspace already exist, use copy command or sstableloader to
>>> merge data. If data volume it too big, consider spark or a custom java
>>> program
>>>
>>>
>>> Regards,
>>>
>>> Nitan
>>>
>>> Cell: 510 449 9629
>>>
>>> On Jan 16, 2020, at 10:26 PM, Ankit Gadhiya <ankitgadhiya@gmail.com>
>>> wrote:
>>>
>>> 
>>> Any leads on this ?
>>>
>>> — Ankit
>>>
>>> On Thu, Jan 16, 2020 at 8:51 PM Ankit Gadhiya <ankitgadhiya@gmail.com>
>>> wrote:
>>>
>>>> Hi Arvinder,
>>>>
>>>> Thanks for your response.
>>>>
>>>> Yes - Cluster B already has some data. Tables/KS names are identical ;
>>>> for data - I still haven't got the clarity if it has identical data or no
-
>>>> I am assuming no since it's for different customers but need the
>>>> confirmation.
>>>>
>>>> *Thanks & Regards,*
>>>> *Ankit Gadhiya*
>>>>
>>>>
>>>>
>>>> On Thu, Jan 16, 2020 at 8:49 PM Arvinder Dhillon <dhillonarvi@gmail.com>
>>>> wrote:
>>>>
>>>>> So as I understand, Cluster B already has some data and not an empty
>>>>> cluster.
>>>>>
>>>>> When you say, clusters share same keyspace and table names, do you
>>>>> mean both clusters have identical data on those ks/tables?
>>>>>
>>>>>
>>>>> -Arvi
>>>>>
>>>>> On Thu, Jan 16, 2020, 5:27 PM Ankit Gadhiya <ankitgadhiya@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hello Group,
>>>>>>
>>>>>> I have a requirement in one of the production systems where I need
to
>>>>>> be able to migrate entire dataset from Cluster A (Azure Region A)
to
>>>>>> Cluster B (Azure Region B).
>>>>>>
>>>>>> Each cluster have 3 Cassandra nodes (RF=3) running used by different
>>>>>> applications. Few of the applications are common is Cluster A and
Cluster B
>>>>>> thereby sharing same keyspace/table names.
>>>>>> Need suggestion for the best possible migration strategy here
>>>>>> considering - 1. No Application code changes possible - Minor config/infra
>>>>>> changes can be considered. 2. Zero data loss. 3. No/Minimal downtime.
>>>>>>
>>>>>> It'd be great to hear ideas from all of you based on your experiences.
>>>>>>
>>>>>> Cassandra Version - Cassandra 3.0.13 on both sides.
>>>>>> Total Data size - Cluster A: 70 GB, Cluster B: 15 GB
>>>>>>
>>>>>> *Thanks & Regards,*
>>>>>> *Ankit Gadhiya*
>>>>>>
>>>>>> --
>>> *Thanks & Regards,*
>>> *Ankit Gadhiya*
>>>
>>> --
*Thanks & Regards,*
*Ankit Gadhiya*

Mime
View raw message