(mysql.info.gz) MySQL Cluster MGM Definition

Info Catalog

(mysql.info.gz) MySQL Cluster Computer Definition

(mysql.info.gz) MySQL Cluster Config File

(mysql.info.gz) MySQL Cluster DB Definition

 
 16.3.4.4 Defining the MySQL Cluster Management Server
 .....................................................
 
 The `[MGM]' section (or its alias `[NDB_MGMD]') is used to configure
 the behavior of the management server. Either the `ExecuteOnComputer'
 or `HostName' parameter must be present.  All other parameters can be
 omitted and if so will assume their default values.
 
 `[MGM]Id'
      Each node in the cluster has a unique identity represented by an
      integer value between 1 and 63 inclusive. This ID is used for
      addressing the node by all internal cluster messages.
 
 `[MGM]ExecuteOnComputer'
      This refers to one of the computers defined in the `[COMPUTER]'
      section.
 
 `[MGM]PortNumber'
      This is the port number on which the management server listens for
      configuration requests and management commands.
 
 `[MGM]LogDestination'
      This parameter specifies where to send cluster logging information.
      There are three options in this regard: `CONSOLE', `SYSLOG', and
      `FILE'.
 
         * `CONSOLE' outputs the log to `stdout':
 
                CONSOLE
 
         * `SYSLOG' sends the log to a `syslog' facility, possible
           values being one of `auth', `authpriv', `cron', `daemon',
           `ftp', `kern', `lpr', `mail', `news', `syslog', `user',
           `uucp', `local0', `local1', `local2', `local3', `local4',
           `local5', `local6', or `local7'. (* Not every facility
           is necessarily supported by every operating system.)
 
                SYSLOG:facility=syslog
 
         * `FILE' pipes the cluster log ouput to a regular file on the
           same machine. The following values can be specified:
 
              * `filename': The name of the logfile.
 
              * `maxsize': The maximum size to which the file can grow
                before logging rolls over to a new file. When this
                occurs, the old logfile is renamed by appending `.x' to
                the filename, where `x' is the next number not yet used
                with this name.
 
              * `maxfiles': The maximum number of logfiles.
 
 
                FILE:filename=cluster.log,maxsize=1000000,maxfiles=6
 
           It is possible to specify multiple log destinations as shown
           here, using a semicolon-delimited string:
 
                CONSOLE;SYSLOG:facility=local0;FILE:filename=/var/log/mgmd
 
           The default value for the `FILE' parameter is
           `FILE:filename=ndb_<id>_cluster.log,maxsize=1000000,maxfiles=6',
           where `<id>' is the ID of the node.
 
 
 `[MGM]ArbitrationRank'
      This parameter is used to define which nodes can act as
      arbitrators.  Only MGM nodes and API nodes can be arbitrators and
      can take one of the following values:
 
         * `0': The node will never be used as an arbitrator.
 
         * `1': The node has high priority; that is, it will be
           preferred as an arbitrator over low-priority nodes.
 
         * `2': Indicates a low-priority node which be used as an
           arbitrator only if a node with a higher priority is not
           available for that purpose.
 
 
      Normally, the management server should be configured as arbitrator
      by setting its `ArbitrationRank' to 1 (the default) and that of all
      API or server nodes to 0.
 
 `[MGM]ArbitrationDelay'
      An integer value which causes the management server's responses to
      arbitration requests to be delayed by that number of milliseconds.
      By default, this value is 0; it is normally not necessary to
      change it.
 
 `[MGM]DataDir'
      This sets the directory where output files from the management
      server will be placed. These files include cluster log files,
      process output files, and the daemon's pid file. (For log files,
      this can be overridden by setting the `FILE' parameter for
      `[MGM]LogDestination' as discussed previously in this section.)
 
 

Info Catalog

(mysql.info.gz) MySQL Cluster Computer Definition

(mysql.info.gz) MySQL Cluster Config File

(mysql.info.gz) MySQL Cluster DB Definition