Skip to main content

Managing Latency in a Strongly-Consistent Multi-Region Database

A hands-on experience tuning a strongly consistent multi-region database for higher throughput and lower latency.

  • Course Number

    optimizing-latency-in-multi-region
  • Self-Paced

  • Estimated Effort

    1.5 hours/week

About This Course

This is a hands-on course designed to provide you with practical experience in managing latency in strongly-consistent multi-region databases. Our focus is on CockroachDB's multi-region abstractions, particularly the role of table locality in determining database latency.

We'll break down concepts like 'local' and 'non-local' data requests and delve into the practical applications of the three types of table localities: Regional, Regional-by-Row, and Global tables. These table locality settings determine the placement of data leaseholders and are key to effectively managing database latency.

Moreover, we dedicate a significant part of the course to follower reads, exploring both strong and stale variants. This understanding can help reduce read latencies and improve throughput.

By the end of this course, you'll have hands-on experience and a solid understanding of how to use CockroachDB's capabilities to manage and optimize latency in your multi-region database deployments.

Suggested prerequisites

We suggest student familiarity with the following concepts:

  • CockroachDB clusters, forming quorums and consensus
  • Data distribution and replication in CockroachDB
  • Cloud topology terms - Region & Availability Zone

A good prerequisite course for this is Building a Highly Resilient Multi-region Database using CockroachDB

Detailed course outline

  • Course Outline
    • Lesson 1: Managing latency in a strongly consistent multi-region database
      • Video: Managing latency in a strongly consistent multi-region database
      • Quiz: Latency intro
      • Exercise: Introduction to cockroach demo and MovR database initialization
      • Quiz: Exercise environment
    • Lesson 2: Low-latency reads and writes in a single region
      • Video: Low-latency reads and writes in a single region -- regional tables
      • Video: Regional table syntax
      • Exercise: Using a non-default regional table
      • Quiz: Regional tables
    • Lesson 3: Achieving low-latency reads using follower reads
      • Video: Follower reads overview
      • Video: Stale follower reads
      • Video: Exact staleness follower reads
      • Exercise: How to perform a stale follower read
      • Quiz: Follower reads
    • Lesson 4: Low-latency reads and writes from multiple regions
      • Video: Regional by row tables
      • Exercise: Regional by row
      • Quiz: Regional by row
    • Lesson 5: Low-latency, strongly consistent reads from every region
      • Video: Global table locality
      • Exercise: Global tables
      • Quiz: Global tables

Course Staff

Instructor Name
Kiki Carter
Sr. Staff Curriculum Developer @ Cockroach Labs

Kiki is a leader and lover of cloud-native architecture, advocacy, and delivery. She enjoys transforming heritage platforms into massive scaling, high-throughput, low latency systems. Kiki thrives on cultivating successful environments through creative exploration of developer experience, training, and delivery discipline. Kiki is also passionate about computer ethics and the symbiotic relationship between humans and machines..

Frequently Asked Questions

What web browser should I use?

The Open edX platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

See our list of supported browsers for the most up-to-date information.

Enroll