MV_AGGREGATED_REPLICATION_STATUS

This view provides the aggregated replication status of each database in the workspace.

Each row in this view corresponds to a specific type of replication (DR/non-DR) for each database in the workspace. This view can be accessed from any aggregator (MA or CA).

Column name

Description

is_dr

Specifies if the row corresponds to a DR replication link.

is_sync

Specifies if the row corresponds to a synchronous replication link.

database_name

The name of the database in the current host.

primary_uri

The URI of the primary workspace’s MA in the host:port/source_db_name format.

secondary_uri

The URI of the secondary workspace’s MA in the host:port/source_db_name format.

primary_state

The replication state of the primary workspace.

secondary_state

The replication state of the secondary workspace.

lsn_lag

The total number of LSNs lagging to catch up with the primary workspace from all nodes.

volume_lag_mb

The total volume of lag (in MB) from all nodes.

replication_throughput_mbps

The total throughput (in MB per second) from all nodes.

estimated_catcup_time_s

The maximum time (in seconds) required by the secondary workspace to catch up with the primary workspace from all nodes.

Last modified: August 29, 2022

Was this article helpful?