LMV_REPLICATION_STATUS

This view provides the replication status of every replication link on a single node. This view can be accessed from any node in the cluster.

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.
`is_master`	Specifies if the current node is the primary node or the secondary node in the replication link.
`database_name`	The name of the database in the current host.
`database_id`	The ID of the database in the current node.
`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_catcup_time_s`	The estimated catchup time (in seconds) between the nodes in the replication link.

Was this article helpful?