17.3.3.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 17.3.2.8, “MySQL Cluster TCP/IP Connections”, Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”, or Section 17.3.2.11, “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 17.3.3, “Overview of MySQL Cluster Configuration Parameters”.

Table 17.5 Computer Configuration Parameters

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

HostName

name or IP addressSall 5.1-based
[none]
...

Id

stringISall 5.1-based
[none]
...

Table 17.6 TCP Configuration Parameters

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

Checksum

booleanNall 5.1-based
false
true, false

Group

unsignedNall 5.1-based
55
0 / 200

NodeId1

numericNall 5.1-based
[none]
...

NodeId2

numericNall 5.1-based
[none]
...

NodeIdServer

numericNall 5.1-based
[none]
...

OverloadLimit

bytesNNDB 6.4.0
0
0 / 4294967039 (0xFFFFFEFF)

PortNumber

unsignedNall 5.1-based
[none]
0 / 64K

Proxy

stringNall 5.1-based
[none]
...

ReceiveBufferMemory

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

SendBufferMemory

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

SendSignalId

booleanNall 5.1-based
[see text]
true, false

TCP_MAXSEG_SIZE

unsignedNNDB 6.1.1
0
0 / 2G

TCP_RCV_BUF_SIZE

unsignedNNDB 6.1.1
70080
1 / 2G

TCP_SND_BUF_SIZE

unsignedNNDB 6.1.1
71540
1 / 2G

TcpBind_INADDR_ANY

booleanNNDB 6.2.0
false
true, false

Table 17.7 Shared Memory Configuration Parameters

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

Checksum

booleanNall 5.1-based
true
true, false

Group

unsignedNall 5.1-based
35
0 / 200

NodeId1

numericNall 5.1-based
[none]
...

NodeId2

numericNall 5.1-based
[none]
...

NodeIdServer

numericNall 5.1-based
[none]
...

OverloadLimit

bytesNNDB 6.4.0
0
0 / 4294967039 (0xFFFFFEFF)

PortNumber

unsignedNall 5.1-based
[none]
0 / 64K

SendSignalId

booleanNall 5.1-based
false
true, false

ShmKey

unsignedNall 5.1-based
[none]
0 / 4294967039 (0xFFFFFEFF)

ShmSize

bytesNall 5.1-based
1M
64K / 4294967039 (0xFFFFFEFF)

Signum

unsignedNall 5.1-based
[none]
0 / 4294967039 (0xFFFFFEFF)

Table 17.8 SCI Configuration Parameters

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

Checksum

booleanNall 5.1-based
false
true, false

Group

unsignedNall 5.1-based
15
0 / 200

Host1SciId0

unsignedNall 5.1-based
[none]
0 / 4294967039 (0xFFFFFEFF)

Host1SciId1

unsignedNall 5.1-based
0
0 / 4294967039 (0xFFFFFEFF)

Host2SciId0

unsignedNall 5.1-based
[none]
0 / 4294967039 (0xFFFFFEFF)

Host2SciId1

unsignedNall 5.1-based
0
0 / 4294967039 (0xFFFFFEFF)

NodeId1

numericNall 5.1-based
[none]
...

NodeId2

numericNall 5.1-based
[none]
...

NodeIdServer

numericNall 5.1-based
[none]
...

OverloadLimit

bytesNNDB 6.4.0
0
0 / 4294967039 (0xFFFFFEFF)

PortNumber

unsignedNall 5.1-based
[none]
0 / 64K

SendLimit

unsignedNall 5.1-based
8K
128 / 32K

SendSignalId

booleanNall 5.1-based
true
true, false

SharedBufferSize

unsignedNall 5.1-based
10M
64K / 4294967039 (0xFFFFFEFF)