Databases

January 16, 2019

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 —

…

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.

YugaByte Announces Kubernetes StatefulSets Support to Enable Scale-Out PostgreSQL Deployments

December 10, 2018

By Kannan Muthukkaruppan

ACID Transactions Community News Company News Distributed SQL Kubernetes PostgreSQL

YugaByte Announces Kubernetes StatefulSets Support to Enable Scale-Out PostgreSQL Deployments

YugaByte is excited to be at KubeCon today to announce Kubernetes StatefulSets support for our distributed SQL API which complements the transactional NoSQL APIs already generally available. YSQL is YugabyteDB’s PostgreSQL-compatible Distributed SQL API (currently in Beta). This new feature, available in YugabyteDB 1.1.7, cloud-native applications and microservices can rely on SQL and NoSQL to take full advantage of Kubernetes StatefulSets to power horizontally scalable, highly fault-tolerant data services,

…

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.

Presto on YugabyteDB: Interactive OLAP SQL Queries Made Easy

November 14, 2018

By Ravi Murthy

Apache Cassandra How To PostgreSQL YugabyteDB

Presto on YugabyteDB: Interactive OLAP SQL Queries Made Easy

This post describes how you can run Presto queries on YCQL API as well as join data across the YCQL and YSQL APIs.

Are MongoDB’s ACID Transactions Ready for High-Performance Applications?

November 1, 2018

By Sid Choudhury

ACID Transactions MongoDB YugabyteDB

Are MongoDB’s ACID Transactions Ready for High-Performance Applications?

MongoDB’s “schemaless” JSON data modeling was initially attractive to web app developers looking to escape the constraints of traditional relational databases, but issues with data durability and ACID transactions have been a consistent challenge. While the recent MongoDB 4.0 release includes multi-document transaction support, this post explores where the platform falls short for transactional, high performance apps.

YSQL Architecture: Implementing Distributed SQL in YugabyteDB

October 25, 2018

By Karthik Ranganathan

Distributed SQL How It Works PostgreSQL YugabyteDB

YSQL Architecture: Implementing Distributed SQL in YugabyteDB

In this post, we will look at the architecture of YSQL, the PostgreSQL-compatible distributed SQL API in YugabyteDB. We will also touch on the current state of the project and the next steps in progress. Here is a quick overview:

YugabyteDB has a common distributed storage engine that powers both SQL and NoSQL
For supporting NoSQL apps, YugabyteDB is designed for low latency, sub-millisecond reads and massive write scalability. It can handle millions of requests and many TBs of data per node with linear scalability and high resilience.

…

Apache Cassandra: The Truth Behind Tunable Consistency, Lightweight Transactions & Secondary Indexes

October 22, 2018

By Sid Choudhury

ACID Transactions Apache Cassandra How It Works

Apache Cassandra: The Truth Behind Tunable Consistency, Lightweight Transactions & Secondary Indexes

Let’s take a look at the evolution of transactions in Apache Cassandra especially in the context of Quorum Reads/Writes, Lightweight Transactions and Secondary Indexes.

Google Spanner vs. Calvin: Is There a Clear Winner in the Battle for Global Consistency at Scale?

October 11, 2018

By Sid Choudhury

ACID Transactions CockroachDB Google Spanner How It Works

Google Spanner vs. Calvin: Is There a Clear Winner in the Battle for Global Consistency at Scale?

Prof. Daniel Abadi, lead inventor of the Calvin transaction management protocol and the PACELC theorem, wrote a thought-provoking post last month titled “NewSQL database systems are failing to guarantee consistency, and I blame Spanner”. The post takes a negative view of software-only Google Spanner derivative databases such as YugabyteDB and CockroachDB that use Spanner-like partitioned consensus for single shard transactions and a two phase commit (2PC) protocol for multi-shard (aka distributed) ACID transactions.

…

Databases

PostgreSQL API Updates & PostgresConf Silicon Valley Wrap-Up

Explore Distributed SQL and YugabyteDB in Depth