Comment 3 for bug 740489

Revision history for this message
Mike Benshoof (mbenshoof) wrote :

This method works for a dedicated box running a single mysql instance where the global config file is in a default place (which works for some of my installations) - thanks for the suggestion!

However, I'm moving to multiple instance setup where each instance has a unique configuration file. After some more testing, however, it appears that since I'm now being forced to pass the --defaults-file parameter for each instance, the defaults-extra-file option is pretty much irrelevant.

So it looks as if I'm going to have a watered down my.xtrabackup.cnf type file that has my datadirs, credentials, etc and I can restrict those permissions accordingly.

So with all that being said, I will most likely stop using the option moving forward. So aside from just having it available as it is available in underlying programs, I guess it really isn't needed.

Thanks for your time!