Okay, we are looking at setting up a production environment which means getting our quorum settings and strategies correct. However, we need to really understand the approach taken to get this right. So far we have been working with co-located nodes and our prod environment is going to be distributed across 2 DCs.
Our setup: Dev = 2 nodes, SimpleStrategy, RF=1 QA = 3 nodes, SimpleStrategy, RF=2 Prod = 2 DC's (3 nodes each), NetworkTopologyStrategy, RF=3 For the Dev and QA environment we have been using ConsistencyPolicy of ONE for reads and the default for writes For Prod I'm guessing we will be using a ConsistencyPolicy of LOCAL_QUORUM for both reads and writes. Correct me if I'm wrong but as I understand it: The Dev and QA environment can only use ConsistencyLevel of ONE or QUORUM. LOCAL_QUORUM cannot be used - well we've seen an exception stating LOCAL_QUORUM cannot be used with SimpleStrategy. The Prod environment should be able to use all ConsistencyPolicy's, however, we would have: Reads: LOCAL_QUORUM Writes: LOCAL_QUORUM - Is having LOCAL_QUORUM for reads going to affect us if we need to rely on the other DC as failover? - i.e. if we lose 2 nodes in DC1, will we still be able to read from DC2? - Would we need to ensure that any snitches are configured for the prod environment? - Is there anything else that I may be overlooking aside from these configuration values? Anthony