Scaling to support America’s #1 sportsbook
summary
FanDuel replaces a Percona Galera MySQL cluster with CockroachDB across EC2 outposts and local zones, using DMS for initial migration and Cockroach’s CDC, TTL and audit logging to shrink storage and meet compliance. Schema tweaks remove sequential hot‑spots and a nine‑node Cockroach cluster sustains over 5,000 TPS in testing (3,300 TPS baseline), eliminates ProxySQL complexity, and eases DR by spanning sites while keeping instances ephemeral with tagged EBS volumes and Haroxy service discovery. CockroachDB migration succeeds at horizontal scale.
AI-written summary · about
chapters (10)
- 0:00Scaling FanDuel’s sportsbook
- 1:54AWS Outposts challenges
- 3:41Percona solution limits
- 5:48Why CockroachDB chosen
- 7:11Performance gains with CockroachDB
- 8:53Migration to CockroachDB
- 10:01CockroachDB setup
- 12:07Disaster recovery benefits
- 13:33CockroachDB advantages
- 14:15Closing remarks
related talks
48mBuilding mission-critical applications with CockroachDB
18mFrom Today to 10X: Why Groww chose
24mNavigating Distributed Databases: Challenges & Opportunities
27mBeyond the Roadmap and Into the Future of CockroachDB
27mHow Devsisters launches blockbuster games in new countries with ease
22mBuilding CockroachDB for performance at scale
29mHow City Storage Systems designed its Data Infrastructure to minimize toil
37mRunning a Cloud-Native SQL Database on Mesos