How Route enables always-on data for over 1 billion+ orders

on YouTube ↗28m

" summary

Route runs self-hosted CockroachDB on AWS ECS to serve over 1 billion+ orders, scaling from 3x nodes and 12x CPU to ~52 TB storage with no data migrations or downtime. Architecture uses tagged EBS volume groups, multiple stores per node, autoscaling EC2 instances and custom user-data tooling to reattach volumes, letting ranges re-replicate after drive failure. Operational practices: patches without maintenance windows, changefeeds to S3 for analytics separation, covering indexes and SQL Insights, and enterprise support to tune the optimizer.

AI-written summary · about

" chapters (23)

1. 0:00Introduction
2. 0:17CockroachDB vs Traditional SQL DB: What happens during a storage failure?
3. 0:42How typical SQL DBs handle storage failure
4. 2:03How CockroachDB handles a storage failure
5. 3:25Who is Bryan Call?
6. 4:30What does Route do?
7. 5:09How does CockroachDB help deliver on Route's mission?
8. 6:32Scalability in CockroachDB
9. 7:49Route's journey with CockroachDB: A Marathon
10. 8:55Scaling without data migrations or downtime
11. 9:30How a resilient database can increase revenue
12. 12:10CockroachDB architecture at Route
13. 13:17Running CockroachDB self-hosted in AWS using ECS
14. 16:17CockroachDB tips and tricks
15. 18:03How database resilience leads to customer satisfaction
16. 19:28CockroachDB vs DynamoDB
17. 20:08CockroachDB vs Traditional SQL
18. 20:29Why should you choose CockroachDB?
19. 20:55Query best practices
20. 22:43When to use covering indexes
21. 23:44Pros and cons of covering indexes
22. 24:54Challenges with CockroachDB
23. 26:34The biggest benefits

" related talks

• 31mFuture-proofing operational data at scaleSpencer Kimball · RoachFest 2025 Las Vegas
• 48mBuilding mission-critical applications with CockroachDBAndrew Baptist · AWS re:Invent 2023
• 23mWhy Squarespace adopted CockroachDB for better global performance at scaleGav McQuillin · RoachFest 2025 Las Vegas
• 14mHow CockroachDB can enable Multi-Region Deployments and Data Locality Patrick Schulz · Ory Summit 2023
• 27mBeyond the Roadmap and Into the Future of CockroachDBIgor Stanko · RoachFest London 2026
• 39mScaling Shopify's Multi-Tenant Architecture across Multiple DatacentersFlorian Weingarten · SREcon16 Europe
• 33mBuilding an Elastic, Resilient Data Layer to Power New Retail ExperiencesAmey Banarse, Michael Haag · Distributed SQL Summit Asia 2023
• 32mLow Latency Serving of Offline Data: Efficient, Safe, and Reliable Data...William Schor · SREcon26 Americas