The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

Presentation Recap: The Distributed Database Behind Twitter

Twitter is one of the world’s favorite places for people and brands to connect online. Powering a global service that helps people share everything from breaking news and entertainment to sports, politics, and everyday interests takes infrastructure that can adapt and evolve over time.

In his talk at the 2020 Distributed SQL Summit, Mehrdad Nurolahzade,

Read More

Presentation Recap: Kubernetes as a Universal Control Plane – Joe Beda, VMware

We were delighted to have Joe Beda, one of the original creators of Kubernetes, and Principal Engineer at VMware, give the opening keynote at this year’s 2020 Distributed SQL Summit. If you weren’t able to attend, here’s the summary and playback of his keynote presentation.

Kubernetes as a Universal Control Plane

Oftentimes systems start out with efficiency in mind (as Joe states,

Read More

Yugabyte Adopts a New Versioning System

Many users in the YugabyteDB community simply love the velocity with which new and exciting features are introduced through frequent releases. However, as more and more business-critical applications start depending on YugabyteDB as the system of record database, there is an increasing need for enterprises to operate existing versions in production longer and avoid adopting fast-moving releases which can go through radical design changes.

Read More

Introducing yugabyted, the Simplest Way to Get Started with YugabyteDB

Users familiar with YugabyteDB’s architecture know that it is based on two servers where cluster metadata storage and administrative operations are managed by a YB-Master metadata server that is independent from the YB-TServer database server. The end result is that the YB-Master server can be configured and tuned (in a manner that is completely isolated from YB-TServer) to achieve higher performance and faster resilience than a single-server architecture.

Read More

TPC-C Benchmark: 10,000 Warehouses on YugabyteDB

We are excited to announce that the TPC-C benchmark implementation for YugabyteDB is now open source and ready to use! While this implementation is not officially ratified by the TPC organization, it closely follows the TPC-C v5.11.0 specification.

For those new to TPC-C, the aim of the benchmark is to test how a database performs when handling transactions generated by a real-world OLTP application.

Read More

Polymorphism in SQL part one – anyelement and anyarray

The term “polymorphism”, and its inflections, has various meanings in the context of programming languages in general. Roughly, it means “chameleon-like”. Of course, Wikipedia has something to say about it, here. PostgreSQL uses it with this meaning: “Parametric polymorphism: when one or more types are not specified by name but by… symbols that can represent any type”.

Read More

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables

Editor’s note – This post was updated July 2020 with new release information

An Introduction to Colocated Tables

In YugabyteDB v2.1, we released a new feature in beta: colocated tables. And we were excited to announce the general availability of colocated tables, along with many other exciting new features,

Read More

Why We Built YugabyteDB by Reusing the PostgreSQL Query Layer

Reusing PostgreSQL’s native query layer instead of writing a new PostgresQL-compatible query layer ground up has been one of the best design decisions we have made in YugabyteDB. As outlined in the challenges we faced building a distributed SQL database, we have battle scars to prove this insight – we started writing a PostgreSQL-compatible query layer from scratch before realizing that we simply cannot build the world’s best cloud native RDBMS in a timely manner if we persist down this path.

Read More