Affects Version/s: None
Fix Version/s: None
**Reported in Launchpad by Jaime Sicam last update 26-07-2017 15:37:24
It is better to start the server with the necessary mode (the default ENFORCING is highly recommended). However, you can dynamically change it during runtime. For example, to set PXC Strict Mode to PERMISSIVE, run the following command:
mysql> SET pxc_strict_mode=PERMISSIVE;"
But if you run this on Percona XtraDB Cluster 5.7.17-13-57-log, you get this error:
mysql> set pxc_strict_mode=permissive;
ERROR 1229 (HY000): Variable 'pxc_strict_mode' is a GLOBAL variable and should be set with SET GLOBAL