<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-system-definition">
      </a>
      25.4.3.8 Defining the System
     </h4>
    </div>
   </div>
  </div>
  <p>
   The
   <code class="literal">
    [system]
   </code>
   section is used for parameters
        applying to the cluster as a whole. The
   <a class="link" href="mysql-cluster-system-definition.html#ndbparam-system-name">
    <code class="literal">
     Name
    </code>
   </a>
   system parameter
        is used with MySQL Enterprise Monitor;
   <a class="link" href="mysql-cluster-system-definition.html#ndbparam-system-configgenerationnumber">
    <code class="literal">
     ConfigGenerationNumber
    </code>
   </a>
   and
   <a class="link" href="mysql-cluster-system-definition.html#ndbparam-system-primarymgmnode">
    <code class="literal">
     PrimaryMGMNode
    </code>
   </a>
   are
        not used in production environments. Except when using NDB
        Cluster with MySQL Enterprise Monitor, is not necessary to have a
   <code class="literal">
    [system]
   </code>
   section in the
   <code class="filename">
    config.ini
   </code>
   file.
  </p>
  <p>
   More information about these parameters can be found in the
        following list:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="ndbparam-system-configgenerationnumber">
      </a>
      <a class="indexterm" name="idm46045114034336">
      </a>
      <a class="link" href="mysql-cluster-system-definition.html#ndbparam-system-configgenerationnumber">
       <code class="literal">
        ConfigGenerationNumber
       </code>
      </a>
     </p>
     <div class="informaltable">
      <a name="configgenerationnumber-system-table">
      </a>
      <table frame="box" rules="all" summary="ConfigGenerationNumber system configuration parameter type and value information" width="35%">
       <colgroup>
        <col style="width: 50%"/>
        <col style="width: 50%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Version (or later)
         </th>
         <td>
          NDB 8.4.0
         </td>
        </tr>
        <tr>
         <th>
          Type or units
         </th>
         <td>
          unsigned
         </td>
        </tr>
        <tr>
         <th>
          Default
         </th>
         <td>
          0
         </td>
        </tr>
        <tr>
         <th>
          Range
         </th>
         <td>
          0 - 4294967039 (0xFFFFFEFF)
         </td>
        </tr>
        <tr>
         <th>
          Restart Type
         </th>
         <td>
          <p>
           <span class="bold">
            <strong>
             Node Restart:
            </strong>
           </span>
           Requires a
           <a class="link" href="mysql-cluster-rolling-restart.html" title="25.6.5 Performing a Rolling Restart of an NDB Cluster">
            rolling
                    restart
           </a>
           of the cluster. (NDB 8.4.0)
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Configuration generation number. This parameter is currently
            unused.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="ndbparam-system-name">
      </a>
      <a class="indexterm" name="idm46045114013968">
      </a>
      <a class="link" href="mysql-cluster-system-definition.html#ndbparam-system-name">
       <code class="literal">
        Name
       </code>
      </a>
     </p>
     <div class="informaltable">
      <a name="name-system-table">
      </a>
      <table frame="box" rules="all" summary="Name system configuration parameter type and value information" width="35%">
       <colgroup>
        <col style="width: 50%"/>
        <col style="width: 50%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Version (or later)
         </th>
         <td>
          NDB 8.4.0
         </td>
        </tr>
        <tr>
         <th>
          Type or units
         </th>
         <td>
          string
         </td>
        </tr>
        <tr>
         <th>
          Default
         </th>
         <td>
          [...]
         </td>
        </tr>
        <tr>
         <th>
          Range
         </th>
         <td>
          ...
         </td>
        </tr>
        <tr>
         <th>
          Restart Type
         </th>
         <td>
          <p>
           <span class="bold">
            <strong>
             Node Restart:
            </strong>
           </span>
           Requires a
           <a class="link" href="mysql-cluster-rolling-restart.html" title="25.6.5 Performing a Rolling Restart of an NDB Cluster">
            rolling
                    restart
           </a>
           of the cluster. (NDB 8.4.0)
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set a name for the cluster. This parameter is required for
            deployments with MySQL Enterprise Monitor; it is otherwise unused.
     </p>
     <p>
      You can obtain the value of this parameter by checking the
      <a class="link" href="mysql-cluster-options-variables.html#statvar_Ndb_system_name">
       <code class="literal">
        Ndb_system_name
       </code>
      </a>
      status
            variable. In NDB API applications, you can also retrieve it
            using
      <a class="ulink" href="/doc/ndbapi/en/ndb-ndb-cluster-connection.html#ndb-ndb-cluster-connection-get-system-name" target="_top">
       <code class="literal">
        get_system_name()
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="ndbparam-system-primarymgmnode">
      </a>
      <a class="indexterm" name="idm46045113990560">
      </a>
      <a class="link" href="mysql-cluster-system-definition.html#ndbparam-system-primarymgmnode">
       <code class="literal">
        PrimaryMGMNode
       </code>
      </a>
     </p>
     <div class="informaltable">
      <a name="primarymgmnode-system-table">
      </a>
      <table frame="box" rules="all" summary="PrimaryMGMNode system configuration parameter type and value information" width="35%">
       <colgroup>
        <col style="width: 50%"/>
        <col style="width: 50%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Version (or later)
         </th>
         <td>
          NDB 8.4.0
         </td>
        </tr>
        <tr>
         <th>
          Type or units
         </th>
         <td>
          unsigned
         </td>
        </tr>
        <tr>
         <th>
          Default
         </th>
         <td>
          0
         </td>
        </tr>
        <tr>
         <th>
          Range
         </th>
         <td>
          0 - 4294967039 (0xFFFFFEFF)
         </td>
        </tr>
        <tr>
         <th>
          Restart Type
         </th>
         <td>
          <p>
           <span class="bold">
            <strong>
             Node Restart:
            </strong>
           </span>
           Requires a
           <a class="link" href="mysql-cluster-rolling-restart.html" title="25.6.5 Performing a Rolling Restart of an NDB Cluster">
            rolling
                    restart
           </a>
           of the cluster. (NDB 8.4.0)
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Node ID of the primary management node. This parameter is
            currently unused.
     </p>
    </li>
   </ul>
  </div>
  <p>
   <a name="mysql-cluster-system-definition-restart-types">
   </a>
   <b>
    Restart types.
   </b>
   Information about the restart types used by the parameter
          descriptions in this section is shown in the following table:
  </p>
  <div class="table">
   <a name="idm46045113968960">
   </a>
   <p class="title">
    <b>
     Table 25.18 NDB Cluster restart types
    </b>
   </p>
   <div class="table-contents">
    <table>
     <colgroup>
      <col style="width: 10%"/>
      <col style="width: 30%"/>
      <col style="width: 60%"/>
     </colgroup>
     <thead>
      <tr>
       <th scope="col">
        Symbol
       </th>
       <th scope="col">
        Restart Type
       </th>
       <th scope="col">
        Description
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <th scope="row">
        N
       </th>
       <td>
        Node
       </td>
       <td>
        The parameter can be updated using a rolling restart (see
        <a class="xref" href="mysql-cluster-rolling-restart.html" title="25.6.5 Performing a Rolling Restart of an NDB Cluster">
         Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
        </a>
        )
       </td>
      </tr>
      <tr>
       <th scope="row">
        S
       </th>
       <td>
        System
       </td>
       <td>
        All cluster nodes must be shut down completely, then restarted, to
              effect a change in this parameter
       </td>
      </tr>
      <tr>
       <th scope="row">
        I
       </th>
       <td>
        Initial
       </td>
       <td>
        Data nodes must be restarted using the
        <a class="link" href="mysql-cluster-programs-ndbd.html#option_ndbd_initial">
         <code class="option">
          --initial
         </code>
        </a>
        option
       </td>
      </tr>
     </tbody>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
