Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 48.2Mb
PDF (A4) - 48.2Mb
PDF (RPM) - 43.8Mb
HTML Download (TGZ) - 11.0Mb
HTML Download (Zip) - 11.1Mb
HTML Download (RPM) - 9.5Mb
Man Pages (TGZ) - 239.8Kb
Man Pages (Zip) - 343.5Kb
Info (Gzip) - 4.4Mb
Info (Zip) - 4.4Mb
Excerpts from this Manual

22.3.3.8 Defining the System

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

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

  • ConfigGenerationNumber

    Table 22.215 This table provides type and value information for the ConfigGenerationNumber system configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default 0
    Range 0 - 4294967039 (0xFFFFFEFF)
    Restart Type N

    Configuration generation number. This parameter is currently unused.

  • Name

    Table 22.216 This table provides type and value information for the Name system configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units string
    Default [none]
    Range ...
    Restart Type N

    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 the Ndb_system_name status variable. In NDB API applications, you can also retrieve it using get_system_name().

  • PrimaryMGMNode

    Table 22.217 This table provides type and value information for the PrimaryMGMNode system configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default 0
    Range 0 - 4294967039 (0xFFFFFEFF)
    Restart Type N

    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 22.218 NDB Cluster restart types

Symbol Restart Type Description
N Node The parameter can be updated using a rolling restart (see Section 22.5.5, “Performing a Rolling Restart of an NDB Cluster”)
S System All cluster nodes must be shut down completely, then restarted, to effect a change in this parameter
I Initial Data nodes must be restarted using the --initial option