Skip to Content
Understanding Multi-Region Application Architecture
book

Understanding Multi-Region Application Architecture

by Rob Reid
February 2024
Intermediate to advanced
52 pages
1h 7m
English
O'Reilly Media, Inc.
Content preview from Understanding Multi-Region Application Architecture

Chapter 2. Distributed Databases

A lot has changed since the term “relational database” was first coined in 1970. Legacy relational database management systems (RDBMSs) brought with them ACID compliance but were operating in a pre-cloud world and so were not built to be horizontally scalable. HBase, inspired by Google’s 2006 Bigtable whitepaper, was created by Powerset in 2008, followed a couple of months later by Cassandra from Facebook. Both provided the ability to scale larger than any RDBMS had done before but at the cost of ACID compliance.

It wasn’t until the Spanner whitepaper was published in 2012 that the concept of a natively distributed RDBMS became a reality. In 2015, CockroachDB entered the database stage and brought with it the possibility for ACID compliance at a global scale.

With the ability to now scale a relational database far beyond what was previously possible, the following capabilities are now available:

  • Expand your business into global markets with one database

  • Scale up and down depending on demand

  • Survive disasters arising from node, AZ, region, or even entire CSP failures

Considerations When Using a Distributed SQL Database

The challenges of running a distributed SQL database differ from those of running a traditional database. Let’s compare.

We’ll start with traditional databases:

Resilience

With databases, such as MySQL, Postgres, and databases built atop these technologies, such as AlloyDB, AWS Aurora, etc., you’re typically writing to ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Architecting Distributed Transactional Applications

Architecting Distributed Transactional Applications

Guy Harrison, Andrew Marshall, Charles Custer
Coaching for High Performance

Coaching for High Performance

MIT Sloan Management Review

Publisher Resources

ISBN: 9781098164478