How It Works

Distributed PostgreSQL on a Google Spanner Architecture – Query Layer

March 18, 2019

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

February 20, 2019

By Mikhail Bautin and Kannan Muthukkaruppan

How It Works YugabyteDB

Enhancing RocksDB for Speed & Scale

As described in our previous post “How We Built a High Performance Document Store on RocksDB?”, YugabyteDB’s distributed document store (DocDB) uses RocksDB as its per-node storage engine. We made multiple performance and data density related enhancements to RocksDB in the course of embedding it into DocDB’s document storage layer (figure below). These enhancements are distributed as part of the YugabyteDB open source project. The goal of this post is to deep dive into these enhancements for the benefit of engineering teams interested in leveraging RocksDB beyond its original design intent of a fast monolithic key-value store.

…

February 20, 2019

By Mikhail Bautin

CockroachDB Distributed SQL How It Works

How We Built a High Performance Document Store on RocksDB?

This blog post was co-authored by Mikhail Bautin and Kannan Muthukkaruppan

RocksDB is a popular embeddable persistent key-value store. First open sourced by Facebook in 2012 as a fork of the Google LevelDB project, it has been adapted over the years to a wide range of workloads including database storage engines and application data caching.

In this post, we explain our rationale for selecting RocksDB as a foundational building block for YugabyteDB.

…

Basic Introduction to YugabyteDB Components

January 30, 2019

By Ravi Murthy

How It Works

Basic Introduction to YugabyteDB Components

In this short blog post we are going to give you a quick overview of the components that make up a YugabyteDB universe.

Universe

YugabyteDB is composed of nodes. We collectively refer to this collection of all nodes as a universe. These nodes can be physical machines, virtual machines or containers (e.g. Kubernetes).

Clusters

A YugabyteDB universe is made up of one or more clusters. At a minimum it will contain a primary cluster,

…

Getting Started with YugabyteDB’s Security Features

January 15, 2019

By Jimmy Guerrero

How It Works

Getting Started with YugabyteDB’s Security Features

In this blog post we are going to give you a quick overview of YugabyteDB’s security features . We’ll cover authentication, authorization, encryption, plus a simple security checklist to help lock down your install. For the purposes of this walk-through, we are going to use the Cassandra-compatible, flexible-schema YCQL API as an example.

Authentication

First things first, authentication is not enabled by default. So, once you are through experimenting with YugabyteDB on your laptop and are ready to start development in earnest,

…

YugaByte Database Engineering Update – Nov 27, 2018

November 27, 2018

By Karthik Ranganathan

Apache Cassandra Community News How It Works How To Performance Benchmarks

YugaByte Database Engineering Update – Nov 27, 2018

Lots has happened since our last engineering update about 3 months ago. Below are some of the highlights.

PostgreSQL API Updates & PostgresConf Silicon Valley Wrap-Up

We have made a lot of progress on YSQL, the PostgreSQL compatible distributed SQL API for YugabyteDB! You can also read about YSQL architecture which covers how distributed SQL is implemented in YugabyteDB.

We were at the first ever PostgresConf Silicon Valley in October 2018.

…

Data Modeling Basics – PostgreSQL vs. Cassandra vs. MongoDB

November 21, 2018

By Sid Choudhury

Apache Cassandra Databases How It Works MongoDB PostgreSQL

Data Modeling Basics – PostgreSQL vs. Cassandra vs. MongoDB

This post aims to help application developers understand the choice of SQL vs. NoSQL in the context of the data modeling needs of an application.

Distributed Backups in Multi-Region YugabyteDB Clusters

November 19, 2018

By Alan Caldera

How It Works How To Performance Benchmarks YugabyteDB

Distributed Backups in Multi-Region YugabyteDB Clusters

Our post Getting Started with Distributed Backups in YugabyteDB details the core architecture powering distributed backups in YugabyteDB. It also highlights a few backup/restore operations in a single region, multi-AZ cluster. In this post, we perform distributed backups in a multi-region YugabyteDB cluster and verify that we achieve performance characteristics similar to those observed in a single region cluster.

We configured a 9 node cluster with 3 availability zones across 2 regions and repeated the benchmark introduced in the post.

…

Getting Started with Distributed Backups in YugabyteDB

November 19, 2018

By Kannan Muthukkaruppan

How It Works How To Performance Benchmarks YugabyteDB

Getting Started with Distributed Backups in YugabyteDB

YugabyteDB is a distributed database with a Google Spanner-inspired strongly consistent replication architecture that is purpose-built for high availability and high performance. This architecture allows administrators to place replicas in independent fault domains, which can be either availability zones or racks in a single region or different regions altogether. These types of multi-AZ or multi-region deployments have the immediate advantage of guaranteeing organizations a higher order of resilience in the event of a zone or region failure.

…

How It Works

YSQL, Distributed PostgreSQL Made Real

Universe

Clusters

Authentication

PostgreSQL API Updates & PostgresConf Silicon Valley Wrap-Up

Explore Distributed SQL and YugabyteDB in Depth