<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-config">
      </a>
      25.5.7 ndb_config — Extract NDB Cluster Configuration Information
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045105514512">
  </a>
  <p>
   This tool extracts current configuration information for data
        nodes, SQL nodes, and API nodes from one of a number of sources:
        an NDB Cluster management node, or its
   <code class="filename">
    config.ini
   </code>
   or
   <code class="filename">
    my.cnf
   </code>
   file. By default, the management node is the source for the
        configuration data; to override the default, execute ndb_config
        with the
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_config-file">
    <code class="option">
     --config-file
    </code>
   </a>
   or
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_mycnf">
    <code class="option">
     --mycnf
    </code>
   </a>
   option. It is also
        possible to use a data node as the source by specifying its node
        ID with
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_config_from_node">
    <code class="option">
     --config_from_node=
     <em class="replaceable">
      <code>
       node_id
      </code>
     </em>
    </code>
   </a>
   .
  </p>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
    <span class="command">
     <strong>
      ndb_config
     </strong>
    </span>
   </a>
   can also provide an offline dump
        of all configuration parameters which can be used, along with
        their default, maximum, and minimum values and other
        information. The dump can be produced in either text or XML
        format; for more information, see the discussion of the
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_configinfo">
    <code class="option">
     --configinfo
    </code>
   </a>
   and
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_xml">
    <code class="option">
     --xml
    </code>
   </a>
   options later in this
        section).
  </p>
  <p>
   You can filter the results by section (
   <code class="literal">
    DB
   </code>
   ,
   <code class="literal">
    SYSTEM
   </code>
   , or
   <code class="literal">
    CONNECTIONS
   </code>
   )
        using one of the options
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_nodes">
    <code class="option">
     --nodes
    </code>
   </a>
   ,
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_system">
    <code class="option">
     --system
    </code>
   </a>
   , or
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_connections">
    <code class="option">
     --connections
    </code>
   </a>
   .
  </p>
  <p>
   All options that can be used with
   <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
    <span class="command">
     <strong>
      ndb_config
     </strong>
    </span>
   </a>
   are shown in the following table. Additional descriptions follow
        the table.
  </p>
  <p>
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_ndb_config_character-sets-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_character-sets-dir">
       <code class="option">
        --character-sets-dir
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105492816">
     </a>
     <a class="indexterm" name="idm46045105491360">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for character-sets-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --character-sets-dir=path
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Directory containing character sets.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_cluster-config-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_cluster-config-suffix">
       <code class="option">
        cluster-config-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105481504">
     </a>
     <a class="indexterm" name="idm46045105480048">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for cluster-config-suffix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --cluster-config-suffix=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Override defaults group suffix when reading cluster
            configuration sections in
      <code class="filename">
       my.cnf
      </code>
      ; used
            in testing.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_configinfo">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_configinfo">
       <code class="option">
        --configinfo
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105465088">
     </a>
     <a class="indexterm" name="idm46045105463600">
     </a>
     <p>
      The
      <code class="option">
       --configinfo
      </code>
      option causes
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      to dump a list of each NDB
            Cluster configuration parameter supported by the NDB Cluster
            distribution of which
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      is a
            part, including the following information:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         A brief description of each parameter's purpose,
                effects, and usage
        </p>
       </li>
       <li class="listitem">
        <p>
         The section of the
         <code class="filename">
          config.ini
         </code>
         file
                where the parameter may be used
        </p>
       </li>
       <li class="listitem">
        <p>
         The parameter's data type or unit of measurement
        </p>
       </li>
       <li class="listitem">
        <p>
         Where applicable, the parameter's default, minimum,
                and maximum values
        </p>
       </li>
       <li class="listitem">
        <p>
         NDB Cluster release version and build information
        </p>
       </li>
      </ul>
     </div>
     <p>
      By default, this output is in text format. Part of this
            output is shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa64070203"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">ndb_config</span> <span class="token property">--configinfo</span>

****** SYSTEM ******

Name <span class="token punctuation">(</span>String<span class="token punctuation">)</span>
Name of system <span class="token punctuation">(</span>NDB Cluster<span class="token punctuation">)</span>
MANDATORY

PrimaryMGMNode <span class="token punctuation">(</span>Non-negative Integer<span class="token punctuation">)</span>
Node id of Primary ndb_mgmd<span class="token punctuation">(</span>MGM<span class="token punctuation">)</span> node
Default<span class="token punctuation">:</span> 0 <span class="token punctuation">(</span>Min<span class="token punctuation">:</span> 0<span class="token punctuation">,</span> Max<span class="token punctuation">:</span> 4294967039<span class="token punctuation">)</span>

ConfigGenerationNumber <span class="token punctuation">(</span>Non-negative Integer<span class="token punctuation">)</span>
Configuration generation number
Default<span class="token punctuation">:</span> 0 <span class="token punctuation">(</span>Min<span class="token punctuation">:</span> 0<span class="token punctuation">,</span> Max<span class="token punctuation">:</span> 4294967039<span class="token punctuation">)</span>

****** DB ******

