I've tried using Percona Cluster as a drop-in replacement for MySQL.
However when templates are saved, each cluster node is updated with a different value for the primary key column template_id
in the exp_templates
table. The primary key column group_id
in the exp_template_groups
table is also different on each node when group updates are made or a group is created.
This (obviously) causes database inconsistencies, and templates to disappear depending on which MySQL cluster node they're served by.
Does anyone have any experience or advice on whether or not EE2 with Percona Cluster is possible?