CLUSTER_LAYOUT

Shows the relative position of the actual arrangement of the nodes participating in the cluster and the fault groups (in an Enterprise Mode database) or subclusters (in an Eon Mode database) that affect them.

Shows the relative position of the actual arrangement of the nodes participating in the cluster and the fault groups (in an Enterprise Mode database) or subclusters (in an Eon Mode database) that affect them. Ephemeral nodes are not shown in the cluster layout ring because they hold no resident data.

Column Name Data Type Description
CLUSTER_POSITION INTEGER

Position of the node in the cluster ring, counting forward from 0.

NODE_ID INTEGER A unique numeric ID assigned by the Vertica catalog that identifies the node.
NODE_NAME VARCHAR The name of the node in the cluster ring. Only permanent nodes participating in database activity appear in the cluster layout. Ephemeral nodes are not shown in the output.
FAULT_GROUP_ID INTEGER

A unique numeric ID assigned by the Vertica catalog that identifies the fault group. This column can only have a value in an Enterprise Mode database.

FAULT_GROUP_NAME VARCHAR The name of the fault group for the node. This column can only have a value in an Enterprise Mode database.
FAULT_GROUP_TIER INTEGER

The node's depth in the fault group tree hierarchy. For example if the node:

  • Is not in a fault group, output is null

  • Is in the top level fault group, output is 0

  • Is in a fault group's child, output is 1

  • Is a fault group's grandchild, output is 2

This column can only have a value in an Enterprise Mode database.

SUBCLUSTER_ID INTEGER Unique identifier for the subcluster. This column only has a value in an Eon Mode database.
SUBCLUSTER_NAME VARCHAR The name of the subcluster containing the node. This column only has a value in an Eon Mode database.

See also

Large cluster