MySQL :: MySQL Cluster :: 4.3.4 Other MySQL Cluster Configuration Parameters

MySQL Cluster :: 4 MySQL Cluster Configuration :: 4.3 Overview of MySQL Cluster Configuration Parameters :: 4.3.4 Other MySQL Cluster Configuration Parameters

« 4.3.3 MySQL Cluster SQL Node and API Node Configuration Parameters

4.4 MySQL Server Options and Variables for MySQL Cluster »

Section Navigation [Toggle]

4.3 Overview of MySQL Cluster Configuration Parameters
4.3.1 MySQL Cluster Data Node Configuration Parameters
4.3.2 MySQL Cluster Management Node Configuration Parameters
4.3.3 MySQL Cluster SQL Node and API Node Configuration Parameters
4.3.4 Other MySQL Cluster Configuration Parameters

4.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 4.2.8, “MySQL Cluster TCP/IP Connections”, Section 4.2.10, “MySQL Cluster Shared-Memory Connections”, or Section 4.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:

N—Node restart: The parameter can be updated using a rolling restart (see Section 6.4, “Performing a Rolling Restart of a MySQL Cluster”).
S—System restart: The cluster must be shut down completely, then restarted, to effect a change in this parameter.
I—Initial restart: Data nodes must be restarted using the --initial option.

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

Table 4.5. Computer Configuration Parameters

Name	Effective Version	Type/Units	Default	Minimum/Maximum, Permitted Values	Restart Type
`HostName`	all 5.1-based	name or IP address	[none]	...	S
`Id`	all 5.1-based	string	[none]	...	I

Table 4.6. TCP Configuration Parameters

Name	Effective Version	Type/Units	Default	Minimum/Maximum, Permitted Values	Restart Type
`Checksum`	all 5.1-based	boolean	false	...	N
`Group`	all 5.1-based	unsigned	55	0 / 200	N
`NodeId1`	all 5.1-based	numeric	[none]	...	N
`NodeId2`	all 5.1-based	numeric	[none]	...	N
`NodeIdServer`	all 5.1-based	numeric	[none]	...	N
`OverloadLimit`	NDB 6.4.0	bytes	0	0 / 4G	N
`PortNumber`	all 5.1-based	unsigned	[none]	0 / 64K	N
`Proxy`	all 5.1-based	string	[none]	...	N
`ReceiveBufferMemory`	NDB 7.0.4	bytes	2M	16K / 4G	N
`SendBufferMemory`	NDB 7.0.4	unsigned	2M	256K / 4G	N
`SendSignalId`	all 5.1-based	boolean	false (debug builds: true)	...	N
`TCP_MAXSEG_SIZE`	NDB 6.1.1	unsigned	0	0 / 2G	N
`TCP_RCV_BUF_SIZE`	NDB 6.1.1	unsigned	70080	1 / 2G	N
`TCP_SND_BUF_SIZE`	NDB 6.1.1	unsigned	71540	1 / 2G	N
`TcpBind_INADDR_ANY`	NDB 6.2.0	boolean	false	...	N

Table 4.7. Shared Memory Configuration Parameters

Name	Effective Version	Type/Units	Default	Minimum/Maximum, Permitted Values	Restart Type
`Checksum`	all 5.1-based	boolean	true	...	N
`Group`	all 5.1-based	unsigned	35	0 / 200	N
`NodeId1`	all 5.1-based	numeric	[none]	...	N
`NodeId2`	all 5.1-based	numeric	[none]	...	N
`NodeIdServer`	all 5.1-based	numeric	[none]	...	N
`OverloadLimit`	NDB 6.4.0	bytes	0	0 / 4G	N
`PortNumber`	all 5.1-based	unsigned	[none]	0 / 64K	N
`SendSignalId`	all 5.1-based	boolean	false	...	N
`ShmKey`	all 5.1-based	unsigned	[none]	0 / 4G	N
`ShmSize`	all 5.1-based	bytes	1M	64K / 4G	N
`Signum`	all 5.1-based	unsigned	[none]	0 / 4G	N

Table 4.8. SCI Configuration Parameters

Name	Effective Version	Type/Units	Default	Minimum/Maximum, Permitted Values	Restart Type
`Checksum`	all 5.1-based	boolean	false	...	N
`Group`	all 5.1-based	unsigned	15	0 / 200	N
`Host1SciId0`	all 5.1-based	unsigned	[none]	0 / 4G	N
`Host1SciId1`	all 5.1-based	unsigned	0	0 / 4G	N
`Host2SciId0`	all 5.1-based	unsigned	[none]	0 / 4G	N
`Host2SciId1`	all 5.1-based	unsigned	0	0 / 4G	N
`NodeId1`	all 5.1-based	numeric	[none]	...	N
`NodeId2`	all 5.1-based	numeric	[none]	...	N
`NodeIdServer`	all 5.1-based	numeric	[none]	...	N
`OverloadLimit`	NDB 6.4.0	bytes	0	0 / 4G	N
`PortNumber`	all 5.1-based	unsigned	[none]	0 / 64K	N
`SendLimit`	all 5.1-based	unsigned	8K	128 / 32K	N
`SendSignalId`	NDB 6.3.23	boolean	true	...	N
`SharedBufferSize`	all 5.1-based	unsigned	10M	64K / 4G	N

Top / Previous / Next / Up / Table of Contents