ACID TransactionsAmazon Web ServicesDistributed SQLGoogle Cloud PlatformGoogle SpannerMicrosoft AzureMicrosoft Azure Cosmos DB
Practical Tradeoffs in Google Cloud Spanner, Azure Cosmos DB and YugabyteDB
Updated April 2019.
The famed CAP Theorem has been a source of much debate among distributed systems engineers. Those of us building distributed databases are often asked how we deal with it. In this post, we dive deeper into the consistency-availability tradeoff imposed by CAP which is only applicable during failure conditions. We also highlight the lesser-known-but-equally-important consistency-latency tradeoff imposed by the PACELC Theorem that extends CAP to normal operations.