Name of the machine where the node is running
Port number of the node
Role of the node. For a list of roles and their meanings, see Roles of a Node
State of the node. For a list of states and their meanings, see States of a Node
Number of the corresponding mirror node.
A node’s role and state can change as described in these sections:
A node is assigned a role during its creation and can take any one of these roles:
Active: Stores data and allows client access. Active nodes are in mirrored pairs.
Spare: Allows client access, but does not store data. After initializing data devices, monitors other data nodes to initiate repair if another node becomes unavailable.
Offline: Provide no services until their role changes. When placed back online, its role can change back to its former role.
Shutdown: An intermediate step between active and offline, waiting for a spare node to take over its functioning. After the spare node has taken over, the node is taken offline.
A node can be in any one of the following states:
Starting: The node is starting.
Waiting: The node cannot decide its start level and is offline. If a single node is in this state for more than two minutes, stop the node and then start it at the repair level; see Stopping a Node and Starting a Node Clearing a database.
Running: The node is providing all services that are appropriate for its role.
Stopping: The node is in the process of stopping.
Stopped: The node is inactive. Repair of a stopped node is prohibited.
Recovering: The node is being recovered. When a node fails, the mirror node takes over the functions of the failed node. The failed node tries to recover by using the data and log records in main memory or on disk. The failed node uses the log records from the mirror node to catch up with the transactions performed when it was down. If recovery is successful, the node becomes active. If recovery fails, the node state changes to repairing.
Repairing: The node is being repaired. This operation reinitializes the node and copies the data and log records from the mirror node. Repair is more time consuming than recovery.