Andrii Nikitin (Inactive) added a comment - 2017-10-15 04:46 [ERROR] WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127.0.0.1', which makes it impossible to receive state transfer from another node, since mysqld won't accept such connections. If you wish to use mysqldump state transfer method, set bind_address to allow mysql client connections from other cluster members (e.g. 0.0.0.0).

Andrii Nikitin (Inactive) added a comment - 2017-11-02 12:54 - edited These two checks complicate use and testing nodes on single host , which is completely valid scenario for many cases. It will be easy to diagnose why this host cannot be contacted from another host, so this check doesn't really help and puts artificial requirement to have bind_address=0.0.0.0 if node is intended to be used only locally.

Andrii Nikitin (Inactive) added a comment - 2017-11-02 13:04 sachin.setiya.007 Could you approve following patch: --- a/sql/wsrep_check_opts.cc +++ b/sql/wsrep_check_opts.cc @@ -335,7 +335,7 @@ check_opts (int const argc, const char* const argv[], struct opt opts[]) if (!strcasecmp(opts[BIND_ADDRESS].value, "127.0.0.1") || !strcasecmp(opts[BIND_ADDRESS].value, "localhost")) { - WSREP_ERROR ("wsrep_sst_method is set to 'mysqldump' yet " + WSREP_WARN ("wsrep_sst_method is set to 'mysqldump' yet " "mysqld bind_address is set to '%s', which makes it " "impossible to receive state transfer from another " "node, since mysqld won't accept such connections. " @@ -343,7 +343,7 @@ check_opts (int const argc, const char* const argv[], struct opt opts[]) "set bind_address to allow mysql client connections " "from other cluster members (e.g. 0.0.0.0).", opts[BIND_ADDRESS].value); - rcode = EINVAL; +// rcode = EINVAL; } }