Read-your-writes consistency guarantees that a client’s later reads reflect its completed writes. In ScyllaDB, QUORUM consistency for both reads and writes provides this behavior and prevents queries from accessing stale data. section 8.2.2
Choose a consistency level according to the balance between consistency, availability, and cluster load:
- Use QUORUM for reads and writes when clients should read recently written data and tolerate the loss of at least one node with replication factor 3. section 8.2.2
- Use ONE for reads when lower cluster load matters and the application can tolerate potentially stale data. section 8.2.2
- Use LOCAL_QUORUM or EACH_QUORUM to control whether quorum obligations apply within one datacenter or across every datacenter. section 8.2.2
