In this video I talk to Franck Pachot about internals of YugabyteDB. Franck has joined the show previously to talk about general database internals and its again a pleasure to host him and talk about DistributedSQL, YugabyteDB, ACID properties, PostgreSQL compatibility etc.

Chapters:

00:00 Introduction

01:26 What does Cloud Native means?

02:57 What is Distributed SQL?

03:47 Is DistributedSQL also based on Sharding?

05:44 What problem does DistributedSQL solves?

07:32 Writes - Behind the scenes.

10:59 Reads: Behind the scenes.

17:01 BTrees vs LSM: How is the data written do disc?

25:02 Why RocksDB?

29:52 How is data stored? Key Value?

33:56 Transactions: Complexity, SQL vs NoSQL

42:51 MVCC in YugabyteDB: How does it work?

45:08 Default Transaction Isolation level in YugabyteDB

51:57 Fault Tolerance & High Availability in Yugabyte

56:48 Thoughts on Postgres Compatibility and Future of Distributed SQL

01:03:53 Usecases not suitable for YugabyteDB

Previous videos:

Database Internals:

Part1: https://youtu.be/DiLA0Ri6RfY?si=ToGv9NwjdyDE4LHO

Part2: https://youtu.be/IW4cpnpVg7E?si=ep2Yb-j_eaWxvRwc

Geo Distributed Applications: https://youtu.be/JQfnMp0OeTA?si=Rf2Y36-gnpQl18yj

Postgres Compatibility: https://youtu.be/2dtu_Ki9TQY?si=rcUk4tiBmlsFPYzY

I hope you liked this episode, please hit the like button and subscribe to the channel for more.

Popular playlists:

Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-

Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17

Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d

Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN

Franck's Twitter and Linkedin: https://twitter.com/FranckPachot and https://www.linkedin.com/in/franckpachot/

Connect and follow here: https://twitter.com/thegeeknarrator and https://www.linkedin.com/in/kaivalyaapte/

Keep learning and growing.

Cheers,

The GeekNarrator