89404

MySQL Cluster Connection Strings

With the exception of the MySQL Cluster management server (ndb_mgmd), each node that is part

of a MySQL Cluster requires a connection string that points to the management server's location.

This connection string is used in establishing a connection to the management server as well as in

performing other tasks depending on the node's role in the cluster. The syntax for a

connection string is

asfollows:

[nodeid=node_id, ]host-definiciorj[, bost-de/initiont, ...]]

hosC-definition:

host_name[:por t_number)

node_id is an integer greater than or equal to 1 which identifies a node in

config.ini. host_name

is a string representing a valid Internet host name or IP address. port_number is an integer referring to a TCP/IP port number.

example 1 (long): "nodeid®2,myhostl:1100,rayhost2:1100,192.168.0.3:1200" example 2 (short): "myhostl"

localhost: 1186 is used as the default connection string value if nonę is provided.

If por t_num is

omitted from the connection string, the default port is 1186. This port should always be available on the

network because it has been assigned by IANA for this purpose (see http://www. iana.org/assignments/ port-numbers for details).

By listing multiple host definitions, it is possible to designate several redundant management servers. A

MySQL Cluster data or API node attempts to contact successive management servers on each host in

the order specified, until a successful connection has been established.