Prev Next

Database / Apache Cassandra Intermediate and Advanced interview questions

What is the difference between full repair and incremental repair?

Both are forms of anti-entropy repair, but they differ in how much data gets re-validated each time nodetool repair runs.

Full RepairIncremental Repair
Recomputes Merkle trees over all SSTables every run.Only compares SSTables not already marked repaired.
Slower and more I/O intensive as data grows.Faster on subsequent runs since repaired data is skipped.
Simpler mental model, fewer edge cases.Historically prone to anti-compaction bugs on older versions.

Incremental repair marks SSTables as "repaired" after a successful run, splitting them from "unrepaired" data via anti-compaction, so future repairs only need to examine the unrepaired set. This makes it far cheaper at scale, which is why it became the recommended default in modern Cassandra versions, though many operators historically preferred full repair on Cassandra 2.x/3.0 due to early incremental-repair stability issues that have since been resolved in later releases.

What does incremental repair skip on subsequent runs?
What operation splits repaired data from unrepaired data in incremental repair?

Invest now in Acorns!!! 🚀 Join Acorns and get your $5 bonus!
Acorns Logo

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Earn passively and while sleeping

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Robinhood Logo

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.


Webull Logo

Webull! Receive free stock by signing up using the link: Webull signup.

More Related questions...

What is the difference between a partition key and a clustering key? How does Cassandra achieve tunable consistency? What is the difference between consistency levels ONE, QUORUM, and ALL? Explain the write path in Cassandra? Explain the read path in Cassandra? What is the role of a coordinator node in Cassandra? What is the gossip protocol in Cassandra? How does Cassandra detect node failure? What are virtual nodes (vnodes) and why does Cassandra use them? What is consistent hashing and how does Cassandra use it? What is a partitioner in Cassandra? What is a snitch in Cassandra and what does it do? What is the difference between SimpleStrategy and NetworkTopologyStrategy? What is hinted handoff in Cassandra? What is read repair in Cassandra? What is the difference between hinted handoff and read repair? What is anti-entropy repair and why is it needed? What is the difference between full repair and incremental repair? What are tombstones in Cassandra? Why can excessive tombstones degrade Cassandra performance? What is gc_grace_seconds and why does it matter? What are the different compaction strategies available in Cassandra? When would you choose Leveled Compaction Strategy over Size-Tiered Compaction Strategy? What is Time Window Compaction Strategy used for? What are lightweight transactions (LWT) in Cassandra? Why are lightweight transactions expensive in Cassandra? What role does the Paxos protocol play in Cassandra's lightweight transactions? What are secondary indexes in Cassandra, and when should you avoid them? What is a materialized view in Cassandra? What is the difference between a secondary index and a materialized view? What is SASI (SSTable Attached Secondary Index) in Cassandra? What are User Defined Types (UDTs) in Cassandra? What are counter columns in Cassandra and what are their limitations? What is a wide partition in Cassandra and why is it a problem? How do you model time-series data in Cassandra? What is the ALLOW FILTERING clause and why is it risky? What is a batch statement in Cassandra, and what's the difference between logged and unlogged batches? Why shouldn't Cassandra batches be used to improve write throughput? What is Change Data Capture (CDC) in Cassandra? What is speculative retry in Cassandra? What is token awareness in Cassandra drivers? What is the role of Merkle trees in Cassandra's repair process? How do you add a new node to a Cassandra cluster? What is nodetool cleanup used for? How do you handle consistency across multiple datacenters in Cassandra?
Show more question and Answers...

Integration

Comments & Discussions