Скачать или смотреть DoorDash’s Journey from Aurora Postgres to CockroachDB | RoachFest 2023

In this talk from RoachFest 2023, Alessandro Salvatori, Principal Engineer, at DoorDash shared why and how the company migrated from Aurora Postgres to distributed SQL database CockroachDB. Allesandro covers how DoorDash uses CockroachDB, the differences between Aurora Postgres vs CockroachDB, and solving issues such as normalizing schema, failover/failback processes, performance engineering, and query tuning.

00:00 Welcome/Introduction
02:01 DoorDash's Django monolith / single database cluster
02:18 Implementing microservices into the monolith
03:49 Survival strategies at DoorDash
04:24 When DoorDash went down on April 17, 2020
08:07 DoorDash's extraction tooling
10:03 Why you should invest in reusable tooling
10:55 Traditional migration pitfalls
13:11 The importance of keeping it simple!
14:51 Customizing runtime behavior
16:09 Schema transformations
18:22 Runtime behavior (continued)
19:48 Table extraction to Aurora Postgres (before and after cutover)
20:27 Forklift extraction to CockroachDB
21:33 aurora-extract in Slack
22:22 CockroachDB migration demo

DoorDash’s Journey from Aurora Postgres to CockroachDB: