MV_AGGREGATED_REPLICATION_STATUS

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

Each row in this view corresponds to a specific type of replication (DR/non-DR) for each database in 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 cluster’s `MA` in the `host:port/source_db_name` format.
`secondary_uri`	The URI of the secondary cluster’s `MA` in the `host:port/source_db_name` format.
`primary_state`	The replication state of the primary cluster.
`secondary_state`	The replication state of the secondary cluster.
`lsn_lag`	The total number of LSNs lagging to catch up with the primary cluster 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 cluster to catch up with the primary cluster from all nodes.

MV_AGGREGATED_REPLICATION_STATUS

Was this article helpful?

Was this article helpful?