Skip navigation links
17.3.4.3 MySQL Cluster System Variables »
Section Navigation      [Toggle]

17.3.4.2. mysqld Command Options for MySQL Cluster

This section provides descriptions of mysqld server options relating to MySQL Cluster. For information about mysqld options not specific to MySQL Cluster, and for general information about the use of options with mysqld, see Section 5.1.2, “Server Command Options”.

For information about command-line options used with other MySQL Cluster processes (ndbd, ndb_mgmd, and ndb_mgm), see Section 17.4.21, “Options Common to MySQL Cluster Programs”. For information about command-line options used with NDB utility programs (such as ndb_desc, ndb_size.pl, and ndb_show_tables), see Section 17.4, “MySQL Cluster Programs”.

  • --ndb-connectstring=connect_string

    Command-Line Format --ndb-connectstring
    Config-File Format ndb-connectstring
      Permitted Values
    Type string

    When using the NDBCLUSTER storage engine, this option specifies the management server that distributes cluster configuration data. See Section 17.3.2.2, “The MySQL Cluster Connectstring”, for syntax.

  • --ndbcluster

    Command-Line Format --ndbcluster
    Config-File Format ndbcluster
    Option Sets Variable Yes, have_ndbcluster
    Disabled by skip-ndbcluster
      Permitted Values
    Type boolean
    Default FALSE

    The NDBCLUSTER storage engine is necessary for using MySQL Cluster. If a mysqld binary includes support for the NDBCLUSTER storage engine, the engine is disabled by default. Use the --ndbcluster option to enable it. Use --skip-ndbcluster to explicitly disable the engine.

  • --ndb-nodeid=#

    Version Introduced 5.0.45
    Command-Line Format --ndb-nodeid=#
    Config-File Format ndb-nodeid
    Variable Name Ndb_cluster_node_id
    Variable Scope Global
    Dynamic Variable No
      Permitted Values (>= 5.0.45)
    Type numeric
    Range 1-63

    Set this MySQL server's node ID in a MySQL Cluster. This can be used instead of specifying the node ID as part of the connectstring or in the config.ini file, or allowing the cluster to determine an arbitrary node ID. If you use this option, then --ndb-nodeid must be specified before --ndb-connectstring. If --ndb-nodeid is used and a node ID is specified in the connectstring, then the MySQL server will not be able to connect to the cluster. In addition, if --nodeid is used, then either a matching node ID must be found in a [mysqld] or [api] section of config.ini, or there must be an “open” [mysqld] or [api] section in the file (that is, a section without an Id parameter specified).

    Regardless of how the node ID is determined, its is shown as the value of the global status variable Ndb_cluster_node_id in the output of SHOW STATUS, and as cluster_node_id in the connection row of the output of SHOW ENGINE NDBCLUSTER STATUS.

    For more information about node IDs for MySQL Cluster SQL nodes, see Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”.

  • --skip-ndbcluster

    Command-Line Format --skip-ndbcluster
    Config-File Format skip-ndbcluster

    Disable the NDBCLUSTER storage engine. This is the default for binaries that were built with NDBCLUSTER storage engine support; the server allocates memory and other resources for this storage engine only if the --ndbcluster option is given explicitly. See Section 17.3.1, “Quick Test Setup of MySQL Cluster”, for an example.