<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-config-nodes">
      </a>
      25.6.17.10 The ndbinfo config_nodes Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045090224400">
  </a>
  <p>
   The
   <code class="literal">
    config_nodes
   </code>
   table shows nodes configured
        in an NDB Cluster
   <code class="filename">
    config.ini
   </code>
   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.
  </p>
  <p>
   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 the
   <a class="link" href="mysql-cluster-ndbinfo-nodes.html" title="25.6.17.48 The ndbinfo nodes Table">
    <code class="literal">
     nodes
    </code>
   </a>
   and
   <a class="link" href="mysql-cluster-ndbinfo-processes.html" title="25.6.17.51 The ndbinfo processes Table">
    <code class="literal">
     processes
    </code>
   </a>
   table.
  </p>
  <p>
   The
   <code class="literal">
    config_nodes
   </code>
   table contains the following
        columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       node_id
      </code>
     </p>
     <p>
      The node's ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       node_type
      </code>
     </p>
     <p>
      The type of node
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       node_hostname
      </code>
     </p>
     <p>
      The name or IP address of the host on which the node resides
     </p>
    </li>
   </ul>
  </div>
  <h5>
   <a name="idm46045090210208">
   </a>
   Notes
  </h5>
  <p>
   The
   <code class="literal">
    node_id
   </code>
   column shows the node ID used in
        the
   <code class="filename">
    config.ini
   </code>
   file for this node; if none
        is specified, the node ID that would be assigned automatically
        to this node is displayed.
  </p>
  <p>
   The
   <code class="literal">
    node_type
   </code>
   column displays one of the
        following three values:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       MGM
      </code>
      : Management node.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NDB
      </code>
      : Data node.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       API
      </code>
      : API node; this includes SQL nodes.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <code class="literal">
    node_hostname
   </code>
   column shows the node host
        as specified in the
   <code class="filename">
    config.ini
   </code>
   file. This
        can be empty for an API node, if
   <a class="link" href="mysql-cluster-api-definition.html#ndbparam-api-hostname">
    <code class="literal">
     HostName
    </code>
   </a>
   has not been set
        in the cluster configuration file. If
   <a class="link" href="mysql-cluster-ndbd-definition.html#ndbparam-ndbd-hostname">
    <code class="literal">
     HostName
    </code>
   </a>
   has not been
        set for a data node in the configuration file,
   <code class="literal">
    localhost
   </code>
   is used here.
   <code class="literal">
    localhost
   </code>
   is also used if
   <a class="link" href="mysql-cluster-mgm-definition.html#ndbparam-mgmd-hostname">
    <code class="literal">
     HostName
    </code>
   </a>
   has not been
        specified for a management node.
  </p>
 </div>
 <br/>
</div>
