Taming Cross-Region Latency in Geo-Distributed SQL Databases

Explore the intricacies of managing cross-region latency in geo-distributed SQL databases in this informative conference talk. Delve into various database types, understand the concept and importance of distributed SQL, and examine its architecture. Learn about different deployment strategies, including active/passive disaster recovery and active/active multi-master setups. Discover advanced techniques such as strongly-consistent reads without quorum, preferred region for shard leaders, row-level geo-partitioning, and topology-aware SQL client drivers. Gain insights into read replicas, multi-master deployments with XCluster replication, and understand why distributed SQL is considered the future of relational database management systems.

Introducción
Types of Databases
What is Distributed SOL?
Why Distributed SQL?
Distributed SQL Architecture
Distributed SQL is the Future of RDBMS
Traditional RDBMS - Active/Passive Disaster Recovery
Traditional RDBMS - Active/Active Multi-Master
Distributed SQL - No Data Loss & Multiple Topologies
Strongly-Consistent Reads without Quorum
Preferred Region for Shard Leaders
Row-Level Geo-Partitioning
Colocated/Co-partitioned/Interleaved Tables
Topology-Aware SQL Client Drivers
8. Read Replicas
Multi-Master Deployments w/ XCluster Replication
Summary Distributed SOL is the future of RDBMS