[PXC Strict Mode] The example on setting pxc_strict_mode as session variable doesn't work
Bug #1694095 reported by
Jaime Sicam
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Confirmed
|
Undecided
|
Alexey Zhebel |
Bug Description
[In:/doc/
"Note
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_
But if you run this on Percona XtraDB Cluster 5.7.17-13-57-log, you get this error:
mysql> set pxc_strict_
ERROR 1229 (HY000): Variable 'pxc_strict_mode' is a GLOBAL variable and should be set with SET GLOBAL
Changed in percona-xtradb-cluster: | |
status: | New → Confirmed |
tags: | added: i197402 |
To post a comment you must log in.
Also, https:/ /www.percona. com/doc/ percona- xtradb- cluster/ 5.7/wsrep- system- index.html# pxc_strict_ mode :
"
variable pxc_strict_mode
Version Info:
5.7 – Variable introduced
Command Line:
Yes
Config File:
Yes
Scope:
Global, Session
Dynamic:
Yes
Default Value:
ENFORCING or DISABLED
"