Comment 4 for bug 1021954

Alexey Kopytov (akopytov) wrote :

This looks like a documentation issue to me. Since innobackupex calls the mysql command line client to issue queries (including FTWRL to get a consistent backup and SHOW MASTER/SLAVE to get the corresponding metadata), it should also pass the correct host/user/password/port/socket in case multiple server instances are running on the same host. That's what what the corresponding option in innobackupex are for.

Now the problem is that unlike innobackupex, both server and the mysql command line client have built-in defaults, so they can be used even without connection parameter explicitly specified. Which is what happens in this case. What can we do about it? We can either require connection arguments on the innobackupex command line, or document that in case of multiple server instances one must specify the correct connection parameters in order for innobackupex to talk to the correct server.

The former is annoying, especially on hosts with a single server instance. So I prefer the latter. Changing to a documentation request.