Hi Tom,

While reading data ( even at CL LOCAL_QUORUM), if data in different nodes 
required to meet CL in your local cluster doesnt match, data will be read from 
remote dc for read repair if read_repair_chance is not 0.


Imp points:

1.If you are reading and writing at local_quorum you can set read_repair_chance 
to 0 to prevent cross dc read repair.

2. For enabling dc local read repairs you can use dclocal_read_repair_chance 
and set read_repair_chance to 0.

3. If you are experiencing frequent requests being routed due to digest 
mismatch you may need to investigate mutation drops in your cluster using 
tpstats.


Refer to similar issue raised by us 
:https://issues.apache.org/jira/browse/CASSANDRA-8479


Thanks

Anuj


Sent from Yahoo Mail on Android

From:"Tom van den Berge" <t...@drillster.com>
Date:Tue, 8 Sep, 2015 at 1:31 am
Subject:Re: How to prevent queries being routed to new DC?

NetworkTopologyStrategy


On Mon, Sep 7, 2015 at 4:39 PM, Ryan Svihla <r...@foundev.pro> wrote:

What's your keyspace replication strategy?


On Thu, Sep 3, 2015 at 3:16 PM Tom van den Berge <tom.vandenbe...@gmail.com> 
wrote:

Thanks for your help so far!


I have some problems trying to understand the jira mentioned by Rob :(


I'm currently trying to set up the first node in the new DC with auto_bootstrap 
= true. The node then becomes visible with status "joining", which (hopefully) 
prevents other DCs from sending queries to it.


Do you think this will work?




On Thu, Sep 3, 2015 at 9:46 PM, Robert Coli <rc...@eventbrite.com> wrote:

On Thu, Sep 3, 2015 at 12:25 PM, Bryan Cheng <br...@blockcypher.com> wrote:

I'd recommend you enable tracing and do a few queries in a controlled 
environment to verify that queries are being routed to your new nodes. Provided 
you have followed the procedure outlined above (specifically, have set 
auto_bootstrap to false in your new cluster), rebuild has not been run, the 
application is not connecting to the new cluster, and all your queries are run 
at LOCAL_* quorum levels, I do not believe those queries should be routed to 
the new dc.


Other than CASSANDRA-9753, this is true.


https://issues.apache.org/jira/browse/CASSANDRA-9753 (Unresolved; ): 
"LOCAL_QUORUM reads can block cross-DC if there is a digest mismatch" 


=Rob



-- 

Regards,

Ryan Svihla 




-- 

Tom van den Berge 
Lead Software Engineer 
  Middenburcht 136 
3452 MT Vleuten 
Netherlands+31 30 755 53 30 
www.drillster.com  Follow us on Facebook

Reply via email to