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:

N—Node restart: The parameter can be updated using a rolling restart (see Section 17.5.5, "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 17.3.3, "Overview of MySQL Cluster Configuration Parameters".

Table 17.5. Computer Configuration Parameters

Parameter Name	Type or Units	Restart Type	In Version ... (and later)
	Default Value
	Minimum/Maximum or Permitted Values
`HostName`	name or IP address	S	NDB 7.3.0
	[none]
	...
`Id`	string	IS	NDB 7.3.0
	[none]
	...

Table 17.6. TCP Configuration Parameters

Parameter Name	Type or Units	Restart Type	In Version ... (and later)
	Default Value
	Minimum/Maximum or Permitted Values
`Checksum`	boolean	N	NDB 7.3.0
	false
	true, false
`Group`	unsigned	N	NDB 7.3.0
	55
	0 / 200
`NodeId1`	numeric	N	NDB 7.3.0
	[none]
	...
`NodeId2`	numeric	N	NDB 7.3.0
	[none]
	...
`NodeIdServer`	numeric	N	NDB 7.3.0
	[none]
	...
`OverloadLimit`	bytes	N	NDB 7.3.0
	0
	0 / 4G
`PortNumber`	unsigned	N	NDB 7.3.0
	[none]
	0 / 64K
`Proxy`	string	N	NDB 7.3.0
	[none]
	...
`ReceiveBufferMemory`	bytes	N	NDB 7.3.0
	2M
	16K / 4G
`SendBufferMemory`	unsigned	N	NDB 7.3.0
	2M
	256K / 4G
`SendSignalId`	boolean	N	NDB 7.3.0
	[see text]
	true, false
`TCP_MAXSEG_SIZE`	unsigned	N	NDB 7.3.0
	0
	0 / 2G
`TCP_RCV_BUF_SIZE`	unsigned	N	NDB 7.3.1
	0
	0 / 2G
`TCP_SND_BUF_SIZE`	unsigned	N	NDB 7.3.1
	0
	0 / 2G
`TcpBind_INADDR_ANY`	boolean	N	NDB 7.3.0
	false
	true, false

Table 17.7. Shared Memory Configuration Parameters

Parameter Name	Type or Units	Restart Type	In Version ... (and later)
	Default Value
	Minimum/Maximum or Permitted Values
`Checksum`	boolean	N	NDB 7.3.0
	true
	true, false
`Group`	unsigned	N	NDB 7.3.0
	35
	0 / 200
`NodeId1`	numeric	N	NDB 7.3.0
	[none]
	...
`NodeId2`	numeric	N	NDB 7.3.0
	[none]
	...
`NodeIdServer`	numeric	N	NDB 7.3.0
	[none]
	...
`OverloadLimit`	bytes	N	NDB 7.3.0
	0
	0 / 4G
`PortNumber`	unsigned	N	NDB 7.3.0
	[none]
	0 / 64K
`SendSignalId`	boolean	N	NDB 7.3.0
	false
	true, false
`ShmKey`	unsigned	N	NDB 7.3.0
	[none]
	0 / 4G
`ShmSize`	bytes	N	NDB 7.3.0
	1M
	64K / 4G
`Signum`	unsigned	N	NDB 7.3.0
	[none]
	0 / 4G

Table 17.8. SCI Configuration Parameters

Parameter Name	Type or Units	Restart Type	In Version ... (and later)
	Default Value
	Minimum/Maximum or Permitted Values
`Checksum`	boolean	N	NDB 7.3.0
	false
	true, false
`Group`	unsigned	N	NDB 7.3.0
	15
	0 / 200
`Host1SciId0`	unsigned	N	NDB 7.3.0
	[none]
	0 / 4G
`Host1SciId1`	unsigned	N	NDB 7.3.0
	0
	0 / 4G
`Host2SciId0`	unsigned	N	NDB 7.3.0
	[none]
	0 / 4G
`Host2SciId1`	unsigned	N	NDB 7.3.0
	0
	0 / 4G
`NodeId1`	numeric	N	NDB 7.3.0
	[none]
	...
`NodeId2`	numeric	N	NDB 7.3.0
	[none]
	...
`NodeIdServer`	numeric	N	NDB 7.3.0
	[none]
	...
`OverloadLimit`	bytes	N	NDB 7.3.0
	0
	0 / 4G
`PortNumber`	unsigned	N	NDB 7.3.0
	[none]
	0 / 64K
`SendLimit`	unsigned	N	NDB 7.3.0
	8K
	128 / 32K
`SendSignalId`	boolean	N	NDB 7.3.0
	true
	true, false
`SharedBufferSize`	unsigned	N	NDB 7.3.0
	10M
	64K / 4G