Hi, Did you consider adding Cassandra nodes from cluster B, into cluster A as a different data center ?
Your keyspace would than be on Network topology data strategy. In this case, all data can be synced between both data centers by Cassandra using rebalancing. At client/application level you will have to ensure local quorum/ local consistency so that there is no impact on latencies. Once you have moved data applications to new cluster , you can then remove the old data center (cluster A), and cluster B would have fresh data. On Fri, Jan 17, 2020, 6:59 PM Ankit Gadhiya <ankitgadh...@gmail.com> wrote: > 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 <vvs...@gmail.com> wrote: > >> Loader* >> >> https://www.datastax.com/blog/2018/05/introducing-datastax-bulk-loader >> >> On Fri, Jan 17, 2020, 09:09 Vova Shelgunov <vvs...@gmail.com> wrote: >> >>> DataStax bulk loaded can be an option if data is large. >>> >>> On Fri, Jan 17, 2020, 07:33 Nitan Kainth <nitankai...@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 <ankitgadh...@gmail.com> >>>> wrote: >>>> >>>> >>>> Any leads on this ? >>>> >>>> — Ankit >>>> >>>> On Thu, Jan 16, 2020 at 8:51 PM Ankit Gadhiya <ankitgadh...@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 < >>>>> dhillona...@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 <ankitgadh...@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* > >