MaxNoOfSubscriptions <span class="token punctuation">(</span>Non-negative Integer<span class="token punctuation">)</span>
Max no of subscriptions <span class="token punctuation">(</span>default 0 <span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">=</span></span> MaxNoOfTables<span class="token punctuation">)</span>
Default<span class="token punctuation">:</span> 0 <span class="token punctuation">(</span>Min<span class="token punctuation">:</span> 0<span class="token punctuation">,</span> Max<span class="token punctuation">:</span> 4294967039<span class="token punctuation">)</span>

MaxNoOfSubscribers <span class="token punctuation">(</span>Non-negative Integer<span class="token punctuation">)</span>
Max no of subscribers <span class="token punctuation">(</span>default 0 <span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">=</span></span> 2 * MaxNoOfTables<span class="token punctuation">)</span>
Default<span class="token punctuation">:</span> 0 <span class="token punctuation">(</span>Min<span class="token punctuation">:</span> 0<span class="token punctuation">,</span> Max<span class="token punctuation">:</span> 4294967039<span class="token punctuation">)</span>

…</code></pre>
     </div>
     <p>
      Use this option together with the
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_xml">
       <code class="option">
        --xml
       </code>
      </a>
      option to obtain
            output in XML format.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_config-binary-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_config-binary-file">
       <code class="option">
        --config-binary-file=
        <em class="replaceable">
         <code>
          path-to-file
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105445680">
     </a>
     <a class="indexterm" name="idm46045105444224">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for config-binary-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --config-binary-file=path/to/file
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Gives the path to the management server's cached binary
            configuration file
            (
      <code class="filename">
       ndb_
       <em class="replaceable">
        <code>
         nodeID
        </code>
       </em>
       _config.bin.
       <em class="replaceable">
        <code>
         seqno
        </code>
       </em>
      </code>
      ).
            This may be a relative or absolute path. If the management
            server and the
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      binary used
            reside on different hosts, you must use an absolute path.
     </p>
     <p>
      This example demonstrates combining
      <code class="option">
       --config-binary-file
      </code>
      with other
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      options to obtain useful
            output:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa41322807"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">ndb_config</span> <span class="token constant">--config-binary-file</span><span class="token attr-value"><span class="token punctuation">=</span>../mysql-cluster/ndb_50_config.bin.1</span> <span class="token property">--diff-default</span> <span class="token constant">--type</span><span class="token attr-value"><span class="token punctuation">=</span>ndbd</span>
config of <span class="token property"><span class="token punctuation">[</span>DB<span class="token punctuation">]</span></span> node id 5 that is different from default 
CONFIG_PARAMETER<span class="token punctuation">,</span>ACTUAL_VALUE<span class="token punctuation">,</span>DEFAULT_VALUE 
NodeId<span class="token punctuation">,</span>5<span class="token punctuation">,</span><span class="token punctuation">(</span>mandatory<span class="token punctuation">)</span> 
BackupDataDir<span class="token punctuation">,</span>/local/data/8<span class="token punctuation">.</span>4<span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span> 
DataDir<span class="token punctuation">,</span>/local/data/8<span class="token punctuation">.</span>4<span class="token punctuation">,</span><span class="token punctuation">.</span> 
DataMemory<span class="token punctuation">,</span>2G<span class="token punctuation">,</span>98M 
FileSystemPath<span class="token punctuation">,</span>/local/data/8<span class="token punctuation">.</span>4<span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span> 
HostName<span class="token punctuation">,</span>127<span class="token punctuation">.</span>0<span class="token punctuation">.</span>0<span class="token punctuation">.</span>1<span class="token punctuation">,</span>localhost 
Nodegroup<span class="token punctuation">,</span>0<span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span> 
ThreadConfig<span class="token punctuation">,</span><span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span> 

config of <span class="token property"><span class="token punctuation">[</span>DB<span class="token punctuation">]</span></span> node id 6 that is different from default 
CONFIG_PARAMETER<span class="token punctuation">,</span>ACTUAL_VALUE<span class="token punctuation">,</span>DEFAULT_VALUE 
NodeId<span class="token punctuation">,</span>6<span class="token punctuation">,</span><span class="token punctuation">(</span>mandatory<span class="token punctuation">)</span> 
BackupDataDir<span class="token punctuation">,</span>/local/data/8<span class="token punctuation">.</span>4<span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span> 
DataDir<span class="token punctuation">,</span>/local/data/8<span class="token punctuation">.</span>4<span class="token punctuation">.</span> 
DataMemory<span class="token punctuation">,</span>2G<span class="token punctuation">,</span>98M 
FileSystemPath<span class="token punctuation">,</span>/local/data/8<span class="token punctuation">.</span>4<span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span> 
HostName<span class="token punctuation">,</span>127<span class="token punctuation">.</span>0<span class="token punctuation">.</span>0<span class="token punctuation">.</span>1<span class="token punctuation">,</span>localhost 
Nodegroup<span class="token punctuation">,</span>0<span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span> 
ThreadConfig<span class="token punctuation">,</span><span class="token punctuation">,</span><span class="token punctuation">(</span>null<span class="token punctuation">)</span>

<span class="token prompt">$&gt; </span><span class="token command">ndb_config</span> <span class="token constant">--config-binary-file</span><span class="token attr-value"><span class="token punctuation">=</span>../mysql-cluster/ndb_50_config.bin.1</span> <span class="token property">--diff-default</span> <span class="token property">--system</span>
config of <span class="token property"><span class="token punctuation">[</span>SYSTEM<span class="token punctuation">]</span></span> system 
CONFIG_PARAMETER<span class="token punctuation">,</span>ACTUAL_VALUE<span class="token punctuation">,</span>DEFAULT_VALUE 
Name<span class="token punctuation">,</span>MC_20220906060042<span class="token punctuation">,</span><span class="token punctuation">(</span>mandatory<span class="token punctuation">)</span> 
ConfigGenerationNumber<span class="token punctuation">,</span>1<span class="token punctuation">,</span>0 
PrimaryMGMNode<span class="token punctuation">,</span>50<span class="token punctuation">,</span>0</code></pre>
     </div>
     <p>
      The relevant portions of the
      <code class="filename">
       config.ini
      </code>
      file are shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa41789182"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-ini"><span class="token selector">[ndbd default]</span>
<span class="token constant">DataMemory</span><span class="token attr-value"><span class="token punctuation">=</span> 2G</span>
<span class="token constant">NoOfReplicas</span><span class="token attr-value"><span class="token punctuation">=</span> 2</span>

<span class="token selector">[ndb_mgmd]</span>
<span class="token constant">NodeId</span><span class="token attr-value"><span class="token punctuation">=</span> 50</span>
<span class="token constant">HostName</span><span class="token attr-value"><span class="token punctuation">=</span> 127.0.0.1</span>

<span class="token selector">[ndbd]</span>
<span class="token constant">NodeId</span><span class="token attr-value"><span class="token punctuation">=</span> 5</span>
<span class="token constant">HostName</span><span class="token attr-value"><span class="token punctuation">=</span> 127.0.0.1</span>
<span class="token constant">DataDir</span><span class="token attr-value"><span class="token punctuation">=</span> /local/data/8.4</span>

<span class="token selector">[ndbd]</span>
<span class="token constant">NodeId</span><span class="token attr-value"><span class="token punctuation">=</span> 6</span>
<span class="token constant">HostName</span><span class="token attr-value"><span class="token punctuation">=</span> 127.0.0.1</span>
<span class="token constant">DataDir</span><span class="token attr-value"><span class="token punctuation">=</span> /local/data/8.4</span></code></pre>
     </div>
     <p>
      By comparing the output with the configuration file, you can
            see that all of the settings in the file have been written
            by the management server to the binary cache, and thus,
            applied to the cluster.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_config-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_config-file">
       <code class="option">
        --config-file=
        <em class="replaceable">
         <code>
          path-to-file
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105416992">
     </a>
     <a class="indexterm" name="idm46045105415504">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for config-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --config-file=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Gives the path to the cluster configuration file
            (
      <code class="filename">
       config.ini
      </code>
      ). This may be a relative or
            absolute path. If the management server and the
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      binary used reside on
            different hosts, you must use an absolute path.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_config_from_node">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_config_from_node">
       <code class="option">
        --config_from_node=#
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105399408">
     </a>
     <a class="indexterm" name="idm46045105397920">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for config_from_node">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --config-from-node=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           none
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           48
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Obtain the cluster's configuration data from the data
            node that has this ID.
     </p>
     <p>
      If the node having this ID is not a data node,
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      fails with an error. (To
            obtain configuration data from the management node instead,
            simply omit this option.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_connect-retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_connect-retries">
       <code class="option">
        --connect-retries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105376880">
     </a>
     <a class="indexterm" name="idm46045105375392">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retries">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retries=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           12
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           12
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of times to retry connection before giving up.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_connect-retry-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_connect-retry-delay">
       <code class="option">
        --connect-retry-delay
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105356368">
     </a>
     <a class="indexterm" name="idm46045105354912">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retry-delay">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retry-delay=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           5
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           5
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of seconds to wait between attempts to contact
            management server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_connect-string">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_connect-string">
       <code class="option">
        --connect-string
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105335792">
     </a>
     <a class="indexterm" name="idm46045105334304">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-string">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-string=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_connections">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_connections">
       <code class="option">
        --connections
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105319232">
     </a>
     <a class="indexterm" name="idm46045105317744">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connections">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connections
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Tells
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      to print
      <code class="literal">
       CONNECTIONS
      </code>
      information only—that
            is, information about parameters found in the
      <code class="literal">
       [tcp]
      </code>
      ,
      <code class="literal">
       [tcp default]
      </code>
      ,
      <code class="literal">
       [shm]
      </code>
      , or
      <code class="literal">
       [shm
            default]
      </code>
      sections of the cluster configuration
            file (see
      <a class="xref" href="mysql-cluster-tcp-definition.html" title="25.4.3.10 NDB Cluster TCP/IP Connections">
       Section 25.4.3.10, “NDB Cluster TCP/IP Connections”
      </a>
      ,
            and
      <a class="xref" href="mysql-cluster-shm-definition.html" title="25.4.3.12 NDB Cluster Shared-Memory Connections">
       Section 25.4.3.12, “NDB Cluster Shared-Memory Connections”
      </a>
      , for more
            information).
     </p>
     <p>
      This option is mutually exclusive with
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_nodes">
       <code class="option">
        --nodes
       </code>
      </a>
      and
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_system">
       <code class="option">
        --system
       </code>
      </a>
      ; only one of
            these 3 options can be used.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_core-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_core-file">
       <code class="option">
        --core-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105299040">
     </a>
     <a class="indexterm" name="idm46045105297552">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for core-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --core-file
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Write core file on error; used in debugging.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_defaults-extra-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_defaults-extra-file">
       <code class="option">
        --defaults-extra-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105287712">
     </a>
     <a class="indexterm" name="idm46045105286256">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-extra-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-extra-file=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read given file after global files are read.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_defaults-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105271904">
     </a>
     <a class="indexterm" name="idm46045105270416">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-file=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read default options from given file only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105256144">
     </a>
     <a class="indexterm" name="idm46045105254688">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-group-suffix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-group-suffix=string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Also read groups with concat(group, suffix).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_diff-default">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_diff-default">
       <code class="option">
        --diff-default
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105240400">
     </a>
     <a class="indexterm" name="idm46045105238912">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for diff-default">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --diff-default
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Print only configuration parameters that have non-default
            values.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_fields">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_fields">
       <code class="option">
        --fields=
        <em class="replaceable">
         <code>
          delimiter
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -f
      </code>
      <em class="replaceable">
       <code>
        delimiter
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045105228048">
     </a>
     <a class="indexterm" name="idm46045105226560">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for fields">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --fields=string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specifies a
      <em class="replaceable">
       <code>
        delimiter
       </code>
      </em>
      string used
            to separate the fields in the result. The default is
      <code class="literal">
       ,
      </code>
      (the comma character).
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       If the
       <em class="replaceable">
        <code>
         delimiter
        </code>
       </em>
       contains
              spaces or escapes (such as
       <code class="literal">
        \n
       </code>
       for the
              linefeed character), then it must be quoted.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_help">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_help">
       <code class="option">
        --help
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105209344">
     </a>
     <a class="indexterm" name="idm46045105207856">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for help">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --help
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display help text and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_host">
       <code class="option">
        --host=
        <em class="replaceable">
         <code>
          hostname
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105197888">
     </a>
     <a class="indexterm" name="idm46045105196400">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for host">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --host=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specifies the host name of the node for which configuration
            information is to be obtained.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       While the hostname
       <code class="literal">
        localhost
       </code>
       usually
              resolves to the IP address
       <code class="literal">
        127.0.0.1
       </code>
       ,
              this may not necessarily be true for all operating
              platforms and configurations. This means that it is
              possible, when
       <code class="literal">
        localhost
       </code>
       is used in
       <code class="filename">
        config.ini
       </code>
       , for
       <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
        <span class="command">
         <strong>
          ndb_config
          <code class="option">
           --host=localhost
          </code>
         </strong>
        </span>
       </a>
       to fail if
       <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
        <span class="command">
         <strong>
          ndb_config
         </strong>
        </span>
       </a>
       is run on a different host
              where
       <code class="literal">
        localhost
       </code>
       resolves to a different
              address (for example, on some versions of SUSE Linux, this
              is
       <code class="literal">
        127.0.0.2
       </code>
       ). In general, for best
              results, you should use numeric IP addresses for all NDB
              Cluster configuration values relating to hosts, or verify
              that all NDB Cluster hosts handle
       <code class="literal">
        localhost
       </code>
       in the same fashion.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_login-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105172944">
     </a>
     <a class="indexterm" name="idm46045105171456">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for login-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --login-path=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read given path from login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_mycnf">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_mycnf">
       <code class="option">
        --mycnf
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105157408">
     </a>
     <a class="indexterm" name="idm46045105155920">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mycnf">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mycnf
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read configuration data from the
      <code class="filename">
       my.cnf
      </code>
      file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_ndb-connectstring">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-connectstring">
       <code class="option">
        --ndb-connectstring=
        <em class="replaceable">
         <code>
          connection_string
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -c
       <em class="replaceable">
        <code>
         connection_string
        </code>
       </em>
      </code>
     </p>
     <a class="indexterm" name="idm46045105144544">
     </a>
     <a class="indexterm" name="idm46045105143088">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-connectstring">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-connectstring=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specifies the connection string to use in connecting to the
            management server. The format for the connection string is
            the same as described in
      <a class="xref" href="mysql-cluster-connection-strings.html" title="25.4.3.3 NDB Cluster Connection Strings">
       Section 25.4.3.3, “NDB Cluster Connection Strings”
      </a>
      , and
            defaults to
      <code class="literal">
       localhost:1186
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_ndb-mgm-tls">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-mgm-tls">
       <code class="option">
        --ndb-mgm-tls
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105127168">
     </a>
     <a class="indexterm" name="idm46045105125680">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgm-tls">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgm-tls=level
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           relaxed
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            relaxed
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            strict
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Sets the level of TLS support required to connect to the
            management server; one of
      <code class="literal">
       relaxed
      </code>
      or
      <code class="literal">
       strict
      </code>
      .
      <code class="literal">
       relaxed
      </code>
      (the
            default) means that a TLS connection is attempted, but
            success is not required;
      <code class="literal">
       strict
      </code>
      means
            that TLS is required to connect.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_ndb-mgmd-host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-mgmd-host">
       <code class="option">
        --ndb-mgmd-host
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105104624">
     </a>
     <a class="indexterm" name="idm46045105103136">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgmd-host">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgmd-host=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_ndb-nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-nodeid">
       <code class="option">
        --ndb-nodeid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105087952">
     </a>
     <a class="indexterm" name="idm46045105086464">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-nodeid">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-nodeid=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set node ID for this node, overriding any ID set by
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_ndb-optimized-node-selection">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-optimized-node-selection">
       <code class="option">
        --ndb-optimized-node-selection
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105071152">
     </a>
     <a class="indexterm" name="idm46045105069648">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-optimized-node-selection">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-optimized-node-selection
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Enable optimizations for selection of nodes for
            transactions. Enabled by default; use
      <code class="option">
       --skip-ndb-optimized-node-selection
      </code>
      to
            disable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_ndb-tls-search-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_ndb-tls-search-path">
       <code class="option">
        --ndb-tls-search-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105059296">
     </a>
     <a class="indexterm" name="idm46045105057840">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-tls-search-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-tls-search-path=list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Path name
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Unix)
         </th>
         <td>
          <code class="literal">
           $HOME/ndb-tls
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Windows)
         </th>
         <td>
          <code class="literal">
           $HOMEDIR/ndb-tls
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specify a list of directories to search for a CA file. On
            Unix platforms, the directory names are separated by colons
            (
      <code class="literal">
       :
      </code>
      ); on Windows systems, the semicolon
            character (
      <code class="literal">
       ;
      </code>
      ) is used as the separator. A
            directory reference may be relative or absolute; it may
            contain one or more environment variables, each denoted by a
            prefixed dollar sign (
      <code class="literal">
       $
      </code>
      ), and expanded
            prior to use.
     </p>
     <p>
      Searching begins with the leftmost named directory and
            proceeds from left to right until a file is found. An empty
            string denotes an empty search path, which causes all
            searches to fail. A string consisting of a single dot
            (
      <code class="literal">
       .
      </code>
      ) indicates that the search path
            limited to the current working directory.
     </p>
     <p>
      If no search path is supplied, the compiled-in default value
            is used. This value depends on the platform used: On
            Windows, this is
      <code class="literal">
       \ndb-tls
      </code>
      ; on other
            platforms (including Linux), it is
      <code class="literal">
       $HOME/ndb-tls
      </code>
      . This can be overridden by
            compiling NDB Cluster using
      <a class="link" href="source-configuration-options.html#option_cmake_with_ndb_tls_search_path">
       <code class="option">
        -DWITH_NDB_TLS_SEARCH_PATH
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_no-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105034080">
     </a>
     <a class="indexterm" name="idm46045105032592">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Do not read default options from any option file other than
            login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_no-login-paths">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105022768">
     </a>
     <a class="indexterm" name="idm46045105021280">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-login-paths">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-login-paths
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Skips reading options from the login path file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_nodeid">
       <code class="option">
        --nodeid=
        <em class="replaceable">
         <code>
          node_id
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105011280">
     </a>
     <a class="indexterm" name="idm46045105009792">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-nodeid">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-nodeid=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specify the node ID of the node for which configuration
            information is to be obtained.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_nodes">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_nodes">
       <code class="option">
        --nodes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104995744">
     </a>
     <a class="indexterm" name="idm46045104994256">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for nodes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --nodes
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Tells
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      to print information
            relating only to parameters defined in an
      <code class="literal">
       [ndbd]
      </code>
      or
      <code class="literal">
       [ndbd
            default]
      </code>
      section of the cluster configuration file
            (see
      <a class="xref" href="mysql-cluster-ndbd-definition.html" title="25.4.3.6 Defining NDB Cluster Data Nodes">
       Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
      </a>
      ).
     </p>
     <p>
      This option is mutually exclusive with
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_connections">
       <code class="option">
        --connections
       </code>
      </a>
      and
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_system">
       <code class="option">
        --system
       </code>
      </a>
      ; only one of
            these 3 options can be used.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_print-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104978512">
     </a>
     <a class="indexterm" name="idm46045104977024">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for print-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --print-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Print program argument list and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_query">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_query">
       <code class="option">
        --query=
        <em class="replaceable">
         <code>
          query-options
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -q
      </code>
      <em class="replaceable">
       <code>
        query-options
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045104966240">
     </a>
     <a class="indexterm" name="idm46045104964752">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for query">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --query=string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      This is a comma-delimited list of
      <span class="firstterm">
       query
            options
      </span>
      —that is, a list of one or more node
            attributes to be returned. These include
      <code class="literal">
       nodeid
      </code>
      (node ID), type (node
            type—that is,
      <code class="literal">
       ndbd
      </code>
      ,
      <code class="literal">
       mysqld
      </code>
      , or
      <code class="literal">
       ndb_mgmd
      </code>
      ),
            and any configuration parameters whose values are to be
            obtained.
     </p>
     <p>
      For example,
      <code class="option">
       --query=nodeid,type,datamemory,datadir
      </code>
      returns the node ID, node type,
      <a class="link" href="mysql-cluster-ndbd-definition.html#ndbparam-ndbd-datamemory">
       <code class="literal">
        DataMemory
       </code>
      </a>
      , and
      <a class="link" href="mysql-cluster-ndbd-definition.html#ndbparam-ndbd-datadir">
       <code class="literal">
        DataDir
       </code>
      </a>
      for each
            node.
     </p>
     <a class="indexterm" name="idm46045104945632">
     </a>
     <a class="indexterm" name="idm46045104944144">
     </a>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       If a given parameter is not applicable to a certain type
              of node, than an empty string is returned for the
              corresponding value. See the examples later in this
              section for more information.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_query-all">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_query-all">
       <code class="option">
        --query-all
       </code>
      </a>
      ,
      <code class="option">
       -a
      </code>
     </p>
     <a class="indexterm" name="idm46045104938784">
     </a>
     <a class="indexterm" name="idm46045104937296">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for query-all">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --query-all
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Returns a comma-delimited list of all query options (node
            attributes; note that this list is a single string.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_rows">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_rows">
       <code class="option">
        --rows=
        <em class="replaceable">
         <code>
          separator
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -r
      </code>
      <em class="replaceable">
       <code>
        separator
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045104922144">
     </a>
     <a class="indexterm" name="idm46045104920656">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for rows">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --rows=string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specifies a
      <em class="replaceable">
       <code>
        separator
       </code>
      </em>
      string used
            to separate the rows in the result. The default is a space
            character.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       If the
       <em class="replaceable">
        <code>
         separator
        </code>
       </em>
       contains
              spaces or escapes (such as
       <code class="literal">
        \n
       </code>
       for the
              linefeed character), then it must be quoted.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_system">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_system">
       <code class="option">
        --system
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104904144">
     </a>
     <a class="indexterm" name="idm46045104902656">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for system">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --system
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Tells
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      to print
      <code class="literal">
       SYSTEM
      </code>
      information only. This consists of
            system variables that cannot be changed at run time; thus,
            there is no corresponding section of the cluster
            configuration file for them. They can be seen (prefixed with
      <code class="literal">
       ****** SYSTEM ******
      </code>
      ) in the output of
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_configinfo">
       <code class="option">
        --configinfo
       </code>
      </a>
      .
     </p>
     <p>
      This option is mutually exclusive with
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_nodes">
       <code class="option">
        --nodes
       </code>
      </a>
      and
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_connections">
       <code class="option">
        --connections
       </code>
      </a>
      ; only one
            of these 3 options can be used.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_type">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_type">
       <code class="option">
        --type=
        <em class="replaceable">
         <code>
          node_type
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104885120">
     </a>
     <a class="indexterm" name="idm46045104883632">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for type">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --type=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            ndbd
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            mysqld
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            ndb_mgmd
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Filters results so that only configuration values applying
            to nodes of the specified
      <em class="replaceable">
       <code>
        node_type
       </code>
      </em>
      (
      <code class="literal">
       ndbd
      </code>
      ,
      <code class="literal">
       mysqld
      </code>
      , or
      <code class="literal">
       ndb_mgmd
      </code>
      ) are returned.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_usage">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_usage">
       <code class="option">
        --usage
       </code>
      </a>
      ,
      <code class="option">
       --help
      </code>
      , or
      <code class="option">
       -?
      </code>
     </p>
     <a class="indexterm" name="idm46045104861216">
     </a>
     <a class="indexterm" name="idm46045104859728">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for help">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --help
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Causes
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      to print a list of
            available options, and then exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_version">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_version">
       <code class="option">
        --version
       </code>
      </a>
      ,
      <code class="option">
       -V
      </code>
     </p>
     <a class="indexterm" name="idm46045104848224">
     </a>
     <a class="indexterm" name="idm46045104846736">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --version
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Causes
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      to print a version
            information string, and then exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_config_xml">
      </a>
      <code class="option">
       --configinfo
      </code>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_xml">
       <code class="option">
        --xml
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104835504">
     </a>
     <a class="indexterm" name="idm46045104834016">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for xml">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --configinfo --xml
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Cause
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_configinfo">
       <code class="option">
        --configinfo
       </code>
      </a>
      to provide
            output as XML by adding this option. A portion of such
            output is shown in this example:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa13533404"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">ndb_config</span> <span class="token property">--configinfo</span> <span class="token property">--xml</span>

&lt;configvariables protocolversion=<span class="token atrule">"1"</span> ndbversionstring=<span class="token atrule">"5.7.44-ndb-7.5.36"</span>
                    ndbversion=<span class="token atrule">"460032"</span> ndbversionmajor=<span class="token atrule">"7"</span> ndbversionminor=<span class="token atrule">"5"</span>
                    ndbversionbuild=<span class="token atrule">"0"</span>&gt;
  &lt;section name=<span class="token atrule">"SYSTEM"</span>&gt;
    &lt;param name=<span class="token atrule">"Name"</span> comment=<span class="token atrule">"Name of system (NDB Cluster)"</span> type=<span class="token atrule">"string"</span>
              mandatory=<span class="token atrule">"true"</span>/&gt;
    &lt;param name=<span class="token atrule">"PrimaryMGMNode"</span> comment=<span class="token atrule">"Node id of Primary ndb_mgmd(MGM) node"</span>
              type=<span class="token atrule">"unsigned"</span> default=<span class="token atrule">"0"</span> min=<span class="token atrule">"0"</span> max=<span class="token atrule">"4294967039"</span>/&gt;
    &lt;param name=<span class="token atrule">"ConfigGenerationNumber"</span> comment=<span class="token atrule">"Configuration generation number"</span>
              type=<span class="token atrule">"unsigned"</span> default=<span class="token atrule">"0"</span> min=<span class="token atrule">"0"</span> max=<span class="token atrule">"4294967039"</span>/&gt;
  &lt;/section&gt;
  &lt;section name=<span class="token atrule">"MYSQLD"</span> primarykeys=<span class="token atrule">"NodeId"</span>&gt;
    &lt;param name=<span class="token atrule">"wan"</span> comment=<span class="token atrule">"Use WAN TCP setting as default"</span> type=<span class="token atrule">"bool"</span>
              default=<span class="token atrule">"false"</span>/&gt;
    &lt;param name=<span class="token atrule">"HostName"</span> comment=<span class="token atrule">"Name of computer for this node"</span>
              type=<span class="token atrule">"string"</span> default=<span class="token atrule">""</span>/&gt;
    &lt;param name=<span class="token atrule">"Id"</span> comment=<span class="token atrule">"NodeId"</span> type=<span class="token atrule">"unsigned"</span> mandatory=<span class="token atrule">"true"</span>
              min=<span class="token atrule">"1"</span> max=<span class="token atrule">"255"</span> deprecated=<span class="token atrule">"true"</span>/&gt;
    &lt;param name=<span class="token atrule">"NodeId"</span> comment=<span class="token atrule">"Number identifying application node (mysqld(API))"</span>
              type=<span class="token atrule">"unsigned"</span> mandatory=<span class="token atrule">"true"</span> min=<span class="token atrule">"1"</span> max=<span class="token atrule">"255"</span>/&gt;
    &lt;param name=<span class="token atrule">"ExecuteOnComputer"</span> comment=<span class="token atrule">"HostName"</span> type=<span class="token atrule">"string"</span>
              deprecated=<span class="token atrule">"true"</span>/&gt;

    …

  &lt;/section&gt;

  …

&lt;/configvariables&gt;</code></pre>
     </div>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       Normally, the XML output produced by
       <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
        <span class="command">
         <strong>
          ndb_config
         </strong>
        </span>
       </a>
       <code class="option">
        --configinfo
       </code>
       <code class="option">
        --xml
       </code>
       is
              formatted using one line per element; we have added extra
              whitespace in the previous example, as well as the next
              one, for reasons of legibility. This should not make any
              difference to applications using this output, since most
              XML processors either ignore nonessential whitespace as a
              matter of course, or can be instructed to do so.
      </p>
     </div>
     <p>
      The XML output also indicates when changing a given
            parameter requires that data nodes be restarted using the
      <a class="link" href="mysql-cluster-programs-ndbd.html#option_ndbd_initial">
       <code class="option">
        --initial
       </code>
      </a>
      option. This is shown
            by the presence of an
      <code class="literal">
       initial="true"
      </code>
      attribute in the corresponding
      <code class="literal">
       &lt;param&gt;
      </code>
      element. In addition, the
            restart type (
      <code class="literal">
       system
      </code>
      or
      <code class="literal">
       node
      </code>
      ) is also shown; if a given parameter
            requires a system restart, this is indicated by the presence
            of a
      <code class="literal">
       restart="system"
      </code>
      attribute in the
            corresponding
      <code class="literal">
       &lt;param&gt;
      </code>
      element. For
            example, changing the value set for the
      <a class="link" href="mysql-cluster-ndbd-definition.html#ndbparam-ndbd-diskless">
       <code class="literal">
        Diskless
       </code>
      </a>
      parameter
            requires a system initial restart, as shown here (with the
      <code class="literal">
       restart
      </code>
      and
      <code class="literal">
       initial
      </code>
      attributes highlighted for visibility):
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-xml"><div class="docs-select-all right" id="sa11538081"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-xml"><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>param</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>Diskless<span class="token punctuation">"</span></span> <span class="token attr-name">comment</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>Run wo/ disk<span class="token punctuation">"</span></span> <span class="token attr-name">type</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>bool<span class="token punctuation">"</span></span> <span class="token attr-name">default</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>false<span class="token punctuation">"</span></span>
          <span class="token attr-name"></span><em><span class="token attr-name">restart</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>system<span class="token punctuation">"</span></span> <span class="token attr-name">initial</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>true<span class="token punctuation">"</span></span></em><span class="token attr-value"><span class="token punctuation"></span></span><span class="token punctuation">/&gt;</span></span></code></pre>
     </div>
     <p>
      Currently, no
      <code class="literal">
       initial
      </code>
      attribute is
            included in the XML output for
      <code class="literal">
       &lt;param&gt;
      </code>
      elements corresponding to
            parameters which do not require initial restarts; in other
            words,
      <code class="literal">
       initial="false"
      </code>
      is the default,
            and the value
      <code class="literal">
       false
      </code>
      should be assumed if
            the attribute is not present. Similarly, the default restart
            type is
      <code class="literal">
       node
      </code>
      (that is, an online or
      <span class="quote">
       “
       <span class="quote">
        rolling
       </span>
       ”
      </span>
      restart of the cluster), but the
      <code class="literal">
       restart
      </code>
      attribute is included only if the
            restart type is
      <code class="literal">
       system
      </code>
      (meaning that all
            cluster nodes must be shut down at the same time, then
            restarted).
     </p>
     <p>
      Deprecated parameters are indicated in the XML output by the
      <code class="literal">
       deprecated
      </code>
      attribute, as shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-xml"><div class="docs-select-all right" id="sa52301452"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-xml"><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>param</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>NoOfDiskPagesToDiskAfterRestartACC<span class="token punctuation">"</span></span> <span class="token attr-name">comment</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>DiskCheckpointSpeed<span class="token punctuation">"</span></span>
       <span class="token attr-name">type</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>unsigned<span class="token punctuation">"</span></span> <span class="token attr-name">default</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>20<span class="token punctuation">"</span></span> <span class="token attr-name">min</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>1<span class="token punctuation">"</span></span> <span class="token attr-name">max</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>4294967039<span class="token punctuation">"</span></span> <span class="token attr-name"></span><em><span class="token attr-name">deprecated</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>true<span class="token punctuation">"</span></span></em><span class="token attr-value"><span class="token punctuation"></span></span><span class="token punctuation">/&gt;</span></span></code></pre>
     </div>
     <p>
      In such cases, the
      <code class="literal">
       comment
      </code>
      refers to one
            or more parameters that supersede the deprecated parameter.
            Similarly to
      <code class="literal">
       initial
      </code>
      , the
      <code class="literal">
       deprecated
      </code>
      attribute is indicated only
            when the parameter is deprecated, with
      <code class="literal">
       deprecated="true"
      </code>
      , and does not appear at
            all for parameters which are not deprecated. (Bug #21127135)
     </p>
     <p>
      Parameters that are required are indicated with
      <code class="literal">
       mandatory="true"
      </code>
      , as shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-xml"><div class="docs-select-all right" id="sa98634153"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-xml"><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>param</span> <span class="token attr-name">name</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>NodeId<span class="token punctuation">"</span></span>
          <span class="token attr-name">comment</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>Number identifying application node (mysqld(API))<span class="token punctuation">"</span></span>
          <span class="token attr-name">type</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>unsigned<span class="token punctuation">"</span></span> <span class="token attr-name"></span><em><span class="token attr-name">mandatory</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>true<span class="token punctuation">"</span></span></em><span class="token attr-value"><span class="token punctuation"></span></span> <span class="token attr-name">min</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>1<span class="token punctuation">"</span></span> <span class="token attr-name">max</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>255<span class="token punctuation">"</span></span><span class="token punctuation">/&gt;</span></span></code></pre>
     </div>
     <p>
      In much the same way that the
      <code class="literal">
       initial
      </code>
      or
      <code class="literal">
       deprecated
      </code>
      attribute is displayed only
            for a parameter that requires an initial restart or that is
            deprecated, the
      <code class="literal">
       mandatory
      </code>
      attribute is
            included only if the given parameter is actually required.
     </p>
     <div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Important
      </div>
      <p>
       The
       <code class="option">
        --xml
       </code>
       option can be used only with
              the
       <code class="option">
        --configinfo
       </code>
       option. Using
       <code class="option">
        --xml
       </code>
       without
       <code class="option">
        --configinfo
       </code>
       fails with an error.
      </p>
     </div>
     <p>
      Unlike the options used with this program to obtain current
            configuration data,
      <code class="option">
       --configinfo
      </code>
      and
      <code class="option">
       --xml
      </code>
      use information obtained from the NDB
            Cluster sources when
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      was
            compiled. For this reason, no connection to a running NDB
            Cluster or access to a
      <code class="filename">
       config.ini
      </code>
      or
      <code class="filename">
       my.cnf
      </code>
      file is required for these two
            options.
     </p>
    </li>
   </ul>
  </div>
  <p>
   Combining other
   <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
    <span class="command">
     <strong>
      ndb_config
     </strong>
    </span>
   </a>
   options (such as
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_query">
    <code class="option">
     --query
    </code>
   </a>
   or
   <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_type">
    <code class="option">
     --type
    </code>
   </a>
   ) with
   <code class="option">
    --configinfo
   </code>
   (with or without the
   <code class="option">
    --xml
   </code>
   option is not supported. Currently, if
        you attempt to do so, the usual result is that all other options
        besides
   <code class="option">
    --configinfo
   </code>
   or
   <code class="option">
    --xml
   </code>
   are simply ignored.
   <span class="emphasis">
    <em>
     However, this behavior is not
        guaranteed and is subject to change at any time
    </em>
   </span>
   . In
        addition, since
   <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
    <span class="command">
     <strong>
      ndb_config
     </strong>
    </span>
   </a>
   , when used with
        the
   <code class="option">
    --configinfo
   </code>
   option, does not access the
        NDB Cluster or read any files, trying to specify additional
        options such as
   <code class="option">
    --ndb-connectstring
   </code>
   or
   <code class="option">
    --config-file
   </code>
   with
   <code class="option">
    --configinfo
   </code>
   serves no purpose.
  </p>
  <h4>
   <a name="idm46045104771232">
   </a>
   Examples
  </h4>
  <div class="orderedlist">
   <ol class="orderedlist" type="1">
    <li class="listitem">
     <p>
      To obtain the node ID and type of each node in the cluster:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa31057695"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">./ndb_config</span> <span class="token constant">--query</span><span class="token attr-value"><span class="token punctuation">=</span>nodeid,type</span> <span class="token constant">--fields</span>=<span class="token atrule">':'</span> <span class="token constant">--rows</span>=<span class="token atrule">'\n'</span>
1<span class="token punctuation">:</span>ndbd
2<span class="token punctuation">:</span>ndbd
3<span class="token punctuation">:</span>ndbd
4<span class="token punctuation">:</span>ndbd
5<span class="token punctuation">:</span>ndb_mgmd
6<span class="token punctuation">:</span>mysqld
7<span class="token punctuation">:</span>mysqld
8<span class="token punctuation">:</span>mysqld
9<span class="token punctuation">:</span>mysqld</code></pre>
     </div>
     <p>
      In this example, we used the
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_fields">
       <code class="option">
        --fields
       </code>
      </a>
      options to
            separate the ID and type of each node with a colon character
            (
      <code class="literal">
       :
      </code>
      ), and the
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_rows">
       <code class="option">
        --rows
       </code>
      </a>
      options to place
            the values for each node on a new line in the output.
     </p>
    </li>
    <li class="listitem">
     <p>
      To produce a connection string that can be used by data,
            SQL, and API nodes to connect to the management server:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa41480850"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">./ndb_config</span> <span class="token constant">--config-file</span><span class="token attr-value"><span class="token punctuation">=</span>usr/local/mysql/cluster-data/config.ini</span> \
<span class="token constant">--query</span><span class="token attr-value"><span class="token punctuation">=</span>hostname,portnumber</span> <span class="token constant">--fields</span><span class="token attr-value"><span class="token punctuation">=</span>:</span> <span class="token constant">--rows</span><span class="token attr-value"><span class="token punctuation">=</span>,</span> <span class="token constant">--type</span><span class="token attr-value"><span class="token punctuation">=</span>ndb_mgmd</span>
198<span class="token punctuation">.</span>51<span class="token punctuation">.</span>100<span class="token punctuation">.</span>179<span class="token punctuation">:</span>1186</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      This invocation of
      <a class="link" href="mysql-cluster-programs-ndb-config.html" title="25.5.7 ndb_config — Extract NDB Cluster Configuration Information">
       <span class="command">
        <strong>
         ndb_config
        </strong>
       </span>
      </a>
      checks only
            data nodes (using the
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_type">
       <code class="option">
        --type
       </code>
      </a>
      option), and shows
            the values for each node's ID and host name, as well as
            the values set for its
      <a class="link" href="mysql-cluster-ndbd-definition.html#ndbparam-ndbd-datamemory">
       <code class="literal">
        DataMemory
       </code>
      </a>
      and
      <a class="link" href="mysql-cluster-ndbd-definition.html#ndbparam-ndbd-datadir">
       <code class="literal">
        DataDir
       </code>
      </a>
      parameters:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa78342557"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">./ndb_config</span> <span class="token constant">--type</span><span class="token attr-value"><span class="token punctuation">=</span>ndbd</span> <span class="token constant">--query</span><span class="token attr-value"><span class="token punctuation">=</span>nodeid,host,datamemory,datadir</span> <span class="token property">-f</span> <span class="token atrule">' : '</span> <span class="token property">-r</span> <span class="token atrule">'\n'</span>
1 <span class="token punctuation">:</span> 198<span class="token punctuation">.</span>51<span class="token punctuation">.</span>100<span class="token punctuation">.</span>193 <span class="token punctuation">:</span> 83886080 <span class="token punctuation">:</span> /usr/local/mysql/cluster-data
2 <span class="token punctuation">:</span> 198<span class="token punctuation">.</span>51<span class="token punctuation">.</span>100<span class="token punctuation">.</span>112 <span class="token punctuation">:</span> 83886080 <span class="token punctuation">:</span> /usr/local/mysql/cluster-data
3 <span class="token punctuation">:</span> 198<span class="token punctuation">.</span>51<span class="token punctuation">.</span>100<span class="token punctuation">.</span>176 <span class="token punctuation">:</span> 83886080 <span class="token punctuation">:</span> /usr/local/mysql/cluster-data
4 <span class="token punctuation">:</span> 198<span class="token punctuation">.</span>51<span class="token punctuation">.</span>100<span class="token punctuation">.</span>119 <span class="token punctuation">:</span> 83886080 <span class="token punctuation">:</span> /usr/local/mysql/cluster-data</code></pre>
     </div>
     <p>
      In this example, we used the short options
      <code class="option">
       -f
      </code>
      and
      <code class="option">
       -r
      </code>
      for setting the
            field delimiter and row separator, respectively, as well as
            the short option
      <code class="option">
       -q
      </code>
      to pass a list of
            parameters to be obtained.
     </p>
    </li>
    <li class="listitem">
     <p>
      To exclude results from any host except one in particular,
            use the
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_host">
       <code class="option">
        --host
       </code>
      </a>
      option:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa59793535"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">./ndb_config</span> <span class="token constant">--host</span><span class="token attr-value"><span class="token punctuation">=</span>198.51.100.176</span> <span class="token property">-f</span> <span class="token punctuation">:</span> <span class="token property">-r</span> <span class="token atrule">'\n'</span> <span class="token property">-q</span> id<span class="token punctuation">,</span>type
3<span class="token punctuation">:</span>ndbd
5<span class="token punctuation">:</span>ndb_mgmd</code></pre>
     </div>
     <p>
      In this example, we also used the short form
      <code class="option">
       -q
      </code>
      to determine the attributes to be
            queried.
     </p>
     <p>
      Similarly, you can limit results to a node with a specific
            ID using the
      <a class="link" href="mysql-cluster-programs-ndb-config.html#option_ndb_config_nodeid">
       <code class="option">
        --nodeid
       </code>
      </a>
      option.
     </p>
    </li>
   </ol>
  </div>
 </div>
 <br/>
</div>
