(mysql.info.gz) MySQL Cluster Connectstring

Info Catalog

(mysql.info.gz) MySQL Cluster Config Example

(mysql.info.gz) MySQL Cluster Config File

(mysql.info.gz) MySQL Cluster Computer Definition

 
 16.3.4.2 The MySQL Cluster `connectstring'
 ..........................................
 
 With the exception of the MySQL Cluster management server (`ndb_mgmd'),
 each node making up a MySQL Cluster requires a `connectstring' which
 points to the management server's location.  This 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 `connectstring' is as follows:
 
      <connectstring> := [<nodeid-specification>,]<host-specification>[,<host-specification>]
      <nodeid-specification> := nodeid=<id>
      <host-specification> := <host>[:<port>]
      <id> is an integer larger than 1 identifying a node in config.ini
      <port> is an integer referring to a regular unix port
      <host> is a string which is a valid Internet host address
 
      example 1 (long):    "nodeid=2,myhost1:1100,myhost2:1100,192.168.0.3:1200"
      example 2 (short):   "myhost1"
 
 All nodes will use `localhost:1186' as the default `connectstring'
 value if none is provided. If `<port>' is omitted from the
 `connectstring', the default port is 1186.  (* Prior to MySQL
 4.1.8, the default port was 2200.) This port should always be available
 on the network, since it has been assigned by IANA for this purpose (see
 `http://www.iana.org/assignments/port-numbers' for details).
 
 By listing multiple `<host-specification>' values, it is possible to
 designate several redundant management servers. A cluster node will
 attempt to contact successive management servers on each host in the
 order specified, until a successful connection has been established.
 
 There are a number of different ways to specify the connectstring:
 
    * Each executable has its own command line option which enables
      specifying the management server at startup. (See the documentation
      for the respective executable.)
 
    * Beginning with MySQL 4.1.8, it is also possible to set the
      `connectstring' to be used by all nodes in the cluster by placing
      it in a `[mysql_cluster]' section in the management server's
      `my.cnf' file.
 
    * For backward compatibility, two other options are available, using
      the same syntax:
 
        1. Set the `NDB_CONNECTSTRING' environment variable to contain
           the connectstring.
 
        2. Write the `connectstring' for each executable into a text file
           named `Ndb.cfg' and place this file in the executable's
           startup directory.
 
 
 
 The recommended method for specifying the `connectstring' is to set it
 on the command line or `my.cnf' file for each executable.
 

Info Catalog

(mysql.info.gz) MySQL Cluster Config Example

(mysql.info.gz) MySQL Cluster Config File

(mysql.info.gz) MySQL Cluster Computer Definition