midCAP Theorem
Can we switch between CP and AP dynamically?
Updated Apr 28, 2026
Short answer
Some modern databases (like Cosmos DB) allow tuning consistency levels per request/session.
Deep explanation
Intermediate CAP analysis focuses on real-world database choices and consistency models. Some modern databases (like Cosmos DB) allow tuning consistency levels per request/session.
Real-world example
Amazon DynamoDB using eventual consistency to ensure high availability for the 'Add to Cart' feature.
Common mistakes
- Assuming a CP system is always consistent
- it is only consistent as long as the majority (quorum) is alive.
Follow-up questions
- What is the L in PACELC?