commit c0dfb9a4e869f4da4a3b12be75202a5f07674c11
author vexxhost-bot <105816074+vexxhost-bot@users.noreply.github.com> Wed Sep 04 23:31:32 2024 -0400
committer GitHub <noreply@github.com> Thu Sep 05 03:31:32 2024 +0000
tree bfc0dd6a6a0d685d0b98c6022f8bd3f43ed59e6a
parent 165b284b0a5b72a67d6f23a9bc19b5773a8253d0

[stable/zed] fix: use master pxc_strict_mode (#1856)

This is an automated cherry-pick of #1851
/assign mnaser

roles/keycloak/tasks/main.yml

diff --git a/roles/keycloak/tasks/main.yml b/roles/keycloak/tasks/main.yml
index 127bd14..ae467d2 100644
--- a/roles/keycloak/tasks/main.yml
+++ b/roles/keycloak/tasks/main.yml
@@ -108,4 +108,4 @@
     login_host: "{{ _pxc_service.resources[0].spec.clusterIP }}"
     login_user: root
     login_password: "{{ openstack_helm_endpoints.oslo_db.auth.admin.password }}"
-    query: "set global pxc_strict_mode='ENFORCING'"
+    query: "set global pxc_strict_mode='MASTER'"

roles/percona_xtradb_cluster/vars/main.yml

diff --git a/roles/percona_xtradb_cluster/vars/main.yml b/roles/percona_xtradb_cluster/vars/main.yml
index 5a99be1..96c7587 100644
--- a/roles/percona_xtradb_cluster/vars/main.yml
+++ b/roles/percona_xtradb_cluster/vars/main.yml
@@ -12,6 +12,7 @@
       max_allowed_packet=16M
       # Skip reverse DNS lookup of clients
       skip-name-resolve
+      pxc_strict_mode=MASTER
     sidecars:
       - name: exporter
         image: "{{ atmosphere_images['prometheus_mysqld_exporter'] | vexxhost.kubernetes.docker_image('ref') }}"