Source config from SST script

[Raghavendra D Prabhu]

As described in https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1167331/comments/5 it would be better if custom configuration is possible for SST, Xtrabackup SST atleast.

[Alex Yurchenko (ayurchen)]

Why is sourcing defaults file (my.cnf) not enough? Is there a separate configuration file for xtrabackup?

[Raghavendra D Prabhu (raghavendra-prabhu)]

Options to innobackupex (some which are in turn passed to xtrabackup) cannot be passed through my.cnf

To give an example, so may want to pass --parallel 6 to spawn 6
data copying threads or --stream=xbstream among others.

[Alex Yurchenko (ayurchen)]

If you can pass options to mysqld_safe (which is a shell script) via my.cnf, you surely can pass them to innobackupex. Since xtrabackup requires my.cnf anyways, it makes no sense that innobackupex can't use it.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Yes, it cannot use it currently. Only xtrabackup reads from
my.cnf, innobackupex does not.

[Raghavendra D Prabhu (raghavendra-prabhu)]

@Alexey,

The options I was thinking of -- throttle, parallel and use-memory -- should work from [xtrabackup] my.cnf as well. (since xtrabackup handles them directly).

I don't see any other options here http://www.percona.com/doc/percona-xtrabackup/innobackupex/innobackupex_option_reference.html which may be useful with SST.

(--compress requires manual decompression on joiner end, so it won't help, --databases, --include, --tables-file are good for partial backups/restores but I am not sure how they can be used here).

[Raghavendra D Prabhu (raghavendra-prabhu)]

I don't think anything is required from joiner end since all
configuration can be done in my.cnf.

Only on receiver end, some manual decompression/decryption etc.
will be required.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Reported https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1179405 for #6.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Marking this as invalid for now since it has been dealt in lp:1179405 (though differently).

[Shahriyar Rzayev (rzayev-sehriyar)]

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