Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.7Mb
PDF (A4) - 35.7Mb
PDF (RPM) - 34.8Mb
EPUB - 8.7Mb
HTML Download (TGZ) - 8.5Mb
HTML Download (Zip) - 8.5Mb
HTML Download (RPM) - 7.3Mb
Eclipse Doc Plugin (TGZ) - 9.3Mb
Eclipse Doc Plugin (Zip) - 11.5Mb
Man Pages (TGZ) - 203.5Kb
Man Pages (Zip) - 308.9Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

19.3.2.3 NDB Cluster SQL Node and API Node Configuration Parameters

The summary table in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API nodes. For detailed descriptions and other additional information about each of these parameters, see Section 19.3.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”.

Note

For a discussion of MySQL server options for NDB Cluster , see Section 19.3.3.8.1, “MySQL Server Options for NDB Cluster”; for information about MySQL server system variables relating to NDB Cluster , see Section 19.3.3.8.2, “NDB Cluster System Variables”.

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 19.3.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”.

Table 19.4 SQL Node / API Node Configuration Parameters

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

ApiVerbose

bytesNNDB 7.5.2
undefined
0 / 100

ArbitrationDelay

millisecondsNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

ArbitrationRank

0-2NNDB 7.5.0
0
0 / 2

AutoReconnect

booleanNNDB 7.5.0
false
true, false

BatchByteSize

bytesNNDB 7.5.0
16K
1024 / 1M

BatchSize

recordsNNDB 7.5.0
256
1 / 992

ConnectBackoffMaxTime

integerNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

ConnectionMap

stringNNDB 7.5.0
[none]
...

DefaultHashMapSize

bucketsNNDB 7.5.0
3840
0 / 3840

DefaultOperationRedoProblemAction

enumerationSNDB 7.5.0
QUEUE
ABORT, QUEUE

EventLogBufferSize

bytesSNDB 7.5.0
8192
0 / 64K

ExecuteOnComputer

nameSNDB 7.5.0
[none]
...

ExtraSendBufferMemory

bytesNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

HeartbeatThreadPriority

stringSNDB 7.5.0
[none]
...

HostName

name or IP addressNNDB 7.5.0
[none]
...

Id

unsignedISNDB 7.5.0
[none]
1 / 255

MaxScanBatchSize

bytesNNDB 7.5.0
256K
32K / 16M

NodeId

unsignedISNDB 7.5.0
[none]
1 / 255

StartConnectBackoffMaxTime

integerNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

TotalSendBufferMemory

bytesNNDB 7.5.0
0
256K / 4294967039 (0xFFFFFEFF)

wan

booleanNNDB 7.5.0
false
true, false

Note

To add new SQL or API nodes to the configuration of a running NDB Cluster , it is necessary to perform a rolling restart of all cluster nodes after adding new [mysqld] or [api] sections to the config.ini file (or files, if you are using more than one management server). This must be done before the new SQL or API nodes can connect to the cluster.

It is not necessary to perform any restart of the cluster if new SQL or API nodes can employ previously unused API slots in the cluster configuration to connect to the cluster.


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