How CockroachDB can enable Multi-Region Deployments and Data Locality
summary
Overview of how CockroachDB runs Ory as a single distributed SQL cluster across clouds and regions, maintaining PII locality by pinning rows to regions and enforcing row-level locality while serving reads and writes everywhere in active-active multi-region fashion. Cluster is built from a minimum of three nodes, scales online by adding nodes, uses a two‑of‑three quorum for commits, claims near‑zero RPO/RTO, and addresses throughput limits customers hit (example cited: ~6,000 inserts/sec causing failures before migration).
AI-written summary · about
chapters (7)
- 0:00Introduction and speaker welcome
- 0:50What is CockroachDB and why it exists
- 3:24CockroachDB architecture and PostgreSQL compatibility
- 5:32Scaling horizontally with CockroachDB
- 8:44Multi-region deployments and data locality
- 11:34Row-level locality for compliance and access
- 13:20Key benefits and wrap-up
related talks
48mBuilding mission-critical applications with CockroachDB
33mWhat We’ve Learned Building a Multi-Region DBaaS on Kubernetes
22mBuilding CockroachDB for performance at scale
01h 11mFearless global transactions with
31mFuture-proofing operational data at scale
52mCockroachDB
42mThe hows and whys of a distributed SQL database
29mHow City Storage Systems designed its Data Infrastructure to minimize toil