MV_CLUSTER_STATUS

This view stores information about partitions within a workspace.

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.

Last modified: August 29, 2022

Was this article helpful?