# MV\_CLUSTER\_STATUS

This view stores information about partitions within a cluster.

Learn more about interpreting this view in the [Components to Monitor](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/cluster-health-and-performance/components-to-monitor/#UUID-f938834d-7cd6-5643-75cb-266137b4c1a2.md) guide.

| Column Name               | Description                                                                                                                       |
| ------------------------- | --------------------------------------------------------------------------------------------------------------------------------- |
| `NODE_ID`                 | The`ID`of the related node.                                                                                                       |
| `HOST`                    | The hostname or IP address for the related leaf node.                                                                             |
| `PORT`                    | The port number of the related leaf node.                                                                                         |
| `DATABASE_NAME`           | The name of the related database.                                                                                                 |
| `ROLE`                    | The role of the related database (orphan, master, child, or reference).                                                           |
| `STATE`                   | The state of the related database (online, offline, replicating).                                                                 |
| `POSITION`                | A number indicating the position in the transaction log.                                                                          |
| `MASTER_HOST`             | The hostname or IP address for the related master aggregator.                                                                     |
| `MASTER_PORT`             | The port number of the related master aggregator.                                                                                 |
| `METADATA_MASTER_NODE_ID` | The`ID`of the master aggregator node expected by the metadata.                                                                    |
| `METADATA_MASTER_HOST`    | The hostname or IP address for the related master aggregator expected by the metadata.                                            |
| `METADATA_MASTER_PORT`    | The port number of the related master aggregator expected by the metadata.                                                        |
| `METADATA_ROLE`           | The role of the related database expected by the metadata.                                                                        |
| `DETAILS`                 | An optional message about the current state.                                                                                      |
| `COMMITTED_POSITION`      | The position up to which each transaction has been committed. All pages in the log before this`LSN`are confirmed to be committed. |
| `HARDENED_POSITION`       | The current position in the transaction log on disk. All pages in the log before this`LSN`are written to disk.                    |
| `REPLAY_POSITION`         | The position up to which changes have been applied to replica. All pages before this`LSN`have been replayed into memory.          |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/mv-cluster-status/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-cluster-status/)

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