In this blog post, we will discuss how to maintain transactional read guarantees on an async standby configured through cross cluster replication. This feature has bearing on any user who runs a transactional application in a distributed setup. We think that may apply to many people reading this blog.
In this post, we comparethe high availability and transactions architecture of PostgreSQL and MongoDB to that of YugabyteDB.
MongoDB’s “schemaless” JSON data modeling was initially attractive to web app developers looking to escape the constraints of traditional relational databases, but issues with data durability and ACID transactions have been a consistent challenge. While the recent MongoDB 4.0 release includes multi-document transaction support, this post explores where the platform falls short for transactional, high performance apps.
In this blog, we dive deeper into Percolator and Spanner as well as the open source databases (YugabyteDB for example) that they have inspired
ACID transactions are a fundamental building block when developing business-critical, user-facing applications. They simplify the complex task of ensuring data integrity while supporting highly concurrent operations. While they are taken for granted in monolithic SQL/relational databases, distributed NoSQL/non-relational databases either forsake them completely or support only a highly restrictive single-row flavor (see sections below). This loss of ACID properties is usually justified with a gain in performance (measured in terms of low latency and/or high throughput).
…
