I would like to have 3 MySQL/MariaDB servers setup for redundancy/high availability. What do most people use to cluster these servers? Just MySQL replication or do most use Galera Clusters? I tried Galera Clustering a few months back but it seemed like it was pretty slow. I might just need to put more tweaks in it. If using Galera is it best to have a single server respond and use the other(s) strictly as backup in case the primary fails? All of this is run on 3 ESXi servers so ideally I would like to have 3 database servers all clustered. Ideas? Thoughts? Anything is appreciated.
