How does CockroachDB harness MVCC? | Behind the Architecture of CockroachDB [DEMO]

Description

Want to understand how distributed SQL database CockroachDB harnesses MVCC (Multi-Version Concurrency Control) to support concurrent requests? Join Cockroach Labs Technical Evangelist Rob Reid for a short demo where rows are created, deleted, schemas are modified, and what that means for storage in CockroachDB. Table of contents: How does CockroachDB harness MVCC? 00:00 A brief introduction to MVCC 00:26 Creating a CockroachDB database, inserting a table, adding data, and taking a snapshot [Demo] 00:44 Performing a schema change in CockroachDB 01:00 The primary key before and after the change 01:18 Deleting rows in CockroachDB 01:45 Garbage Collection in CockroachDB 02:17 Closing notes (Data versioning in CockroachDB) Further reading: ✔️ [Docs] CockroachDB Architecture: https://cockroa.ch/3RzIvrh ✔️ [Docs] AS OF SYSTEM TIME in CockroachDB: https://cockroa.ch/46O4IXa ✔️ [Blog] Writing History Part 1: How we rebuilt bulk operations to preserve a history of changes https://cockroa.ch/3GGeiAt ✔️ [Blog] Writing History Part 2: MVCC bulk ingestion and index backfills https://cockroa.ch/41hazTO ✔️ [Blog] Writing History Part 3: MVCC range tombstones https://cockroa.ch/3GBOxBE #distributedsql #cockroachdb