MV_REPLICATION_STATUS

This view provides the replication status of each replication link in all nodes of the cluster.

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 node in the replication link in the `host:port/source_db_name` format.
`secondary_uri`	The URI of the secondary node in the replication link in the `host:port/source_db_name` format.
`primary_state`	The replication state of the primary node.
`secondary_state`	The replication state of the secondary node.
`lsn_lag`	The LSNs lagging to catch up with the primary cluster in the replication link of the nodes.
`volume_lag_mb`	The volume of lag (in MB) in the replication link of the nodes.
`replication_throughput_mbps`	The replication throughput between the nodes in the replication link.
`estimated_catchup_time_s`	The estimated catchup time (in seconds) between the nodes in the replication link.

Was this article helpful?