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.

Last modified: August 29, 2022

Was this article helpful?