Scaling to support America’s #1 sportsbook
summary
FanDuel replaces a Percona/Galera MySQL stack with CockroachDB to horizontally scale its single-wallet financial ledger, migrating via AWS DMS and a fallback using Cockroach’s migration tool. The live setup runs Cockroach on EC2 with ASGs, reusable EBS volumes and Haroxy service discovery, drops ProxySQL, and uses CDC, TTL and index redesigns to remove hot spots. Performance testing hits ~2,700 tps on MySQL, 3,300 tps on 9-node Cockroach, and engineers claim >5,000 tps with the same nine nodes while gaining audit logs for compliance.
AI-written summary · about
chapters (9)
- 0:00Scaling FanDuel’s sportsbook
- 1:54AWS Outposts and local zones issues
- 4:47Percona MySQL limitations
- 6:55Why CockroachDB for scaling
- 9:02Percona to CockroachDB migration
- 10:49CockroachDB on EC2 setup
- 12:14Multi-site deployment and recovery
- 13:36CockroachDB benefits at FanDuel
- 14:21Acknowledgments
related talks
18mFrom Today to 10X: Why Groww chose
48mBuilding mission-critical applications with CockroachDB
28mGlobal Payments: Subsecond Performance Worldwide
17mMigrating Primer’s Live Payments Platform to CockroachDB with Zero Downtime
24mNavigating Distributed Databases: Challenges & Opportunities
27mHow Devsisters launches blockbuster games in new countries with ease
15mWhy Yubi selected CockroachDB to power 10x transactional growth
27mBeyond the Roadmap and Into the Future of CockroachDB