Hello Guys, I am currently using Percona XtraDB Cluster for my database, but CloudStack relies on functions like GET_LOCK and RELEASE_LOCK, which are not recommended in a Galera-based cluster. Setting pxc_strict_mode = PERMISSIVE allows CloudStack to function, but this causes issues with replication consistency and stability. If I set pxc_strict_mode = ENFORCING, CloudStack stops working because it uses these functions, but setting it to PERMISSIVE breaks the replication in the cluster.
Is there any way to configure Percona XtraDB Cluster to allow CloudStack to work properly without compromising the integrity of the replication? I use CS 4.18, 4.19 both with the same problem. Thanks a lot in advance :) -- *Francisco Arencibia Quesada.* *DevOps Engineer*
