mysqldump SST is broken in current head

[Teemu Ollakka]

lp:codership-mysql/5.5 r3965
lp:codership-mysql/5.6 r4064

Recent merges from PXC has added WSREP_SST_OPT_CONF into wsrep_sst_common.sh which causes error with mysqldump SST because --defaults-file parameter is not passed to wsrep_sst_mysqldump.sh. Fix this and also make mysqldump SST to read authentication from config file. Related ticket https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1200727.

Another issue is that if JOINER does not have binlog enabled, SST fails with

  ERROR 1186 (HY000) at line 2: Binlog closed, cannot RESET MASTER

RESET MASTER is used to clear old binlog files and to reset GTID related variables on JOINER. Even if RESET MASTER does not make any sense if binlog is not on, DONOR does not know about JOINERs binlog settings and therefore it must be made to succeed on JOINER if wsrep is on to make error free SST possible.

[Yan Zhang (yan.zhang)]

first issue
fixed in http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3984

[Yan Zhang (yan.zhang)]

first issue
fixed in http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4079

[Yan Zhang (yan.zhang)]

second issue(only applied to 5.6)
fixed in http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4080

[Yan Zhang (yan.zhang)]

second issue. better way to ignore error
fixed in http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4081

[Shahriyar Rzayev (rzayev-sehriyar)]

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