ACID Transactions Archives - The Distributed SQL Blog

ACID Transactions Amazon Aurora Amazon DynamoDB CockroachDB Distributed SQL Google Spanner How It Works PostgreSQL

October 17, 2019

9 Techniques to Build Cloud-Native, Geo-Distributed SQL Apps with Low Latency

This post is an in-depth look at the various techniques that applications needing low latency and high availability can leverage while using a geo-distributed SQL database like YugabyteDB so that the negative impacts of an high-latency, unreliable Wide Area Network (WAN) are minimized.

Geo-Distributed SQL is the Future of RDBMS

Enterprises are increasingly moving to cloud-native applications powered by microservices architecture.

…

ACID Transactions CockroachDB Distributed SQL How It Works PostgreSQL YugabyteDB 2.0

September 17, 2019

by Jimmy Guerrero

PostgreSQL Compatibility in YugabyteDB 2.0

The team at Yugabyte and members of the community were excited to announce the general availability of YugabyteDB 2.0 this week. One of the flagship features of the release was the production readiness of the PostgreSQL compatible, Yugabyte SQL API (YSQL). In other blogs we covered Jepsen testing results, new performance benchmarks and ecosystem integrations including the GraphQL projects Hasura and Prisma.

…

ACID Transactions Distributed SQL How It Works

August 20, 2019

by Karthik Ranganathan

Low Latency Reads in Geo-Distributed SQL with Raft Leader Leases

Note: This post contains interactive animations that explain how some of these complex algorithms work. Please view this post in a suitable media (at least 1000px by 600px screen resolution) for best results.

In this blog post, we are going to dive deep into the read performance of Raft – why read performance can take a hit and how it can be improved using leader leases.

…

ACID Transactions Community News Company News Distributed SQL How It Works Jepsen Tests YugabyteDB 1.2

March 26, 2019

by Karthik Ranganathan

YugabyteDB 1.2 Passes Jepsen Testing

You can join the discussion about the results on HackerNews here.

Last year we published our DIY Jepsen testing results – including the tests and failure modes implemented as well as the bugs found. We recently engaged Kyle Kingsbury, the creator of the Jepsen test suite, for an official analysis and are happy to report that YugabyteDB 1.2 formally passes Jepsen tests using the YCQL API.

…

ACID Transactions Distributed SQL How It Works MongoDB PostgreSQL

March 5, 2019

by Sid Choudhury

YugaByte DB High Availability & Transactions for PostgreSQL & MongoDB Developers

In the first post of our series comparing YugaByte DB with PostgreSQL and MongoDB, we mapped the core concepts in YugaByte DB to the two popular databases. This post is a deeper dive into the high availability and transactions architecture of these databases.

High Availability

Almost all databases including YugaByte DB use replication to ensure that the database remains highly available under failures.

…

ACID Transactions Databases Distributed SQL Kubernetes

January 31, 2019

by Sid Choudhury

7 Issues to Consider When Evaluating FoundationDB

FoundationDB enjoys a unique spot in the transactional NoSQL space given its positioning as a basic key-value database that can be used to build new, more application-friendly databases. Given that many of the guarantees provided by its core engine (such as multi-shard ACID transactions and high fault tolerance) are similar to those provided by YugaByte DB, our users often ask us for a comparison.

…

ACID Transactions Amazon Aurora CockroachDB Distributed SQL Docker Google Spanner Kubernetes PostgreSQL

January 16, 2019

by Sid Choudhury

Rise of Globally Distributed SQL Databases – Redefining Transactional Stores for Cloud Native Era

At last month’s KubeCon + CloudNativeCon in Seattle, the single biggest change from previous container-related conferences was the excitement among the end user companies around their adoption of Kubernetes and the associated cloud native infrastructure ecosystem. The CNCF End User Community page today lists 50+ enterprises and 21+ case studies including those from industry bellwethers such as Capital One,

…

ACID Transactions Amazon DynamoDB Microsoft Azure Cosmos DB MongoDB

December 17, 2018

by Sid Choudhury

Why are NoSQL Databases Becoming Transactional?

The NoSQL database revolution started with the publication of the Google BigTable and Amazon Dynamo papers in 2006 and 2007 respectively. These original designs focused on horizontal write scalability without compromising the performance observed in the single node databases dominant at that time. The compromises instead came either in the form of eventual consistency (i.e. inability to read the last update) or loss of multi-key access patterns (such as SQL integrity/foreign key constraints,

…

ACID Transactions Community News Company News Distributed SQL Kubernetes PostgreSQL

December 10, 2018

by Kannan Muthukkaruppan

YugaByte Announces Kubernetes StatefulSets Support to Enable Scale-Out PostgreSQL Deployments

YugaByte is excited to be at KubeCon today to announce Kubernetes StatefulSets support for our distributed SQL API which complements the transactional NoSQL APIs already generally available. YSQL is YugaByte DB’s PostgreSQL-compatible Distributed SQL API (currently in Beta). This new feature, available in YugaByte DB 1.1.7, cloud-native applications and microservices can rely on SQL and NoSQL to take full advantage of Kubernetes StatefulSets to power horizontally scalable,

…

ACID Transactions MongoDB YugabyteDB 1.1

November 1, 2018

by Sid Choudhury

Are MongoDB’s ACID Transactions Ready for High Performance Applications?

Web app developers initially adopted MongoDB for its ability to model data as “schemaless” JSON documents. This was a welcome relief to many who were previously bitten by the rigid structure and schema constraints of relational databases. However, two critical concerns that have been a thorn on MongoDB’s side over the years are that of data durability and ACID transactions.

…