cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Carlucci <paul.carlu...@gmail.com>
Subject Re: Keyspace Clone in Existing Cluster
Date Wed, 30 Oct 2019 03:15:19 GMT
Straight up Unix cp command, make sure you're in the right directory.  If
you try to use schema.cql then you're going to have to massage it somewhat
due to keyspace name differences and schema changes over time.  You'll see
what I mean if you've got some.

It goes without saying that you're gonna want to try this in non-prod
first.  On a positive note you'll be learning some stuff they don't quite
teach in Datastax Academy!

On Tue, Oct 29, 2019, 8:39 AM Ankit Gadhiya <ankitgadhiya@gmail.com> wrote:

> Thanks Paul.
>
> Copy SSTable - How? Using SSTableLoader or some other mechanism.
>
>
> *Thanks & Regards,*
> *Ankit Gadhiya*
>
>
>
> On Tue, Oct 29, 2019 at 11:36 AM Paul Carlucci <paul.carlucci@gmail.com>
> wrote:
>
>> Copy the schema from your source keyspace to your new target keyspace,
>> nodetool snapshot on your source keyspace, copy the SSTable files over, do
>> a rolling bounce, repair, enjoy.  In my experience a rolling bounce is
>> easier than a nodetool refresh.
>>
>> It's either that or just copy it with Spark.
>>
>> On Tue, Oct 29, 2019, 11:19 AM Ankit Gadhiya <ankitgadhiya@gmail.com>
>> wrote:
>>
>>> Thanks Alex. So How do I copy SSTables from 1.0 to 2.0? (Same
>>> SSTableLoader or any other approach?)
>>> Also since I've multi-node cluster - I'll have to do this on every
>>> single node - is there any tool or better way to execute this just from a
>>> single node?
>>>
>>> *Thanks & Regards,*
>>> *Ankit Gadhiya*
>>>
>>>
>>>
>>> On Tue, Oct 29, 2019 at 11:16 AM Alex Ott <alexott@gmail.com> wrote:
>>>
>>>> You can create all tables in new keyspace, copy SSTables from 1.0 to
>>>> 2.0 tables & use nodetool refresh on tables in KS 2.0 to say Cassandra
>>>> about them.
>>>>
>>>> On Tue, Oct 29, 2019 at 4:10 PM Ankit Gadhiya <ankitgadhiya@gmail.com>
>>>> wrote:
>>>>
>>>>> Hello Folks,
>>>>>
>>>>> Greetings!.
>>>>>
>>>>> I've a requirement in my project to setup Blue-Green deployment for
>>>>> Cassandra. E.x. Say My current active schema (application pointing to)
is
>>>>> Keyspace V1.0 and for my next release I want to setup Keysapce 2.0 (with
>>>>> some structural changes) and all testing/validation would happen on it
and
>>>>> once successful , App would switch connection to keyspace 2.0 - This
would
>>>>> be generic release deployment for our project.
>>>>>
>>>>> One of the approach we thought of would be to Create keyspace 2.0 as
>>>>> clone from Keyspace 1.0 including data using sstableloader but this would
>>>>> be time consuming, also being a multi-node cluster (6+6 in each DC) -
it
>>>>> wouldn't be very feasible to do this manually on all the nodes for multiple
>>>>> tables part of that keyspace. Was wondering if we have any other creative
>>>>> way to suffice this requirement.
>>>>>
>>>>> Appreciate your time on this.
>>>>>
>>>>>
>>>>> *Thanks & Regards,*
>>>>> *Ankit Gadhiya*
>>>>>
>>>>>
>>>>
>>>> --
>>>> With best wishes,                    Alex Ott
>>>> http://alexott.net/
>>>> Twitter: alexott_en (English), alexott (Russian)
>>>>
>>>

Mime
View raw message