mysqld_multi

mysqld_multi

The mysqld_multi script makes it easier to run several mysqld servers on a single host. It allows you to start or stop servers or determine whether they are running.

Usage

 mysqld_multi [options] command server_list  

Command is one of start, stop, or report. The server_list argument indicates which servers you want to manipulate. For further instructions on using mysqld_multi, see Chapter 11.

Standard Options Supported by mysqld_multi

 --help        --password    --user        --version  

mysqld_multi passes the --user and --password option values to mysqladmin when it needs to stop servers or determine if they are running.

Options Specific to mysqld_multi

• --config-file=file_name

  The option file to read to obtain options for the servers that mysqld_multi manipulates. Without --config-file, /etc/my.cnf and the .my.cnf file in your home directory are read to obtain server options. (mysqld_multi reads the standard option files for its own options. This option does not change that behavior.)

• --example

  Display a sample option file that demonstrates option file groups suitable for use with mysqld_multi.

• --log=file_name

  The name of the log file where mysqld_multi should log its actions. Output is appended to the log if it already exists. The default log file is /tmp/mysqld_multi.log. To disable logging, use --no-log.

• --mysqladmin=file_name

  The pathname to the mysqladmin binary you want to use. This can be useful if mysqld_multi cannot find mysqladmin by itself or if you want to use a different version.

• --mysqld=file_name

  The pathname to the mysqld binary you want to use. This can be useful if mysqld_multi cannot find mysqld by itself or if you want to use a different version. (It's allowable to specify a pathname to mysqld, mysqld_safe, or safe_mysqld here.)

• --no-log

  Display log output rather than writing it to a log file. (If you want to see output, you must use this option because the default is to log to a file.)

• --tcp-ip

  By default, mysqld_multi attempts to connect to a server using a UNIX socket file. This option causes the connection attempt to use TCP/IP instead. It can be useful when a server is running but its socket file has been removed, in which case the server will be accessible only via TCP/IP.