Databases

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’ll dive into the architecture of the distributed storage layer of YugabyteDB, which is inspired by Google Spanner’s design. Our subsequent post covers the Query Layer, where the storage layer meets PostgreSQL as the SQL API. Finally, here is a follow-up post that highlights the key technical challenges we faced while engineering a distributed SQL database like YugabyteDB.

Logical Architecture

YugabyteDB is comprised of two logical layers,

…

Announcing YugabyteDB 1.2 and Company Update

March 13, 2019

By Kannan Muthukkaruppan

CockroachDB Community News Company News Distributed SQL Jepsen Tests Kubernetes Performance Benchmarks YugabyteDB

Announcing YugabyteDB 1.2 and Company Update

The team at YugaByte is excited to announce that YugabyteDB 1.2 is officially GA! You can download the latest version from our Quick Start page.

New in 1.2: YugaByte SQL Beta 3

YugaByte SQL (YSQL) is our PostgreSQL v11 compatible, distributed SQL API. It is ideal for powering microservices that require low latency, internet scale, geographic data distribution and extreme resilience to failures but want the data modeling flexibility of SQL (joins,

…

YugabyteDB High Availability and Transactions for PostgreSQL and MongoDB Developers

March 5, 2019

By Sid Choudhury

Compare and contrast MongoDB PostgreSQL YugabyteDB

YugabyteDB High Availability and Transactions for PostgreSQL and MongoDB Developers

In this post, we comparethe high availability and transactions architecture of PostgreSQL and MongoDB to that of YugabyteDB.

Navigating Database Concepts: Mapping YugabyteDB to PostgreSQL and MongoDB

February 28, 2019

By Sid Choudhury

Compare and contrast MongoDB PostgreSQL YugabyteDB

Navigating Database Concepts: Mapping YugabyteDB to PostgreSQL and MongoDB

In this post, we reviewed the building blocks of the YugabyteDB and mapped them to the corresponding concepts (if any) in PostgreSQL and MongoDB.

How We Built a High Performance Document Store on RocksDB?

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.

…

7 Issues to Consider When Evaluating FoundationDB

January 31, 2019

By Sid Choudhury

ACID Transactions Compare and contrast Databases Distributed SQL YugabyteDB

7 Issues to Consider When Evaluating FoundationDB

FoundationDB enjoys a unique spot in the transactional NoSQL space given its positioning as a basic key-value database that can be used to build new, more application-friendly databases. Given that many of the guarantees provided by its core engine (such as multi-shard ACID transactions and high fault tolerance) are similar to those provided by the YugabyteDB database, our users often ask us for a comparison. These users are essentially trying to understand whether they should build their app directly using one of the three YugabyteDB APIs or should they explore/build a new database layer on FoundationDB first.

…

YugabyteDB vs CockroachDB Performance Benchmarks for Internet-Scale Transactional Workloads

January 24, 2019

By Karthik Ranganathan

CockroachDB Distributed SQL Performance Benchmarks

YugabyteDB vs CockroachDB Performance Benchmarks for Internet-Scale Transactional Workloads

Enterprises building cloud native services are gravitating towards transactional NoSQL and globally distributed SQL databases as their next-generation transactional stores. There are at least two distinct usage patterns among these cloud native services – internet-scale transactional workloads and scale-out RDBMS workloads. They have a lot of common demands from the database they use, such as transactions/strong consistency, data modeling flexibility, ease of scaling out and fault tolerance. However, there are some notable differences between these workloads:

Internet-scale transactional workloads are optimized for scale and performance without any compromises to data correctness.

…

How to Migrate Data from Cassandra or MySQL to YugabyteDB?

January 23, 2019

By Jimmy Guerrero

Apache Cassandra Database Migration How To

How to Migrate Data from Cassandra or MySQL to YugabyteDB?

If you work with databases, at some point you are going to need to get data in and out them using a format that can be consumed by a completely different system. YugabyteDB makes use of CSV files to make this as easy as possible. The CSV format is arguably the most universally portable way to get data migrations accomplished.

TL;DR – YugabyteDB makes use of Cassandra’s COPY FROM command and a forked version of Cassandra’s Bulk Loader to get data into the system.

…

Rise of Globally Distributed SQL Databases – Redefining Transactional Stores for Cloud Native Era

January 16, 2019

By Sid Choudhury

ACID Transactions Amazon Aurora CockroachDB Distributed SQL Docker Google Spanner Kubernetes PostgreSQL

Rise of Globally Distributed SQL Databases – Redefining Transactional Stores for Cloud Native Era

At last month’s KubeCon + CloudNativeCon in Seattle, the single biggest change from previous container-related conferences was the excitement among the end user companies around their adoption of Kubernetes and the associated cloud native infrastructure ecosystem. The CNCF End User Community page today lists 50+ enterprises and 21+ case studies including those from industry bellwethers such as Capital One, Netflix, Nordstrom and Pinterest. There is a common adoption pattern among all these case studies —

…

Databases

YSQL, Distributed PostgreSQL Made Real

Logical Architecture

New in 1.2: YugaByte SQL Beta 3

Explore Distributed SQL and YugabyteDB in Depth