Skip to content

server: migrate existing databases to the rbr system table #94843

Closed
Closed
server: migrate existing databases to the rbr system table#94843
Assignees
jeffswenson
Labels
A-multiregionRelated to multi-regionC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-shared-systemsShared Systems Team
@jeffswenson

Description

@jeffswenson
jeffswenson
opened on Jan 6, 2023

#85736 added alternative implementations of system.sqlliveness, system.sql_instances, and system.lease that have a primary key index compatible with regional by row (RBR) tables. Using the RBR compatible tables requires setting the COCKROACH_MR_SYSTEM_DATABASE environment variable.

We should implement a migration that converts the legacy system tables into this new format. That allows us to get rid of the environment variable and migrate tenants from single region hosts into multi-region hosts.

Epic: CRDB-18596

Jira issue: CRDB-23180

Metadata

Metadata

Assignees

Labels

A-multiregionRelated to multi-regionC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-shared-systemsShared Systems Team

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions