wsrep_sst_xtrabackup password and config issue

[Mike EKlund]

1) wsrep_sst_xtrabackup does not pass the cnf file to innobackupex, this causes issues when running the sock file is in a different place.

2) wsrep_sst_xtrabackup and innobackupex do not support the idea of extra default files, so passwords must be embedded in your server's cnf file, since we use puppet to maintain our configs this can be a security concern.

Attached is a patch of what I have done to work around these issues.

[Raghavendra D Prabhu (raghavendra-prabhu)]

@Mike,

innobackupex already supports --defaults-extra-file but with a
caveat of being able to only pass either --defaults-extra-file or
--defaults-file but not both. You can look at lp:740489 for
details.

The !include directive may help if you intend to use same
connection parameters as that of your mysql client. The included file is
processed with the privileges of client opening it. So, in case
you are innobackupex as a different user, there is a way where
you can !include a file which can be read only by the
innobackupex user but not by mysql user.

[Launchpad Janitor (janitor)]

[Expired for Percona XtraDB Cluster because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

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