Comment 1 for bug 1243228

Also, even though it may be fine to set defaults, it may be problematic when that pxc node is used as an async slave or for any other purpose.

Specifically, following options:

"wsrep_slave_threads", "1"
"bind_address", "0.0.0.0"
"wsrep_sst_method", "rsync"
"wsrep_sst_receive_address","AUTO"
"binlog_format", "ROW"
"wsrep_provider", "none"
"query_cache_type", "0"
"query_cache_size", "0"
"locked_in_memory", "0"
"wsrep_cluster_address", "0"
"locks_unsafe_for_binlog", "0"
"autoinc_lock_mode", "1"

Out of the above, the options with bad defaults are:

"binlog_format", (STATEMENT)
"query_cache_type", (1)
"autoinc_lock_mode" (1)

==============================

This should also avoid people crashing their nodes with bad
defaults and reporting bugs on that :) (seen many bugs with STMT
binlog_format).