- 3.2 MySQL Cluster Configuration Files
- 3.2.1 MySQL Cluster Configuration — Basic Example
- 3.2.2 Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later
- 3.2.3 The MySQL Cluster Connectstring
- 3.2.4 Defining Computers in a MySQL Cluster
- 3.2.5 Defining a MySQL Cluster Management Server
- 3.2.6 Defining MySQL Cluster Data Nodes
- 3.2.7 Defining SQL and Other API Nodes in a MySQL Cluster
- 3.2.8 MySQL Cluster TCP/IP Connections
- 3.2.9 MySQL Cluster TCP/IP Connections Using Direct Connections
- 3.2.10 MySQL Cluster Shared-Memory Connections
- 3.2.11 SCI Transport Connections in MySQL Cluster
- 3.2.12 Configuring MySQL Cluster Parameters for Local Checkpoints
- 3.2.13 Configuring MySQL Cluster Send Buffer Parameters
Setting up a cluster using direct connections between data nodes
requires specifying explicitly the crossover IP addresses of the
data nodes so connected in the [tcp] section
of the cluster config.ini file.
In the following example, we envision a cluster with at least
four hosts, one each for a management server, an SQL node, and
two data nodes. The cluster as a whole resides on the
172.23.72.* subnet of a LAN. In addition to
the usual network connections, the two data nodes are connected
directly using a standard crossover cable, and communicate with
one another directly using IP addresses in the
1.1.0.* address range as shown:
# Management Server [ndb_mgmd] Id=1 HostName=172.23.72.20 # SQL Node [mysqld] Id=2 HostName=172.23.72.21 # Data Nodes [ndbd] Id=3 HostName=172.23.72.22 [ndbd] Id=4 HostName=172.23.72.23 # TCP/IP Connections [tcp] NodeId1=3 NodeId2=4 HostName1=1.1.0.1 HostName2=1.1.0.2
The HostName
parameter, where NN is an integer, is
used only when specifying direct TCP/IP connections.
The use of direct connections between data nodes can improve the cluster's overall efficiency by allowing the data nodes to bypass an Ethernet device such as a switch, hub, or router, thus cutting down on the cluster's latency. It is important to note that to take the best advantage of direct connections in this fashion with more than two data nodes, you must have a direct connection between each data node and every other data node in the same node group.
