- for the first problem: I am wondering how you could get the server to start with binlog_format != ROW.
pxc1 --binlog_format=MIXED
2017-12-08T06:01:43.727203Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-08T06:01:43.727278Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2017-12-08T06:01:43.727297Z 0 [ERROR] WSREP: Percona-XtraDB-Cluster prohibits setting binlog_format to STATEMENT or MIXED at global level
2017-12-08T06:01:43.727320Z 0 [ERROR] Aborting
2017-12-08T06:01:43.727343Z 0 [Note] Binlog end
- MIXED format is not safe to use since it keep on switching between STATEMENT AND ROW. PXC needs ROW based logging to ensure the ordering.
The said piece of documentation needs to be updated but we strongly recommend not to overwrite the mode to avoid the problem like the one you faced before.