Re: Using keyspaces for virtual clusters

2016-09-21 Thread Dorian Hoxha
@Alain I wanted to do 2, but looks like that won't be possible because of too much overhead. @Eric Yeah that's what I was afraid of. Though I know that the client connects to every server, I just didn't want to do the extra code. On Wed, Sep 21, 2016 at 4:56 PM, Eric Stevens wrote: > Using keys

Re: Using keyspaces for virtual clusters

2016-09-21 Thread Eric Stevens
Using keyspaces to support multi tenancy is very close to an anti pattern unless there is a finite and reasonable upper bound to how many tenants you'll support overall. Large numbers of tables comes with cluster overhead and operational complexity you will come to regret eventually. >and because

Re: Using keyspaces for virtual clusters

2016-09-21 Thread Alain RODRIGUEZ
Hi Dorian, I'm thinking of creating many keyspaces and storing them into many virtual > datacenters (the servers will be in 1 logical datacenter, but separated by > keyspaces). > > Does that make sense (so growing up to 200 dcs of 3 servers each in best > case scenario)? There is 3 main things y

Using keyspaces for virtual clusters

2016-09-20 Thread Dorian Hoxha
Hi, I need to separate clients data into multiple clusters and because I don't like having multiple cql clients/connections on my app-code, I'm thinking of creating many keyspaces and storing them into many virtual datacenters (the servers will be in 1 logical datacenter, but separated by keyspace