Anatomy of a Distributed SQL Database - YugabyteDB

Explore the architecture and technology behind YugabyteDB, an open-source distributed SQL database, in this 58-minute conference talk. Delve into the challenges of porting PostgreSQL features to a horizontally scalable, cloud-native database. Discover how YugabyteDB incorporates modern technologies such as consensus protocols, logical clocks, and automatic sharding. Learn about the shift from B-Tree indexes to LSM Tree and SSTables, optimized for SSD and distributed storage. Examine the unique architectural design that combines PostgreSQL's query layer with a distributed storage and transaction layer, drawing inspiration from systems like Spanner, Cassandra, and RocksDB. Gain insights into the advantages and challenges of this innovative approach to database design, and understand the rationale behind creating a new database with cutting-edge underlying technology.

[VDBUH2023] - Franck Pachot - Anatomy of a distributed SQL database (YugabyteDB)