# 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 primaryclusterin the replication link of the nodes.              |
| `volume_lag_mb`               | The volume of lag, in megabytes (MB), in the replication link of the nodes.                            |
| `replication_throughput_mbps` | The replication throughput, in megabytes per second (MB/s), between the nodes in the replication link. |
| `estimated_catcup_time_s`     | The estimated catchup time (in seconds) between the nodes in the replication link.                     |

***

Modified at: April 1, 2025

Source: [/db/v9.1/reference/information-schema-reference/replication-management/lmv-replication-status/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/replication-management/lmv-replication-status/)

(An index of the documentation is available at /llms.txt)