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

Please sign in to leave a comment.