Blogs by: Karthik Ranganathan

The Effect of Isolation Levels on Distributed SQL Performance Benchmarking

September 24, 2019

Amazon Aurora Amazon Web Services CockroachDB Distributed SQL Performance Benchmarks PostgreSQL YugabyteDB

The Effect of Isolation Levels on Distributed SQL Performance Benchmarking

This post addresses a concern raised about a benchmarking result we recently published comparing the performance of YugabyteDB, Amazon Aurora and CockroachDB. It was pointed out that we unfairly used the default isolation level for each database rather than use serializable isolation level in all databases (even though serializable level was not required for these workloads). In addition, we are also happy to share additional results with the workloads run at YugabyteDB’s serializable isolation level.

…

YugabyteDB vs CockroachDB vs. Amazon Aurora: Comparing PostgreSQL-Compatible Database Performance

September 17, 2019

By Karthik Ranganathan

Amazon Aurora CockroachDB Compare and contrast

YugabyteDB vs CockroachDB vs. Amazon Aurora: Comparing PostgreSQL-Compatible Database Performance

One of the flagship features of the Yugabyte distributed SQL database is the PostgreSQL-compatible YSQL API. Let’s take a look at the performance and scalability of YSQL and compare it to two other PostgreSQL-compatible databases—Amazon Aurora PostgreSQL and CockroachDB.

YugabyteDB’s Distributed SQL API Jepsen Test Results

September 4, 2019

By Karthik Ranganathan

Performance Benchmarks

YugabyteDB’s Distributed SQL API Jepsen Test Results

YugabyteDB v1.3.1.2’s SQL API successfully passed Jepsen testing, led by Kyle Kingsbury, except for transactional DDL support—a feature we’ll soon add. YSQL will be production-ready in the upcoming YugabyteDB v2.0 release.

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

August 20, 2019

By Karthik Ranganathan

ACID Transactions Distributed SQL How It Works

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. Additionally, we will also look at how to make the correctness guarantees around leader leases stronger.

…

Why We Changed YugabyteDB Licensing to 100% Open Source

July 16, 2019

By Karthik Ranganathan

Community News Company News Distributed SQL Open Source YugabyteDB

Why We Changed YugabyteDB Licensing to 100% Open Source

We are excited to announce that YugabyteDB is now 100% open source under the Apache 2.0 license. This means previously closed-source, commercial, enterprise features such as Distributed Backups, Data Encryption, and Read Replicas are now available in the open source project and are completely free to use. The same applies to upcoming new features like Change Data Capture and 2 Data Center Deployments. The result of this change is that we no longer have a Community Edition and an Enterprise Edition of YugabyteDB.

…

6 Technical Challenges Developing a Distributed SQL Database

April 26, 2019

By Karthik Ranganathan

Amazon Aurora Distributed SQL Google Spanner How It Works Jepsen Tests

6 Technical Challenges Developing a Distributed SQL Database

You can join the discussion on HackerNews here.

We crossed the three year mark of developing the YugabyteDB database in February of 2019. It has been a thrilling journey thus far, but not without its fair share of technical challenges. There were times when we had to go back to the drawing board and even sift through academic research to find a better solution than what we had at hand.

…

March 26, 2019

By Karthik Ranganathan

ACID Transactions YugabyteDB

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.

…

Distributed PostgreSQL on a Google Spanner Architecture – Query Layer

March 18, 2019

By Karthik Ranganathan

Distributed SQL Google Spanner How It Works PostgreSQL YugabyteDB

Distributed PostgreSQL on a Google Spanner Architecture – Query Layer

Our previous post dived into the details of the storage layer of YugabyteDB called DocDB, a distributed document store inspired by Google Spanner. This post focuses on Yugabyte SQL (YSQL), a distributed, highly resilient, PostgreSQL-compatible SQL API layer powered by DocDB. A follow-up post will highlight the challenges faced and lessons learned when engineering such a database.

YSQL, Distributed PostgreSQL Made Real

Yugabyte SQL (YSQL) is a distributed and highly resilient SQL layer,

…

Distributed PostgreSQL on a Google Spanner Architecture – Storage Layer

March 18, 2019

By Karthik Ranganathan

Distributed SQL Google Spanner How It Works PostgreSQL YugabyteDB

Distributed PostgreSQL on a Google Spanner Architecture – Storage Layer

In this post, we dive into the architecture of the distributed storage layer of YugabyteDB, which is inspired by Google Spanner’s design

YugabyteDB vs CockroachDB Performance Benchmarks for Internet-Scale Transactional Workloads

January 24, 2019

By Karthik Ranganathan

CockroachDB Compare and contrast

YugabyteDB vs CockroachDB Performance Benchmarks for Internet-Scale Transactional Workloads

This benchmarking blog comparing YugabyteDB vs CockroachDB highlights key differences in handling distributed SQL workloads, emphasizing performance and feature advantages.

Blogs by: Karthik Ranganathan

YSQL, Distributed PostgreSQL Made Real

Explore Distributed SQL and YugabyteDB in Depth