@Codeberg @Techwizz Nothing wrong with Galera as such. I used it in a heavy load production cluster for years without issues. The whole multi primary thing saved me more than once. It does come at a performance cost though. We also ran a large-ish production Openstack environment using Galera but there we used a single primary with haproxy in front for a combination of fail over and performance.

@Codeberg Cool, thanks! Was asking as I've been debating between Galera and standard replication for a prod environment at my work. Thanks for the answer!