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

This is an automated cherry-pick of #1851
/assign mnaser
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'"
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') }}"