(mysql.info.gz) MySQL Cluster API Definition

Info Catalog

(mysql.info.gz) MySQL Cluster DB Definition

(mysql.info.gz) MySQL Cluster Config File

(mysql.info.gz) MySQL Cluster TCP Definition

 
 16.3.4.6 Defining the MySQL Servers for a MySQL Cluster
 .......................................................
 
 The `[API]' section (with its alias `[MYSQLD]') defines the behavior of
 the MySQL server. No parameter is mandatory. If no computer or host
 name is provided, then any host can use this API node.
 
 `[API]Id'
      This identity is the node ID used as the address of the node in
      all cluster internal messages. This is an integer between 1 and
      63. Each node in the cluster must have a unique identity.
 
 `[API]ExecuteOnComputer'
      This is referring to one of the computers defined in the computer
      section.
 
 `[API]ArbitrationRank'
      This parameter is used to define which nodes can act as an
      arbitrator. MGM nodes and API nodes can be arbitrators. 0 means it
      isn't used as arbitrator, 1 high priority and 2 low priority. A
      normal configuration uses the management server as arbitrator
      setting the ArbitrationRank to 1 (which is the default) and
      setting all APIs to 0.
 
 `[API]ArbitrationDelay'
      If setting this to anything else than 0 it means that the
      management server will delay responses to the arbitration
      requests. Default is no delay and this should not be necessary to
      change.
 
 `[API]BatchByteSize'
      For queries that get translated into full table scans or range
      scans on indexes, it is important for best performance to fetch
      records in properly sized batches. It is possible to set the
      proper size both in terms of number of records and in terms of
      bytes. Real batch size will be limited by both parameters.
 
      Performance of queries can vary more than 40% due to how this
      parameter is set. In future releases, the MySQL Server will make
      educated guesses on what to set these parameters to, based on the
      query type.
 
      This parameter is measured in bytes and is by default equal to
      32KB.
 
 `[API]BatchSize'
      This parameter is measured in number of records and is by default
      set to 64. The maximum size is 992.
 
 `[API]MaxScanBatchSize'
      The batch size is the size of each batch sent from each storage
      node. Most scans are performed in parallel so to protect the MySQL
      Server from getting too much data from many nodes in parallel,
      this parameter sets a limit to the total batch size over all nodes.
 
      The default value of this parameter is set to 256KB. Its maximum
      size is 16MB.
 

Info Catalog

(mysql.info.gz) MySQL Cluster DB Definition

(mysql.info.gz) MySQL Cluster Config File

(mysql.info.gz) MySQL Cluster TCP Definition