The Distributed SQL Blog

YSQL Architecture: Implementing Distributed SQL in YugabyteDB

October 25, 2018

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.

…

Introducing YSQL: A PostgreSQL Compatible Distributed SQL API for YugabyteDB

October 25, 2018

By Karthik Ranganathan

Release Announcements YugabyteDB

Introducing YSQL: A PostgreSQL Compatible Distributed SQL API for YugabyteDB

YugaByte has introduced YSQL, a PostgreSQL-compatible distributed SQL API in YugabyteDB’s 1.1 release. This architecture enables developer agility, operational simplicity, and scalability, addressing the needs of fast-growing online services and cloud-native deployments.

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.

…

YugabyteDB 1.1 New Feature: Public IPs to Simplify Multi or Hybrid Cloud Database Deployments

October 2, 2018

By Karthik Ranganathan

How It Works How To YugabyteDB

YugabyteDB 1.1 New Feature: Public IPs to Simplify Multi or Hybrid Cloud Database Deployments

Welcome to another post in our ongoing series that highlights new features from the latest 1.1 release announced last week. Today we are going to look at the importance of public IP addresses and hostnames in simplifying multi-cloud and hybrid cloud deployments.

In modern cloud deployments, servers often have a combination of private IP addresses (used in the private LAN and often the IP address of the network interface on the server),

…

YugabyteDB 1.1 New Feature: Document Data Modeling with the JSON Data Type

September 26, 2018

By Karthik Ranganathan

Apache Cassandra Community News How It Works MongoDB YugabyteDB

YugabyteDB 1.1 New Feature: Document Data Modeling with the JSON Data Type

Welcome to another post in our ongoing series that highlights new features from the latest 1.1 release announced last week. Today we are going to look at document data modeling using the native JSON data type available in YugabyteDB’s Cassandra compatible YCQL API. Note that this data type is specific to YugabyteDB and is not part of the standard Cassandra Query Language (CQL).

With YugabyteDB’s native JSON support,

…

YugabyteDB 1.1 New Feature: Speeding Up Queries with Secondary Indexes

September 25, 2018

By Karthik Ranganathan

Apache Cassandra Community News How It Works MongoDB YugabyteDB

YugabyteDB 1.1 New Feature: Speeding Up Queries with Secondary Indexes

Welcome to another post from our ongoing series where we highlight a new feature from the latest 1.1 release! Today we are going to look at secondary indexes.

Defining Secondary Indexes

A database index is a data structure that improves the speed of data retrieval operations on a database table. Typically, databases are very efficient at looking up data by the primary key. A secondary index can be created using one or more columns of a database table,

…

September 21, 2018

By Karthik Ranganathan

Performance Benchmarks

Technical Deep Dive into YugabyteDB 1.1

We announced the general availability of YugabyteDB 1.1 earlier this week. This post gives you a deep dive into the various features of YugabyteDB 1.1.

Announcing YugabyteDB 1.1 and Company Update

September 19, 2018

By Kannan Muthukkaruppan

Community News Company News Distributed SQL PostgreSQL YugabyteDB

Announcing YugabyteDB 1.1 and Company Update

The team at YugaByte is excited to announce that YugabyteDB 1.1 is officially GA! You can download the latest version from our Quick Start page. New in this release:

YugabyteDB Open Source

- Excellent progress on YSQL, our Postgres-compatible Distributed SQL API

- Distributed multi-shard/multi-table ACID transactions!

- Global &

…

Ravi Murthy: Starting a New Chapter with YugaByte

September 19, 2018

By Ravi Murthy

Community News Company News

Ravi Murthy: Starting a New Chapter with YugaByte

In case you missed the announcement, Ravi Murthy has joined YugaByte as our VP of Engineering. Read on to learn more about his experiences leading the teams who managed the explosive growth of applications and data at Facebook, plus what’s next at YugaByte!

After almost 7 years at Facebook, I am super-excited to start in my new role as YugaByte’s VP of Engineering. This post provides a brief history of my career through the years,

…

The Distributed SQL Blog

Defining Secondary Indexes

YugabyteDB Open Source

Explore Distributed SQL and YugabyteDB in Depth