Course contentsShow
← System Design
Lesson 563 of 1,91915. Consistency ModelsFree lesson

Tunable Consistency in Practice

How systems like Cassandra and DynamoDB let users configure consistency levels per-query for different use cases.

Tunable Consistency in Practice

You'll learn: How real-world distributed databases let you dial consistency up or down per-query, matching business requirements to performance needs.

The Core Idea

Tunable consistency means you don't choose one consistency level for your entire database—you choose it per operation. Systems like Apache Cassandra and Amazon DynamoDB let you specify how many replicas must acknowledge a read or write for each query, giving you flexibility to optimize different use cases within the same application.

Remember from earlier lessons that you configure N (total replicas), R (read quorum), and W (write quorum). Tunable consistency lets you adjust R and W on every request.

Why This Matters

Not all data requires the same guarantees:

  • User profile updates: Strong consistency (W=ALL, R=ONE) ensures no stale reads after writes
  • News feed generation: Eventual consistency (W=ONE, R=ONE) prioritizes speed over freshness
  • Account balance checks: Quorum reads (R=QUORUM) balance consistency and availability

By tuning per-query, you avoid forcing expensive strong consistency on operations that don't need it.

How It Works in Practice

In Cassandra, you specify consistency level in your query:

SELECT * FROM users WHERE id=123 
WITH CONSISTENCY LEVEL QUORUM

In DynamoDB, you set ConsistentRead=true for strong reads or false for eventual reads.

This means your shopping cart read can be fast and eventually consistent, while your checkout payment write demands strong consistency—in the same database, same application.

The Trade-off Table

Use CaseTypical SettingReason
Profile updatesW=QUORUM, R=QUORUMBalance consistency & availability
Analytics queriesR=ONESpeed over freshness
Financial transactionsW=ALL, R=QUORUMCannot miss any write

Key Takeaway: Tunable consistency lets you optimize each operation independently—pay the consistency cost only where business logic demands it, keeping other operations fast.