commit 1ce9fa7c4ddbdfe74efbc96c431d571ffc4d7eb1
author vexxhost-bot <105816074+vexxhost-bot@users.noreply.github.com> Wed Sep 04 23:33:43 2024 -0400
committer GitHub <noreply@github.com> Thu Sep 05 03:33:43 2024 +0000
tree f6bb5adfcf544b187533c5e22176737aefc547cc
parent 41a3c9f3d15a5ec2b740e726021b36b8c4003d48

[stable/2024.1] fix: use master pxc_strict_mode (#1858)

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 1e3c668..f10ffa3 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 c21d748..f283983 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') }}"