5 ms·
We used Percona's XtraDB Cluster for HA and have had very few issues. Just fronting it with haproxy to read/write to a single node at a time (setting others to
by SteveNuts 7y ago
We used Percona's XtraDB Cluster for HA and have had very few issues.
Just fronting it with haproxy to read/write to a single node at a time (setting others to "backup") has worked well for us, since we're not doing a huge number of queries.
- Nican 7y agoThank you! That is useful information. I will take a closer look at Percona in the future.
- muffelsong 7y agoI concur, but consider ProxySQL instead of HAProxy. Percona with XtraDB/Galera failover fronted by ProxySQL is very resilient and performant.