Instance Manager Configuration File

• Instance Manager reads options for itself from the [manager] section of the configuration file.
  • It also reads ptions for server instances from [mysqld] or [mysqldN] sections.

• Here is a sample section of the configuration file.

  # 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
  

  [mysqld1]
  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
  

How do I go about starting the MySQL server with Instance Manager?

---

---

© 2007 John Michael Pierobon

Notes