Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.3Mb
PDF (A4) - 35.5Mb
PDF (RPM) - 33.8Mb
EPUB - 8.6Mb
HTML Download (TGZ) - 8.4Mb
HTML Download (Zip) - 8.5Mb
HTML Download (RPM) - 7.3Mb
Eclipse Doc Plugin (TGZ) - 9.3Mb
Eclipse Doc Plugin (Zip) - 11.3Mb
Man Pages (TGZ) - 197.9Kb
Man Pages (Zip) - 301.8Kb
Info (Gzip) - 3.2Mb
Info (Zip) - 3.2Mb
Excerpts from this Manual

19.3.2.4 Other MySQL Cluster Configuration Parameters

The summary tables in this section provide information about parameters used in the [computer], [tcp], [shm], and [sci] sections of a config.ini file for configuring MySQL Cluster management nodes. For detailed descriptions and other additional information about individual parameters, see Section 19.3.3.9, “MySQL Cluster TCP/IP Connections”, Section 19.3.3.11, “MySQL Cluster Shared-Memory Connections”, or Section 19.3.3.12, “SCI Transport Connections in MySQL Cluster”, as appropriate.

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 tables as follows:

For more information about restart types, see Section 19.3.2, “Overview of MySQL Cluster Configuration Parameters, Options, and Variables”.

Table 19.5 Computer Configuration Parameters

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

HostName

name or IP addressNNDB 7.5.0
[none]
...

Id

stringISNDB 7.5.0
[none]
...

Table 19.6 TCP Configuration Parameters

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

Checksum

booleanNNDB 7.5.0
false
true, false

Group

unsignedNNDB 7.5.0
55
0 / 200

NodeId1

numericNNDB 7.5.0
[none]
...

NodeId2

numericNNDB 7.5.0
[none]
...

NodeIdServer

numericNNDB 7.5.0
[none]
...

OverloadLimit

bytesNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

PortNumber

unsignedSNDB 7.5.0
[none]
0 / 64K

Proxy

stringNNDB 7.5.0
[none]
...

ReceiveBufferMemory

bytesNNDB 7.5.0
2M
16K / 4294967039 (0xFFFFFEFF)

SendBufferMemory

unsignedNNDB 7.5.0
2M
256K / 4294967039 (0xFFFFFEFF)

SendSignalId

booleanNNDB 7.5.0
[see text]
true, false

TCP_MAXSEG_SIZE

unsignedNNDB 7.5.0
0
0 / 2G

TCP_RCV_BUF_SIZE

unsignedNNDB 7.5.0
0
0 / 2G

TCP_SND_BUF_SIZE

unsignedNNDB 7.5.0
0
0 / 2G

TcpBind_INADDR_ANY

booleanNNDB 7.5.0
false
true, false

Table 19.7 Shared Memory Configuration Parameters

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

Checksum

booleanNNDB 7.5.0
true
true, false

Group

unsignedNNDB 7.5.0
35
0 / 200

NodeId1

numericNNDB 7.5.0
[none]
...

NodeId2

numericNNDB 7.5.0
[none]
...

NodeIdServer

numericNNDB 7.5.0
[none]
...

OverloadLimit

bytesNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

PortNumber

unsignedSNDB 7.5.0
[none]
0 / 64K

SendSignalId

booleanNNDB 7.5.0
false
true, false

ShmKey

unsignedNNDB 7.5.0
[none]
0 / 4294967039 (0xFFFFFEFF)

ShmSize

bytesNNDB 7.5.0
1M
64K / 4294967039 (0xFFFFFEFF)

Signum

unsignedNNDB 7.5.0
[none]
0 / 4294967039 (0xFFFFFEFF)

Table 19.8 SCI Configuration Parameters

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

Checksum

booleanNNDB 7.5.0
false
true, false

Group

unsignedNNDB 7.5.0
15
0 / 200

Host1SciId0

unsignedNNDB 7.5.0
[none]
0 / 4294967039 (0xFFFFFEFF)

Host1SciId1

unsignedNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

Host2SciId0

unsignedNNDB 7.5.0
[none]
0 / 4294967039 (0xFFFFFEFF)

Host2SciId1

unsignedNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

NodeId1

numericNNDB 7.5.0
[none]
...

NodeId2

numericNNDB 7.5.0
[none]
...

NodeIdServer

numericNNDB 7.5.0
[none]
...

OverloadLimit

bytesNNDB 7.5.0
0
0 / 4294967039 (0xFFFFFEFF)

PortNumber

unsignedSNDB 7.5.0
[none]
0 / 64K

SendLimit

unsignedNNDB 7.5.0
8K
128 / 32K

SendSignalId

booleanNNDB 7.5.0
true
true, false

SharedBufferSize

unsignedNNDB 7.5.0
10M
64K / 4294967039 (0xFFFFFEFF)


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