The Distributed SQL Blog

How We Built a High Performance Document Store on RocksDB?

February 20, 2019

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.

…

How to Monitor YugabyteDB with Prometheus on Docker?

February 12, 2019

By Sid Choudhury

Docker How To Kubernetes

How to Monitor YugabyteDB with Prometheus on Docker?

Observability is absolutely vital to operating business-critical data infrastructure at scale. This is why observability is not an afterthought in the YugabyteDB architecture. Every layer of YugabyteDB exposes metrics in the Prometheus format at the /prometheus-metrics endpoint. Given that Prometheus is essentially the de-facto standard for build-your-own infrastructure monitoring and alerting, you can get started with monitoring YugabyteDB in almost no time.

This post details how to install and configure both YugabyteDB and Prometheus on Docker so that you can run simple queries on the Prometheus UI.

…

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.

…

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,

…

YugabyteDB vs CockroachDB Performance Benchmarks for Internet-Scale Transactional Workloads

January 24, 2019

By Karthik Ranganathan

CockroachDB Compare and contrast

YugabyteDB vs CockroachDB Performance Benchmarks for Internet-Scale Transactional Workloads

This benchmarking blog comparing YugabyteDB vs CockroachDB highlights key differences in handling distributed SQL workloads, emphasizing performance and feature advantages.

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 —

…

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,

…

Recapping YugaByte’s 2018 Milestones and a Preview of the 2019 Roadmap

January 8, 2019

By Sid Choudhury

Community News Company News Distributed SQL

Recapping YugaByte’s 2018 Milestones and a Preview of the 2019 Roadmap

After launching YugabyteDB in November 2017, Team YugaByte celebrated 2018 as its first full year in the market as a cloud native, transactional database company. Exhilarating is the one word that best summarizes our 2018 experience. From a product and engineering standpoint, we launched two major releases (and tens of minor releases) and saw users adopt each of the releases at an amazing pace. This story of exceeded expectations repeated itself at every other function in the company whether it be sales,

…

Why are NoSQL Databases Becoming Transactional?

December 17, 2018

By Sid Choudhury

ACID Transactions Amazon DynamoDB Distributed SQL Microsoft Azure Cosmos DB MongoDB

Why are NoSQL Databases Becoming Transactional?

The SQL vs. NoSQL database split emerged in 2006-2007, but NoSQL’s compromises led developers to continue using SQL/RDBMS for critical workloads. However, recent changes in the NoSQL world have seen the adoption of ACID transactions, which were previously absent, and this post aims to inform architects of these changes and why they are happening now.

The Distributed SQL Blog

Universe

Clusters

Authentication

Explore Distributed SQL and YugabyteDB in Depth