An Overview of Binary Options

The options for the MySQL Cluster binaries work the same as those for MySQL. They can be included in configuration files and accept short and long options in the same manner as any of the other MySQL binaries.

One option that exists for almost all the binaries discussed is called --ndb-connectstring, or -c. This option specifies to the program where to find the management server to find out the information about the structure of the cluster. Here are two examples of its use:

ndb_show_tables --ndb-connectstring=192.168.0.5 ndb_show_tables c 192.168.0.5

To get a list of all the options that a program takes, you should run it with the --help or -? option to get output for all the possible options.

Configuration Files

The configuration file setup works the same with MySQL Cluster as with MySQL. The normal default global configuration file is /etc/my.cnf. In addition, a user can create a user-specific configuration file in his or her home directory as ~/.my.cnf. This home directory configuration file is used only by the client programs and not by the server programs.

A special group is designed to be used with MySQL Cluster binaries: [mysql_cluster]. Any options put into this group apply to all the binaries that are involved in the cluster. The most common use of this is to specify the ndb-connectstring option discussed previously. The following example sets up the location of the configuration server for all cluster clients and servers that will run on the server:

[mysql_cluster] ndb-connectstring=192.168.0.5