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?