Re: How to avoid inter-dc read requests

2013-07-24 Thread aaron morton
That does not measure what the servers are doing though. Track the number of reads per CF, it's exposed with nodetool cfstats and is in ops centre as well. Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 24/07/2013, at 12:22

Re: How to avoid inter-dc read requests

2013-07-23 Thread Omar Shibli
I simply monitor the load avg of the nodes using opscenter. I started with idle nodes (by idle I mean load avg of all nodes < 1.0), then started to run a lot of key slice read requests on *"analytic" DC *with CL local quorum (I also made sure that the client worked with only with analytic DC), afte

Re: How to avoid inter-dc read requests

2013-07-23 Thread aaron morton
> All the read/write request are issued with CL local quorum, but still > there're a lot of inter-dc read request. > How are you measuring this ? Cheers - Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 22/07/2013, at 8:41 AM, sankalp

Re: How to avoid inter-dc read requests

2013-07-21 Thread sankalp kohli
Slice query does not trigger background read repair. Implement Read Repair on Range Queries On Sun, Jul 21, 2013 at 1:40 PM, sankalp kohli wrote: > There can be multiple reasons for that > 1) Background read repairs. > 2) Your data is not cons

Re: How to avoid inter-dc read requests

2013-07-21 Thread sankalp kohli
There can be multiple reasons for that 1) Background read repairs. 2) Your data is not consistent and leading to read repairs. 3) For writes, irrespective of the consistency used, a single write request will goto other DC 4) You might be running other nodetools commands like repair. read_repair_cha

Re: How to avoid inter-dc read requests

2013-07-21 Thread Omar Shibli
One more thing, I'm doing a lot of key slice read requests, is that supposed to change anything? On Sun, Jul 21, 2013 at 8:21 PM, Omar Shibli wrote: > I'm seeing a lot of inter-dc read requests, although I've followed > DataStax guidelines for multi-dc deployment > http://www.datastax.com/dev/blo

How to avoid inter-dc read requests

2013-07-21 Thread Omar Shibli
I'm seeing a lot of inter-dc read requests, although I've followed DataStax guidelines for multi-dc deployment http://www.datastax.com/dev/blog/deploying-cassandra-across-multiple-data-centers Here is my setup: 2 data centers within the same region (AWS) Targeting DC, RP 3, 6 nodes Analytic DC, RP