SingleStore Managed Service

mv_aggregated_replication_status

The mv_aggregated_replication_status view in the information_schema database 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.