Changing pxc_strict_mode with restart persistance

Follow

Manuel Fraga

• June 29, 2018 09:29

Hi

I'm trying to change pxc_stric_mode to PERMISSIVE, so on each node of the cluster i run:

set global pxc_strict_mode='PERMISSIVE';

After that, I change the following item on /etc/mysql/percona-xtradb-cluster.conf.d/wsrep.cnf
>> pxc_strict_mode=PERMISSIVE

Howewer after restarting nodes for maintenance pxc_strict_mode come back to the original value:

mysql> SHOW GLOBAL VARIABLES like 'pxc_strict_mode';
+-----------------+-----------+
| Variable_name | Value |
+-----------------+-----------+
| pxc_strict_mode | ENFORCING |
+-----------------+-----------+

Any clue?

 

Thanks in advance

0

• Official comment

  

  Johan

  • June 29, 2018 10:17

  Hi,

  you also need to make the change in my.cnf to make it survive server restarts.
  
  In Manage->Configurations , and then do Change Parameter. See the screen shots:
  
  
  And the change will be made in my.cnf too, and the global variable has also been applied.
  
  
  
  BR

  johan

  Comment actions Permalink
• 

  Sampsonshen

  • September 11, 2025 17:57

  How do you make this change in v2.3.3?  the Change Parameter option isn't available in the Mange -> Configuration section any more.

  0

  Comment actions Permalink
• 

  Paul Namuag

  • September 11, 2025 18:27
  • Edited

  Hi Sampsonshen,

  You can still use the same way as in version 2.3.3. Basically, you must have to add this in the configuration file first. Try adding pxc_strict_mode parameter in your /etc/mysql/my.cnf under Manage -> Configuration -> choose the db node, then edit the config file and add that parameter and save it. Once saved, try clicking the button Edit params and you will see that the parameter will show up afterwards. Also this is reflected in your config file as well. However, when you do some changes under Edit params, values that can be set dynamically will also be applied and changes can be noticed right away.

  0

  Comment actions Permalink

Please sign in to leave a comment.