cockroachdb / cockroachdb/cockroach

crosscluster/physical: expose reader tenant reader time in SHOW TENANT WITH REPLICATION STATUS

Open
#148,474 1 comment 0 reactions 0 assignees View on GitHub
A-disaster-recovery C-enhancement P-1 T-disaster-recovery
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Currently, a PCR user has no visibility into the historical time that the _reader tenant_ uses to query the app tenant. In the happy case, it's approximately equal to the replicated time, but it can fall behind if the reader tenant job poller job stalls for some reason.

As a very first step, we should update the standby poller job's resolved time in the `system.job_progress` table so a user logged into the reader tenant's db console can observe it.

However, we should strive to simplify the PCR UX such that all PCR observability can be viewed from the system tenant, via SHOW TENANT WITH REPLICATION STATUS and system tenant time series metrics.

Jira issue: CRDB-51634

Epic CRDB-52290

Contributor guide

Open the contributing guide

Research direction

Start by tracing the standby poller job and its resolved time in system.job_progress, then inspect the SHOW TENANT WITH REPLICATION STATUS entry point. Confirm how the reader tenant's time is represented and how replication status is exposed before deciding what observability should be added. Done means the reader tenant's historical query time is visible as specified, with coverage for the reported status.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, distributed-systems
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.