The Distributed SQL Blog

October 1, 2019

Recapping My Internship at Yugabyte – Jayden Navarro

It was a warm day in early October, and two large white tents occupied the lawn that sits between the Gates, Hewlett, and Packard buildings. Companies pasted the word “AI” in big bold letters across their banners, and students formed long lines, resumes in-hand, eager to learn about the Next Big Thing and how often the company cafeteria serves Poké.

Six months prior I had made the decision to leave my comfortable job as a Software Engineer in the networking industry and pursue a Masters degree in Computer Science at Stanford,

…

Getting Started with PostgreSQL Triggers in a Distributed SQL Database

September 24, 2019

By Jimmy Guerrero

Distributed SQL How It Works How To PostgreSQL

Getting Started with PostgreSQL Triggers in a Distributed SQL Database

Triggers are a basic feature that all monolithic SQL systems like Oracle, SQL Server and PostgreSQL have supported for many years. They are very useful in a variety of scenarios ranging from simple audit logging, to advanced tasks like updating remote databases in a federated cluster. In this blog, we’ll look at examples of INSERT, UPDATE and INSTEAD OF triggers in Yugabyte DB.

What’s Yugabyte DB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner.

…

The Effect of Isolation Levels on Distributed SQL Performance Benchmarking

September 24, 2019

By Karthik Ranganathan

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.

…

Announcing YugabyteDB 2.0 GA: Jepsen Tested, High-Performance Distributed SQL

September 17, 2019

By Kannan Muthukkaruppan

Community News Company News Distributed SQL YugabyteDB

Announcing YugabyteDB 2.0 GA: Jepsen Tested, High-Performance Distributed SQL

We are excited to announce the general availability of YugabyteDB 2.0! The highlight of this release is that it delivers production readiness for Yugabyte SQL (YSQL), our high-performance, fully-relational distributed SQL API. For those of you new to distributed SQL, YugabyteDB is a Google Spanner-inspired, cloud-native distributed SQL database that is 100% open source. It puts a premium on high performance, data resilience, geographic distribution while ensuring PostgreSQL compatibility.

…

Comparing Distributed SQL Performance – YugabyteDB vs. Amazon Aurora PostgreSQL vs. CockroachDB

September 17, 2019

By Karthik Ranganathan

Amazon Aurora Amazon Web Services CockroachDB Distributed SQL Performance Benchmarks YugabyteDB

Comparing Distributed SQL Performance – YugabyteDB vs. Amazon Aurora PostgreSQL vs. CockroachDB

Update: A new post “The Effect of Isolation Levels on Distributed SQL Performance Benchmarking” includes performance results from running these workloads at serializable isolation level in YugabyteDB.

We are 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 YugabyteDB SQL (YSQL) API. In this blog post, we will look at the performance and scalability of YSQL as compared to two other PostgreSQL-compatible distributed SQL databases –

…

PostgreSQL Compatibility in YugabyteDB 2.0

September 17, 2019

By Jimmy Guerrero

ACID Transactions CockroachDB Distributed SQL How It Works PostgreSQL YugabyteDB

PostgreSQL Compatibility in YugabyteDB 2.0

YugabyteDB 2.0 is now generally available, featuring the production readiness of the PostgreSQL compatible Yugabyte SQL API (YSQL). In addition to Jepsen testing results, new performance benchmarks, and ecosystem integrations, YugabyteDB 2.0 offers a high degree of PostgreSQL compatibility, with plans for future support.

Zero-Downtime Migrations from Oracle to a Cloud-Native PostgreSQL

September 17, 2019

By Rajkumar Sen

Database Migration Distributed SQL PostgreSQL YugabyteDB

Zero-Downtime Migrations from Oracle to a Cloud-Native PostgreSQL

Today, we are proud to announce that Blitzz and

…

Announcing the Rook Operator for YugabyteDB

September 12, 2019

By Andrew Nelson

How To Kubernetes YugabyteDB

Announcing the Rook Operator for YugabyteDB

We are excited to congratulate the Rook community on the release on 1.1! We are also pleased to announce that the Rook operator for YugabyteDB is now available from rook.io and also on Github. This release extends the Rook storage operator as a custom resource, as well as provides an additional way to easily create, natively view and manage YugabyteDB within a Kubernetes cluster. In this blog we’ll summarize how to get started with the operator.

…

Best Practices and Recommendations for Distributed SQL on Kubernetes

September 11, 2019

By Andrew Nelson

How It Works How To Kubernetes

Best Practices and Recommendations for Distributed SQL on Kubernetes

YugabyteDB and Kubernetes have very complementary design principles because they both rely on an extensible and flexible API layer, as well as a scale-out architecture for performance and availability. In this blog post we’ll look at best practices and recommendations when choosing Kubernetes as the cluster foundation for a distributed SQL system. This will begin with a review of relevant architectural decisions of the YugabyteDB. Then we’ll walk you through how to handle the provisioning,

…

YugabyteDB’s Distributed SQL API Jepsen Test Results

September 4, 2019

By Karthik Ranganathan

Distributed SQL How It Works Jepsen Tests YugabyteDB

YugabyteDB’s Distributed SQL API Jepsen Test Results

Note: You can join the discussion on Hacker News here.

We are very excited to announce that the SQL API of YugabyteDB v1.3.1.2 passed Jepsen testing performed by Kyle Kingsbury [Edit] (with the exception of transactional DDL support, which almost no other distributed SQL database vendor supports, and we plan to support soon. The real-world impact of this open issue is minor as it is limited to cases where DML happens before DDL has fully completed).

…

The Distributed SQL Blog

Learn More to Accelerate Your Retail Business