Hi guys, We have a keyspace with more or less 40 tables. We have been adding things in there since Cassandra 0.8 to our current C* - 1.2.18 there for simplicity and cost reasons. Now we need to duplicate part of the data to an other DC, to improve end user latency.
What would be the best way of splitting this ks but staying online (or with the smallest downtime) ? What would be advantages / disadvantages of keeping those ks recently created in the same cluster rather in distinct cluster. The more general question behind this is, what would be according to your experience, the main reason of choosing grouping tables into one ks, multiple ks or directly multiple clusters and how to migrate from these different architectures ? Any thoughts, blog addressing this question or even documentation on this ?
