Percona Xtra DB Cluster installed with helm: How to change pxc_strict_mode to PERMISSIVE permanently

MySQL & MariaDB Percona Operator for MySQL
1

Description:

Hi everybody,
I have installed the Percona XtraDB Cluster with helm on our kubernetes cluster: pxc-operator, haproxy, pxc-db. Per default it uses the pxc strict mode ENFORCING.

One of my applications which uses the Percona XtraDB cluster apparently has problems with the ENFORCING mode => Percona-XtraDB-Cluster doesn’t recommend using SERIALIZABLE isolation with pxc_strict_mode = ENFORCING. After switching to PERMISSIVE the application works.

Is there a way to change the Percona XtraDB cluster to pxc_strict_mode PERMISSIVE via helm upgrade with separate values.yaml file? Or is there another way for fixing that?

Version:

helm app version: 1.14.0

Thank you very much!

2

You might want to check this

1 Like
3

Thank you @Yunus

@robro did the previos answer help you? This is how I would do that.