Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual

18.3.2.2 NDB 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 NDB Cluster management nodes. For detailed descriptions and other additional information about each of these parameters, see Section 18.3.3.5, “Defining an NDB Cluster Management Server”.

Restart types.  Changes in NDB 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 18.3.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”.

Table 18.3 Management Node Configuration Parameters

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

ArbitrationDelay

millisecondsNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

ArbitrationRank

0-2NNDB 7.2.0
1
0 / 2

DataDir

pathNNDB 7.2.0
.
...

ExecuteOnComputer

nameSNDB 7.2.0
[none]
...

ExtraSendBufferMemory

bytesNNDB 7.2.14
0
0 / 32G

HeartbeatIntervalMgmdMgmd

millisecondsNNDB 7.2.12
1500
100 / 4294967039 (0xFFFFFEFF)

HeartbeatThreadPriority

stringSNDB 7.2.0
[none]
...

HostName

name or IP addressNNDB 7.2.0
[none]
...

Id

unsignedISNDB 7.2.0
[none]
1 / 255

LogDestination

{CONSOLE|SYSLOG|FILE}NNDB 7.2.0
[see text]
...

MaxNoOfSavedEvents

unsignedNNDB 7.2.0
100
0 / 4294967039 (0xFFFFFEFF)

NodeId

unsignedISNDB 7.2.0
[none]
1 / 255

PortNumber

unsignedSNDB 7.2.0
1186
0 / 64K

PortNumberStats

unsignedNNDB 7.2.0
[none]
0 / 64K

TotalSendBufferMemory

bytesNNDB 7.2.0
0
256K / 4294967039 (0xFFFFFEFF)

wan

booleanNNDB 7.2.0
false
true, false

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 18.3.3.5, “Defining an NDB Cluster Management Server”, for more information.

To add new management servers to a running NDB 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 18.1.6.10, “Limitations Relating to Multiple NDB Cluster Nodes”.


User Comments
Sign Up Login You must be logged in to post a comment.