NDB Cluster Configuration Files # NodeId= sql-node-A-nodeid [mysqld] [mysqld] # Each API or SQL node that connects to the cluster requires a [mysqld] # or [api] section of its own. Each such section defines a connection # “slot” ; you should have at least as many of these sections in the # config.ini file as the total number of API nodes and SQL nodes that # you wish to have connected to the cluster at any given time. There is # no performance or other penalty for having extra slots available in # case you find later that you want or need more API or SQL nodes to # connect to the cluster at the same time. # If no HostName is specified for a given [mysqld] or [api] section, # then  any  API or SQL node may use that slot to connect to the # cluster. You may wish to use an explicit HostName for one connection slot # to guarantee that an API or SQL node from that host can always # connect to the cluster. If you wish to prevent API or SQL nodes from # connecting from other than a desired host or hosts, then use a # HostName for every [mysqld] or [api] section in the config.ini file. # You can if you wish define a node ID (NodeId parameter) for any API or # SQL node, but this is not necessary; if you do so, it must be in the # range 1 to 255 inclusive and must be unique among all IDs specified # for cluster nodes. Recommended my.cnf options for SQL nodes.   MySQL Servers acting as NDB Cluster SQL nodes must always be started with the  --ndbcluster  and  --ndb-connectstring  options, either on the command line or in  my.cnf . In addition, set the following options for all  mysqld  processes in the cluster, unless your setup requires otherwise: With the exception of the NDB Cluster management server ( ndb_mgmd ), each node that is part of an NDB 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 as follows: 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. localhost:1186  is used as the default connection string value if none is provided. If  port_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). 4059 example 1 (long): "nodeid=2,myhost1:1100,myhost2:1100,198.51.100.3:1200" example 2 (short): "myhost1" [nodeid= node_id , ] host-definition [,  host-definition [, ...]] host-definition : host_name [: port_number ] 23.3.3.3 NDB Cluster Connection Strings • --ndb-use-exact-count=0 • --ndb-index-stat-enable=0 • --ndb-force-send=1 • --optimizer-switch=engine_condition_pushdown=on