I am trying to configure a MySQL server to run multiple instances of the daemon (I wish to duplicate it onto different drives). I've been trying to use the mysqld_multi script. However the script is not finding the groups in
I copied and pasted the the configuration from
msqld_multi --example into my.cnf, and this discovered the groups fines. However when I tried to modify the file below
mysqld_multi report just displays:
Reporting MySQL servers No groups to be reported (check your GNRs)
Below is an abbreviation of my my.cnf file.
[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld1] #this is for the master server pid-file =/var/run/mysqld/mysqld.pid socket =/var/run/mysqld/mysqld.sock port =3306 datadir=/var/lib/mysql server-id=1 log-bin=mysql-bin [mysqld2] #for the slave! pid-file =/var/run/mysqld-slave/mysqld-slave.pid socket =/var/run/mysqld-slave/mysqld-slave.sock port =3307 datadir =/var/lib/mysql-backup server-id=2 skip-innodb default-storage-engine =myisam [mysqld_multi] user = mysql [mysqld] basedir = /usr tmpdir = /tmp ...
Here's a short bit from
[mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin user = multi_admin password = my_password [mysqld2] socket = /tmp/mysql.sock2 port = 3307 ...
Can anyone spot why mysqld_multi isn't parsing this?