Rootconf
Rootconf

Rows, columns, and consequences

Speak at Rootconf’s Special Edition on Databases

All submissions

Chandra T

@chandrat

From "Runs Across Regions" to "Works the Way You Intended": Building Multi-Region SQL Abstractions in CockroachDB

Submitted Apr 29, 2026

Session type - select the format for your session: 30-minute talk – technical deep dive

Description

Multi-region database deployments are usually motivated by resilience, but resilience is only part of the story. Teams also need to control where data lives (for compliance and data residency), keep read latency low even during failover, and avoid the situation where a well-intentioned rebalancing decision silently turns a local query into a cross-region one. The challenge is that these goals cut across replica placement and query planning, and it’s not easy to expose that complexity in a way developers can reason about.

In this talk, I’ll describe how we designed a layered set of SQL abstractions in CockroachDB that let developers declare multi-region intent without reasoning about low-level replica placement.

I’ll also discuss the complexities of implementing these ideas in production, for example, the interactions between super regions, primary regions, and secondary regions that we’re navigating as we bring super regions to GA. The underlying research was published at SIGMOD 2022, and the system has been running in production multi-region clusters for several years since, giving us a clear view of what the original design got right and where we’ve had to adapt.

Takeaways

  • Simple abstractions for complex problems
  • Multi-region problems beyond resilience

Target Audience

This talk is for engineers who operate or build distributed databases and want a concrete example of how to bridge the gap between “the system can technically tolerate a region failure” and “the system does what you actually intended when a region fails.”

Bio

Becca Taft is the Director of SQL Engineering at Cockroach Labs. During her 8+ years at the company, she helped build the cost-based query optimizer from scratch and added support for features such as geospatial indexing and locality-optimized search in multi-region clusters. Prior to joining Cockroach Labs, she got her PhD in Computer Science at MIT with a focus on database elasticity and multi-tenancy. In her spare time, she enjoys rowing on the Chicago river and exploring the city with her husband and 2-year-old son.

All submissions

Comments

{{ gettext('Login to leave a comment') }}

{{ gettext('Post a comment…') }}
{{ gettext('New comment') }}
{{ formTitle }}

{{ errorMsg }}

{{ gettext('No comments posted yet') }}

Hosted by

Rootconf
Rootconf
We care about site reliability, cloud costs, security and data privacy