Like eventual consistency, scheduled repair seems eventually useful from nodes drifting away too much from other. Trying to understand why and when "Scheduled Repair" becomes mandatory. We are relatively new to operating Cassandra and progressively adopting it. Despite there are no scheduled repairs configured, few services are working quite well for months. Hence, Have few questions about repair?
- What is the statistical evidence that developer reliably look at, so he/she can understand the immediate or eventual benefit of repair processes?
- Is there any indicator (from log or metrics) that warns ahead of time about need of repair?
- If we build read-heavy (very rare transaction) reference data system, do we still need to repair regularly?
- Mistakenly if material-views used in application, should we abstain repair till we re-write applications without material-views?