Distributed SQL Library | Page 34 of 34

May 21, 2018

Community News Distributed SQL How It Works Release Announcements

YugabyteDB 1.0 — A Peek Under The Hood

Modern user-facing apps, like E-Commerce and SaaS, frequently require features from multiple databases (broadly — SQL, NoSQL and a cache) to support their multi-workload needs. App developers are responsible for understanding and managing which pieces of data should be stored in which SQL and NoSQL database. Furthermore, the app is also responsible for moving data across the tiers (e.g. populating the cache on reads and invalidating it on writes). This greatly increases development and operational complexity,

…

Distributed ACID Transactions with High Performance

April 24, 2018

By Karthik Ranganathan

ACID Transactions Databases Distributed SQL Google Spanner How It Works Performance Benchmarks

Distributed ACID Transactions with High Performance

ACID transactions are a fundamental building block when developing business-critical, user-facing applications. They simplify the complex task of ensuring data integrity while supporting highly concurrent operations. While they are taken for granted in monolithic SQL/relational databases, distributed NoSQL/non-relational databases either forsake them completely or support only a highly restrictive single-row flavor (see sections below). This loss of ACID properties is usually justified with a gain in performance (measured in terms of low latency and/or high throughput).

…

Practical Tradeoffs in Google Cloud Spanner, Azure Cosmos DB and YugabyteDB

January 25, 2018

By Sid Choudhury

ACID Transactions Amazon Web Services Distributed SQL Google Cloud Platform Google Spanner Microsoft Azure Microsoft Azure Cosmos DB

Practical Tradeoffs in Google Cloud Spanner, Azure Cosmos DB and YugabyteDB

Updated April 2019.

The famed CAP Theorem has been a source of much debate among distributed systems engineers. Those of us building distributed databases are often asked how we deal with it. In this post, we dive deeper into the consistency-availability tradeoff imposed by CAP which is only applicable during failure conditions. We also highlight the lesser-known-but-equally-important consistency-latency tradeoff imposed by the PACELC Theorem that extends CAP to normal operations.

…

Facebook’s User Database — Is it SQL or NoSQL?

August 29, 2017

By Karthik Ranganathan

ACID Transactions Databases Distributed SQL Google Spanner

Facebook’s User Database — Is it SQL or NoSQL?

Ever wondered which database Facebook (FB) uses to store the profiles of its 2.3B+ users? Is it SQL or NoSQL? How has FB database architecture evolved over the last 15+ years? As an engineer in FB database infrastructure team from 2007 to 2013, I had a front row seat in witnessing this evolution. There are invaluable lessons to be learned by better understanding the database evolution at the world’s largest social network,

…

Distributed SQL

Explore Distributed SQL and YugabyteDB in Depth