skip to Main Content


The Cockroach Hour: Database Topologies – Adding physical geography to database schema

Published August 5, 2020
Watch the webinar

Typically, the only thing you worry about when you implement and deploy a database is the schema and layout of your data. With CockroachDB this is a little different as the distributed nature of the database allows you to think about resilience and latency at the row level of each table

Cockroach delivers bulletproof resilience but also allows you to configure this at the table level.  Further, we can allow you tie data to nay node at the row level so you can either meet privacy laws or more importantly meet customer SLAs for transactional latency.

How you set the database up will impact both of these and we offer a few different topologies to help you think through these challenges

In this episode of the Cockroach Hour, we will talk about topologies and the controls you have at the row level to optimize for survivability and latency in CockroachDB. We will cover

  • Ranges, replication and the importance of primary keys
  • Surviving a data center (region) failure
  • Applying a policy to different tables based on row level needs for latency
  • Adding survival zones to a production database
  • Changing schema in a production instance 
  • Geo-partitioning and data privacy


 The Cockroach Hour

A regular discussion with experts on key topics facing organizations as we all transition to a new digital norm. You bring the questions and we’ll provide experts and a lighthearted and hopefully valuable hour of discussion.

You're in Good Company

Lorem ipsum dolor sit amet about CockroachDB Labs


speaker headshot
Jim Walker
VP of Product Marketing
Cockroach Labs
speaker headshot
Jesse Seldess
VP of Education
Cockroach Labs
speaker headshot
Tim Veil
Head of Sales Engineering
Cockroach Labs

Additional Resources

Learn how to use

Need help? Get answers on the CockroachDB forum

What are you building with CockroachDB?

Back To Top