17.3.3.2 MySQL Cluster Management Node Configuration Parameters

The summary table in this section provides information about parameters used in the [ndb_mgmd] or [mgm] sections of a config.ini file for configuring MySQL Cluster management nodes. For detailed descriptions and other additional information about each of these parameters, see Section 17.3.2.4, “Defining a MySQL Cluster Management Server”.

Restart types.  Changes in MySQL Cluster configuration parameters do not take effect until the cluster is restarted. The type of restart required to change a given parameter is indicated in the summary table as follows:

For more information about restart types, see Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”.

Table 17.2 Management Node Configuration Parameters

Parameter NameType or UnitsRestart TypeIn Version ... (and later)
Default Value
Minimum/Maximum or Permitted Values

ArbitrationDelay

millisecondsNall
0
0 / 4294967039 (0xFFFFFEFF)

ArbitrationRank

0-2Nall
1
0 / 2

DataDir

pathNall
.
...

ExecuteOnComputer

nameSall
[none]
...

HostName

name or IP addressSall
[none]
...

Id

unsignedISall
[none]
1 / 255

LogDestination

{CONSOLE|SYSLOG|FILE}Nall
[see text]
...

MaxNoOfSavedEvents

unsignedNall
100
0 / 4294967039 (0xFFFFFEFF)

NodeId

unsignedIS5.0.15
[none]
1 / 63

PortNumber

unsignedNall
1186
0 / 64K

PortNumberStats

unsignedNall
[none]
0 / 64K

Note

After making changes in a management node's configuration, it is necessary to perform a rolling restart of the cluster for the new configuration to take effect. See Section 17.3.2.4, “Defining a MySQL Cluster Management Server”, for more information.

To add new management servers to a running MySQL Cluster, it is also necessary perform a rolling restart of all cluster nodes after modifying any existing config.ini files. For more information about issues arising when using multiple management nodes, see Section 17.1.5.9, “Limitations Relating to Multiple MySQL Cluster Nodes”.