mysqld_multi

• mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports.
  • mysqld_multi can start or stop servers, or report their current status.

• The MySQL Instance Manager is an alternative means of managing multiple servers.

• Use the following syntax to invoke mysqld_multi:

  mysqld_multi [options] {start|stop|report} [GNR[,GNR] ...]

  • start, stop, and report indicate which operation to perform.
  • GNR is the group number.

• The GNR value should be the number at the end of the group name in the option file.
  • For example, the GNR for a group named [mysqld7] is 7.
  • To specify a range of numbers, separate the first and last numbers by a dash.
  • Multiple groups or group ranges can be specified on the command line, separated by commas.
  • There must be no whitespace characters in the GNR list because anything after a whitespace character is ignored.

    mysqld_multi stop 7,10-15

• For an example of how to set up an option file, use this command:

  mysqld_multi --example

What is mysqlmanager?

---

---

© 2007 John Michael Pierobon

Notes