YugaByte DB

The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Distributed SQL How It Works How To PostgreSQL
December 2, 2019
by Bryn Llewellyn

Using Stored Procedures in Distributed SQL Databases

These days, most monolithic SQL databases support stored procedures. This support first emerged in commercially available offerings in the late nineteen eighties. However, stored procedure support is not yet standard in distributed SQL databases. In fact, YugabyteDB is just one of two in this category—supporting stored procedures written in PostgreSQL’s PL/pgSQL. (Aurora also supports stored procedures.) This post recaps the case for stored procedures that motivated their introduction all those years ago.

…

Read More
Community News Distributed SQL PostgreSQL YugabyteDB 2.0
November 27, 2019
by Jimmy Guerrero

YugabyteDB Engineering Update – Nov 27, 2019

We are pleased to announce that YugabyteDB 2.0.6 is live!  You can read the official release notes of this and previous versions here. This release is shipping with almost 30 new enhancements and bug fixes.

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

…

Read More
Databases Distributed SQL How It Works PostgreSQL
November 26, 2019
by Karthik Ranganathan

How Plume Handled Billions of Operations Per Day Despite an AWS Zone Outage

Enterprises deploy YugabyteDB clusters across multiple availability zones (AZs) in order to ensure continuous availability of their business-critical services even when faced with cloud infrastructure failures like zone outages. On November 12, 2019, there was one such outage of an entire availability zone in the eu-central-1 region of AWS. This was reported on the AWS status page on that day,

…

Read More
Amazon Aurora CockroachDB Databases Distributed SQL Google Spanner How It Works PostgreSQL
November 25, 2019
by Sid Choudhury

What is Distributed SQL?

SQL has been the de-facto language for relational databases (aka RDBMS) for almost four decades. Relational databases are therefore also known as SQL databases. However, the original SQL databases like Oracle, PostgreSQL, and MySQL are monolithic from an architectural standpoint. They are unable to distribute data and queries across multiple instances automatically. NewSQL databases emerged to make SQL scalable. However,

…

Read More
Community News Distributed SQL PostgreSQL YugabyteDB 2.0
November 20, 2019
by Jimmy Guerrero

YugabyteDB Engineering Update – Nov 20, 2019

We are pleased to announce that YugabyteDB 2.0.5 is live!  You can read the offical release notes of this and previous versions here. This release is shipping with over 40 new enhancements and bug fixes.

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

…

Read More
Community News Distributed SQL Ecosystem Integrations How To Kubernetes Open Source
November 18, 2019
by Sid Choudhury

Announcing YugabyteDB on Crossplane, the Open Source Multicloud Control Plane

We are excited to announce that YugabyteDB is now available as a self-managed database service on Crossplane, the open-source multicloud control plane. Built on top of our recent Rook Kubernetes Operator for YugabyteDB, this offering makes YugabyteDB one of the first distributed SQL databases available on Crossplane.

Benefits of the Joint Solution

With Crossplane as the single control plane,

…

Read More
Community News Distributed SQL PostgreSQL YugabyteDB 2.0
October 30, 2019
by Jimmy Guerrero

YugabyteDB Engineering Update – Oct 30, 2019

We are pleased to announce that YugabyteDB 2.0.3 is live! You can read the release notes of this and previous versions here. This release is shipping with 50 new enhancements and bug fixes.

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

…

Read More
Distributed SQL How It Works
October 29, 2019
by Bryn Llewellyn

The Benefit of Partial Indexes in Distributed SQL Databases

If a partial index is used, instead of a regular one, on a nullable column—where only a small fraction of the rows have not null values for this column—then the response time for inserts, updates, and deletes can be shortened significantly. As a bonus, the response times for single row selects shorten a little bit too. This post explains what a partial index is,

…

Read More