MV_ AGGREGATED_ REPLICATION_ STATUS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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.MA
or CA
).
Column name |
Description |
---|---|
|
Specifies if the row corresponds to a DR replication link. |
|
Specifies if the row corresponds to a synchronous replication link. |
|
The name of the database in the current host. |
|
The URI of the primary cluster’s |
|
The URI of the secondary cluster’s |
|
The replication state of the primary cluster. |
|
The replication state of the secondary cluster. |
|
The total number of LSNs lagging to catch up with the primary cluster from all nodes. |
|
The total volume of lag, in megabytes (MB), from all nodes. |
|
The total throughput, in megabytes per second (MB/s), from all nodes. |
|
The maximum time, in seconds, required by the secondary cluster to catch up with the primary cluster from all nodes. |
Last modified: April 1, 2025