cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anuj Wadehra <>
Subject Re: Scenarios which need Repair
Date Tue, 09 Feb 2016 10:10:13 GMT
Can someone take this?


  On Mon, 8 Feb, 2016 at 11:44 pm, Anuj Wadehra<> wrote:   Hi,

We are on 2.0.14. We have some deployments with just one DC(RF:3) while others with two DCs
We ALWAYS use LOCAL_QUORUM for both Reads and Writes. 

We used to run nodetool repair on all tables every gc_grace_seconds. Recently, we decided
to identify tables which really need repair and only run repair on those tables.

We have identified basically two kinds of tables which don't need repair:
TYPE-1 Tables which have only inserts, no upserts and delete by TTL.
TYPE-2 Tables with a counter column. I don't have much experience with counters but I can
explain the use case.
We use a counter column to keep check on our traffic rate.Values are usually updated numerous
times in a minute and we need not be ACCURATE with the value-few values here and there are

Can we COMPLETELY avoid maintenance repair on TYPE-1 and TYPE-2 tables? If yes, will there
be any side effect of not repairing such data often in case of dropped mutations, failure
scenarios etc.?
What will be the scenarios when repair would be needed on such tables?

View raw message