Databases

YugabyteDB 1.1 New Feature: Speeding Up Queries with Secondary Indexes

September 25, 2018

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,

…

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 & consistent secondary indexes

UNIQUE constraint on secondary indexes

Native JSON data type

Public/private IP bindings for multi/hybrid cloud or multi-region deployments

User authentication

And,

…

Apache Cassandra DB Architecture Fundamentals

August 9, 2018

By Jimmy Guerrero

Apache Cassandra How It Works

Apache Cassandra DB Architecture Fundamentals

What is the Apache Cassandra Database?

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, reads and writes (eventually) across multiple nodes with no single point of failure.

…

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

August 8, 2018

By Sid Choudhury

ACID Transactions Distributed SQL Google Spanner How It Works

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

Editor’s note: This post was originally published August 8, 2018 and has been updated as of May 28, 2020.

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,

…

New to Google Cloud Databases? 5 Areas of Confusion That You Better Be Aware of

July 25, 2018

By Sid Choudhury

Google Cloud Platform Google Spanner

New to Google Cloud Databases? 5 Areas of Confusion That You Better Be Aware of

After billions of dollars in capital expenditure and reference customers in every major vertical, Google Cloud Platform has finally emerged as a credible competitor to Amazon Web Services and Microsoft Azure when it comes to enterprise-ready cloud infrastructure. While Google Cloud’s compute and storage offerings are easier to understand, making sense of its various managed database offerings is not for the faint-hearted. This post introduces app developers to the major Google Cloud database services,

…

Implementing Distributed Transactions the Google Way: Percolator vs. Spanner

July 23, 2018

By Sid Choudhury

Google Spanner

Implementing Distributed Transactions the Google Way: Percolator vs. Spanner

In this blog, we dive deeper into Percolator and Spanner as well as the open source databases (YugabyteDB for example) that they have inspired

How DynamoDB’s Pricing Works, Gets Expensive Quickly and the Best Alternatives

July 18, 2018

By Jimmy Guerrero

Amazon DynamoDB Amazon Web Services

How DynamoDB’s Pricing Works, Gets Expensive Quickly and the Best Alternatives

DynamoDB is AWS’s NoSQL alternative to Cassandra, primarily marketed to mid-sized and large enterprises. It works best for those who require a flexible data model, reliable performance, and the automatic scaling of throughput capacity. In a nutshell, DynamoDB’s monthly cost is dictated by data storage, writes and reads. Let’s walk through a synopsis.

11 Things You Wish You Knew Before Starting with DynamoDB

July 10, 2018

By Karthik Ranganathan

Amazon DynamoDB Amazon Web Services

11 Things You Wish You Knew Before Starting with DynamoDB

This post is to help developers and operations engineers understand the precise strengths and weaknesses of DynamoDB, especially when it needs to power a complex, large-scale application.

A Busy Developer’s Guide to Database Storage Engines — The Basics

June 28, 2018

By Sid Choudhury

Databases Distributed SQL How It Works

A Busy Developer’s Guide to Database Storage Engines — The Basics

Learn the basics of database storage engines, incl. B-tree and LSM tree based storage engines that are popular in the context of modern distributed cloud apps

A Busy Developer’s Guide to Database Storage Engines — Advanced Topics

June 28, 2018

By Sid Choudhury

Databases Distributed SQL How It Works

A Busy Developer’s Guide to Database Storage Engines — Advanced Topics

In the first post of this two-part series, we learned about the B-tree vs LSM approach to index management in operational databases. While the indexing algorithm plays a fundamental role in determining the type of storage engine needed, advanced considerations highlighted below are equally important to consider.

Consistency, Transactions, and Concurrency Control

Monolithic databases, which are primarily relational/SQL in nature, support strong consistency and ACID transactions.

…

Databases

Defining Secondary Indexes

YugabyteDB Open Source

What is the Apache Cassandra Database?

Consistency, Transactions, and Concurrency Control

Explore Distributed SQL and YugabyteDB in Depth