Re: Cassandra Splitting databases

2019-01-06 Thread Dor Laor
Basically it's all variations of alter keyspace command, depends on your actual starting point. ALTER KEYSPACE mykespace WITH replication = { 'class' : 'NetworkTopologyStrategy', 'replication_factor': '3', '' : 3, : 4}; The best is to play a bit with multi DC setup with docker images and repeat

Re: Cassandra Splitting databases

2019-01-05 Thread R1 J1
Dor Laor, I like your approach. If I restrict the replication factor of a keyspace to on premise data center and another to azure and attempt to split the cluster? Do you have some documentation I can refer to ? Regards R1J1 On Fri, Jan 4, 2019 at 5:32 PM Dor Laor wrote: > Not sure I

Re: Cassandra Splitting databases

2019-01-04 Thread Jeff Jirsa
I encourage you to try all of these in a lab/non-prod environment before you do this in production. And take backups. This is risky and you should think about what you're doing before you do it. The most practical way to do this with no downtime is to spin up a new cluster in Azure and either do

Re: Cassandra Splitting databases

2019-01-04 Thread Dor Laor
Not sure I understand correctly but if you have one cluster with 2 separate datacenters you can define keyspace A to be on premise with a single DC and keyspace B only on Azure. On Fri, Jan 4, 2019 at 2:23 PM R1 J1 wrote: > We currently have 2 databases (A and B ) on a 6 node cluster. > 3

Cassandra Splitting databases

2019-01-04 Thread R1 J1
We currently have 2 databases (A and B ) on a 6 node cluster. 3 nodes are on premise and 3 in azure. I want database A to live on onpremise cluster and I want Database B to stay in the Azure. I want to then split the cluster into 2 clusters one onpremise (3 node ) having Database A and