On Tue, Jun 5, 2012 at 4:30 PM, Jim Ancona <j...@anconafamily.com> wrote:

> It might be a good idea for the documentation to reflect the tradeoffs
> more clearly.


Here's a proposed addition to the Secondary Index FAQ at
http://wiki.apache.org/cassandra/SecondaryIndexes

Q: How does choice of Consistency Level affect cluster availability when
using secondary indexes?
A: Because secondary indexes are distributed, you must have CL level nodes
available for *all* token ranges in the cluster in order to complete a
query. For example, with RF = 3, when two out of three consecutive nodes in
the ring are unavailable, *all* secondary index queries at CL = QUORUM will
fail, however secondary index queries at CL = ONE will succeed. This is
true regardless of cluster size.

Comments?

Jim

Reply via email to