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

21.4.3.8 Defining the System

The[system] section is used for parameters applying to the cluster as a whole. TheName system parameter is used with MySQL Enterprise Monitor;ConfigGenerationNumber andPrimaryMGMNode are not used in production environments. Except when using NDB Cluster with MySQL Enterprise Monitor, is not necessary to have a[system] section in theconfig.ini file.

More information about these parameters can be found in the following list:

  • ConfigGenerationNumber

    Version (or later)NDB 7.5.0
    Type or unitsunsigned
    Default0
    Range0 - 4294967039 (0xFFFFFEFF)
    Restart Type

    Node Restart:Requires arolling restart of the cluster. (NDB 7.5.0)

    Configuration generation number. This parameter is currently unused.

  • Name

    Version (or later)NDB 7.5.0
    Type or unitsstring
    Default[...]
    Range...
    Restart Type

    Node Restart:Requires arolling restart of the cluster. (NDB 7.5.0)

    Set a name for the cluster. This parameter is required for deployments with MySQL Enterprise Monitor; it is otherwise unused.

    You can obtain the value of this parameter by checking theNdb_system_name status variable. In NDB API applications, you can also retrieve it usingget_system_name().

  • PrimaryMGMNode

    Version (or later)NDB 7.5.0
    Type or unitsunsigned
    Default0
    Range0 - 4294967039 (0xFFFFFEFF)
    Restart Type

    Node Restart:Requires arolling restart of the cluster. (NDB 7.5.0)

    Node ID of the primary management node. This parameter is currently unused.

Restart types.  Information about the restart types used by the parameter descriptions in this section is shown in the following table:

Table 21.17 NDB Cluster restart types

SymbolRestart TypeDescription
NNodeThe parameter can be updated using a rolling restart (seeSection 21.6.5, “Performing a Rolling Restart of an NDB Cluster”)
SSystemAll cluster nodes must be shut down completely, then restarted, to effect a change in this parameter
IInitialData nodes must be restarted using the--initial option