Databases Archives - Page 10 of 12 - The Distributed SQL Blog

ACID Transactions Apache Cassandra How It Works

October 22, 2018

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

ACID transactions were a big deal when first introduced formally in the 1980s in monolithic SQL databases such as Oracle and IBM DB2. Popular distributed NoSQL databases of the past decade including Apache Cassandra initially focused on “big data” use cases that did not require such guarantees and hence avoided implementing them altogether. Our post, “A Primer on ACID Transactions: The Basics Every Cloud App Developer Must Know”

…

ACID Transactions CockroachDB Google Spanner How It Works

October 11, 2018

by Sid Choudhury

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 YugaByte DB 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.

…

Apache Cassandra Community News How It Works MongoDB YugabyteDB 1.1

September 26, 2018

by Karthik Ranganathan

YugaByte DB 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 YugaByte DB’s Cassandra compatible YCQL API. Note that this data type is specific to YugaByte DB and is not part of the standard Cassandra Query Language (CQL).

…

Apache Cassandra Community News How It Works MongoDB YugabyteDB 1.1

September 25, 2018

by Karthik Ranganathan

YugaByte DB 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.

…

Apache Cassandra Community News Company News Performance Benchmarks PostgreSQL Release Announcements YugabyteDB 1.1

September 21, 2018

by Karthik Ranganathan

Technical Deep Dive into YugaByte DB 1.1

We announced the general availability of YugaByte DB 1.1 earlier this week. You can download the latest version for your OS or use our default container image as documented in our Quick Start page.

YugaByte DB is an open source database for high performance applications that require ACID transactions and multi-region data distribution.

…

Community News Company News Distributed SQL PostgreSQL Release Announcements YugabyteDB 1.1

September 19, 2018

by Kannan Muthukkaruppan

Announcing YugaByte DB 1.1 and Company Update

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

YugaByte DB Open Source

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

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

…

Apache Cassandra How It Works

August 9, 2018

by Jimmy Guerrero

Apache Cassandra Architecture Fundamentals

What is Apache Cassandra?

Apache Cassandra is a distributed open source database that can be referred to as a “NoSQL database” or a “wide column store.” Cassandra was originally developed at Facebook to power its “Inbox” feature and was released as an open source project in 2008. Cassandra is designed to handle “big data” workloads by distributing data,

…

ACID Transactions Google Spanner How It Works

August 8, 2018

by Sid Choudhury

How Does the Raft Consensus-Based Replication Protocol Work in YugabyteDB?

As we saw in ”How Does Consensus-Based Replication Work in Distributed Databases?”, Raft has become the consensus replication algorithm of choice when it comes to building resilient, strongly consistent systems. YugabyteDB uses Raft for both leader election and data replication. Instead of having a single Raft group for the entire dataset in the cluster, YugabyteDB applies Raft replication at an individual shard level where each shard has a Raft group of its own.

…

ACID Transactions CockroachDB Distributed SQL Google Cloud Platform Google Spanner

July 23, 2018

by Sid Choudhury

Implementing Distributed Transactions the Google Way: Percolator vs. Spanner

Our post 6 Signs You Might be Misunderstanding ACID Transactions in Distributed Databases describes the key challenges involved in building high performance distributed transactions. Multiple open source ACID-compliant distributed databases have started building such transactions by taking inspiration from research papers published by Google. In this post, we dive deeper into Percolator and Spanner, the two Google systems behind those papers,

…