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

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

Published Wednesday, Aug 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.


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

Additional Resources

Learn how to use CockroachDB
Read the docs
Need help? Get answers on the CockroachDB forum
Ask on the forum
What are you building with CockroachDB?
Share your project