(mysql.info) instance-manager-configuration-files

Info Catalog

(mysql.info) instance-manager-command-options

(mysql.info) instance-manager

(mysql.info) instance-manager-commands

 
 5.5.4 MySQL Instance Manager Configuration Files
 ------------------------------------------------
 
 Instance Manager uses the standard `my.cnf' file. It uses the
 `[manager]' section to read options for itself and the `[mysqld]'
 sections to create instances. The `[manager]' section contains any of
 the options listed in  instance-manager-command-options. Here is
 an example `[manager]' section:
 
      # MySQL Instance Manager options section
      [manager]
      default-mysqld-path = /usr/local/mysql/libexec/mysqld
      socket=/tmp/manager.sock
      pid-file=/tmp/manager.pid
      password-file = /home/cps/.mysqlmanager.passwd
      monitoring-interval = 2
      port = 1999
      bind-address = 192.168.1.5
 
 Prior to MySQL 5.0.10, the MySQL Instance Manager read the same
 configuration files as the MySQL Server, including `/etc/my.cnf',
 `~/.my.cnf', etc. As of MySQL 5.0.10, the MySQL Instance Manager reads
 and manages the `/etc/my.cnf' file only on Unix. On Windows, MySQL
 Instance Manager reads the `my.ini' file in the directory where
 Instance Manager is installed. The default option file location can be
 changed with the -defaults-file=FILE_NAME option.
 
 Instance sections specify options given to each instance at startup.
 These are mainly common MySQL server options, but there are some
 IM-specific options:
 
    * `mysqld-path = PATH'
 
      The pathname to the `mysqld' server binary.
 
    * `shutdown-delay = SECONDS'
 
      The number of seconds IM should wait for the instance to shut
      down. The default value is 35 seconds. After the delay expires,
      the IM assumes that the instance is hanging and attempts to
      terminate it. If you use `InnoDB' with large tables, you should
      increase this value.
 
    * `nonguarded'
 
      This option should be specified if you want to disable IM
      monitoring functionality for a certain instance.
 
 Here are some sample instance sections:
 
      [mysqld]
      mysqld-path=/usr/local/mysql/libexec/mysqld
      socket=/tmp/mysql.sock
      port=3307
      server_id=1
      skip-stack-trace
      core-file
      skip-bdb
      log-bin
      log-error
      log=mylog
      log-slow-queries
 
      [mysqld2]
      nonguarded
      port=3308
      server_id=2
      mysqld-path= /home/cps/mysql/trees/mysql-5.0/sql/mysqld
      socket     = /tmp/mysql.sock5
      pid-file   = /tmp/hostname.pid5
      datadir= /home/cps/mysql_data/data_dir1
      language=/home/cps/mysql/trees/mysql-5.0/sql/share/english
      log-bin
      log=/tmp/fordel.log
 

Info Catalog

(mysql.info) instance-manager-command-options

(mysql.info) instance-manager

(mysql.info) instance-manager-commands