![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961605.webp)
MySQL Cluster Configuration Files
1585
It is not necessary to perform any restart of the cluster if new SQL or API nodes
can employ previously unused API slots in the cluster configuration to connect
to the cluster.
17.3.2.7. MySQL Cluster TCP/IP Connections
TCP/IP is the default transport mechanism for all connections between nodes in a MySQL Cluster.
Normally it is not necessary to define TCP/IP connections; MySQL Cluster automatically sets up such
connections for all data nodes, management nodes, and SQL or API nodes.
Note
For an exception to this rule, see
Section 17.3.2.8, “MySQL Cluster TCP/IP
Connections Using Direct Connections”
.
To override the default connection parameters, it is necessary to define a connection using one
or more
[tcp]
sections in the
config.ini
file. Each
[tcp]
section explicitly defines a TCP/IP
connection between two MySQL Cluster nodes, and must contain at a minimum the parameters
NodeId1
and
NodeId2
, as well as any connection parameters to override.
It is also possible to change the default values for these parameters by setting them in the
[tcp
default]
section.
Important
Any
[tcp]
sections in the
config.ini
file should be listed last, following all
other sections in the file. However, this is not required for a
[tcp default]
section. This requirement is a known issue with the way in which the
config.ini
file is read by the MySQL Cluster management server.
Connection parameters which can be set in
[tcp]
and
[tcp default]
sections of the
config.ini
file are listed here:
•
NodeId1
Effective Version
Type/Units
Default
Range/Values
MySQL 5.0.0
numeric
[none]
...
Restart Type: N
NodeId2
Effective Version
Type/Units
Default
Range/Values
MySQL 5.0.0
numeric
[none]
...
Restart Type: N
To identify a connection between two nodes it is necessary to provide their node IDs in the
[tcp]
section of the configuration file. These are the same unique
Id
values for each of these nodes as
described in
Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
.
•
HostName1
Effective Version
Type/Units
Default
Range/Values
MySQL 5.0.0
name or IP address
[none]
...
Restart Type: N
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...