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 keyspaces).
Does that make sense (so growing up to 200 dcs of 3 servers each in best
Does the cql-engine make a new connection (like "use keyspace") when
specifying "keyspace.table" on the query ?
Are the keyspaces+tables of dc1 stored in a cassandra node of dc2 ?(since
there is overhead with each keyspace + table which would probably break
Or is it just a simple map dcx--->ip1,ip2,ip3 ?