SyntaxPilot
Courses/SQL and Databases/Lesson 70
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

SQL and Databases · Lesson 70 of 90

Scaling out: sharding and distributed SQL

vertical scalinghorizontal scalingshardingshard keyhot spotreshardingconsistent hashingcross-shard querydistributed transactiontwo-phase commit (2PC)CAP theoremdistributed SQL (CockroachDB, Spanner, Vitess)connection pooler (PgBouncer)

Detailed notes for this lesson are being written. They appear here together with the video.