mysql or percona does not support customer's --defaults-file in mysqld_multi

[linzuxiong]

mysql-community 5.6.x

percona-server 5.6.24-72.2

If below command , it can not start the instance.
mysqld_multi --defaults-file=/etc/my.cnf --defaults-extra-file=/etc/my.multi.cnf --log=/tmp/multi.log --verbose start 1

If below command, it can start the instance.
mysqld_multi --defaults-extra-file=/etc/my.multi.cnf --log=/tmp/multi.log --verbose start 1

# ll /etc/my.*
-rw-r--r-- 1 root root 1314 Jun 30 16:09 /etc/my.cnf
-rw-r--r-- 1 root root 1024 Jun 30 16:02 /etc/my.multi.cnf

[Valerii Kravchuk (valerii-kravchuk)]

Manual (https://dev.mysql.com/doc/refman/5.6/en/mysqld-multi.html) says:

" mysqld_multi searches for option files as follows:

    With --no-defaults, no option files are read.

    With --defaults-file=file_name, only the named file is read.

    Otherwise, option files in the standard list of locations are read, including any file named by the --defaults-extra-file=file_name option, if one is given. (If the option is given multiple times, the last value is used.) "

So, if you have [mysqld1] etc only in the /etc/my.multi.cnf the first command is expected to NOT work. It reads only /etc/my.cnf and nothing else.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3292