Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

21.6.15.7 The ndbinfo config_nodes Table

Theconfig_nodes table shows nodes configured in an NDB Clusterconfig.ini file. For each node, the table displays a row containing the node ID, the type of node (management node, data node, or API node), and the name or IP address of the host on which the node is configured to run.

This table does not indicate whether a given node is actually running, or whether it is currently connected to the cluster. Information about nodes connected to an NDB Cluster can be obtained from thenodes andprocesses table.

Theconfig_nodes table contains the following columns:

  • node_id

    The node's ID

  • node_type

    The type of node

  • node_hostname

    The name or IP address of the host on which the node resides

Notes

Thenode_id column shows the node ID used in theconfig.ini file for this node; if none is specified, the node ID that would be assigned automatically to this node is displayed.

Thenode_type column displays one of the following three values:

  • MGM: Management node.

  • NDB: Data node.

  • API: API node; this includes SQL nodes.

Thenode_hostname column shows the node host as specified in theconfig.ini file. This can be empty for an API node, ifHostName has not been set in the cluster configuration file. IfHostName has not been set for a data node in the configuration file,localhost is used here.localhost is also used ifHostName has not been specified for a management node.

Theconfig_nodes table was added in NDB 7.5.7.