MySQL Cluster :: 5 MySQL Cluster Configuration :: 5.3 Overview of MySQL Cluster Configuration Parameters :: 5.3.4 Other MySQL Cluster Configuration Parameters

« 5.3.3 MySQL Cluster SQL Node and API Node Configuration Parameters

5.4 MySQL Server Options and Variables for MySQL Cluster »

Section Navigation [Toggle]

5.3 Overview of MySQL Cluster Configuration Parameters
5.3.1 MySQL Cluster Data Node Configuration Parameters
5.3.2 MySQL Cluster Management Node Configuration Parameters
5.3.3 MySQL Cluster SQL Node and API Node Configuration Parameters
5.3.4 Other MySQL Cluster Configuration Parameters

5.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 5.2.8, “MySQL Cluster TCP/IP Connections”, Section 5.2.10, “MySQL Cluster Shared-Memory Connections”, or Section 5.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 7.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 5.3, “Overview of MySQL Cluster Configuration Parameters”.

Table 5.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	all 5.1-based
	[none]
	...
`Id`	string	IS	all 5.1-based
	[none]
	...

Table 5.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	all 5.1-based
	false
	true, false
`Group`	unsigned	N	all 5.1-based
	55
	0 / 200
`NodeId1`	numeric	N	all 5.1-based
	[none]
	...
`NodeId2`	numeric	N	all 5.1-based
	[none]
	...
`NodeIdServer`	numeric	N	all 5.1-based
	[none]
	...
`OverloadLimit`	bytes	N	NDB 6.4.0
	0
	0 / 4G
`PortNumber`	unsigned	N	all 5.1-based
	[none]
	0 / 64K
`Proxy`	string	N	all 5.1-based
	[none]
	...
`ReceiveBufferMemory`	bytes	N	NDB 7.0.4
	2M
	16K / 4G
`SendBufferMemory`	unsigned	N	NDB 7.0.4
	2M
	256K / 4G
`SendSignalId`	boolean	N	all 5.1-based
	[see text]
	true, false
`TCP_MAXSEG_SIZE`	unsigned	N	NDB 6.1.1
	0
	0 / 2G
`TCP_RCV_BUF_SIZE`	unsigned	N	NDB 6.1.1
	70080
	1 / 2G
`TCP_SND_BUF_SIZE`	unsigned	N	NDB 6.1.1
	71540
	1 / 2G
`TcpBind_INADDR_ANY`	boolean	N	NDB 6.2.0
	false
	true, false

Table 5.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	all 5.1-based
	true
	true, false
`Group`	unsigned	N	all 5.1-based
	35
	0 / 200
`NodeId1`	numeric	N	all 5.1-based
	[none]
	...
`NodeId2`	numeric	N	all 5.1-based
	[none]
	...
`NodeIdServer`	numeric	N	all 5.1-based
	[none]
	...
`OverloadLimit`	bytes	N	NDB 6.4.0
	0
	0 / 4G
`PortNumber`	unsigned	N	all 5.1-based
	[none]
	0 / 64K
`SendSignalId`	boolean	N	all 5.1-based
	false
	true, false
`ShmKey`	unsigned	N	all 5.1-based
	[none]
	0 / 4G
`ShmSize`	bytes	N	all 5.1-based
	1M
	64K / 4G
`Signum`	unsigned	N	all 5.1-based
	[none]
	0 / 4G

Table 5.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	all 5.1-based
	false
	true, false
`Group`	unsigned	N	all 5.1-based
	15
	0 / 200
`Host1SciId0`	unsigned	N	all 5.1-based
	[none]
	0 / 4G
`Host1SciId1`	unsigned	N	all 5.1-based
	0
	0 / 4G
`Host2SciId0`	unsigned	N	all 5.1-based
	[none]
	0 / 4G
`Host2SciId1`	unsigned	N	all 5.1-based
	0
	0 / 4G
`NodeId1`	numeric	N	all 5.1-based
	[none]
	...
`NodeId2`	numeric	N	all 5.1-based
	[none]
	...
`NodeIdServer`	numeric	N	all 5.1-based
	[none]
	...
`OverloadLimit`	bytes	N	NDB 6.4.0
	0
	0 / 4G
`PortNumber`	unsigned	N	all 5.1-based
	[none]
	0 / 64K
`SendLimit`	unsigned	N	all 5.1-based
	8K
	128 / 32K
`SendSignalId`	boolean	N	NDB 6.3.23
	true
	true, false
`SharedBufferSize`	unsigned	N	all 5.1-based
	10M
	64K / 4G

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents