+1 it's a broken feature that at least doesn't work with MySQL 8.x, I'm not sure if it worked with prior versions of MySQL. However, we need to document some sort of suggested MySQL HA setup in our docs.
Regards. ________________________________ From: Nux <n...@li.nux.ro> Sent: Tuesday, August 22, 2023 18:54 To: us...@cloudstack.apache.org <us...@cloudstack.apache.org>; Dev <dev@cloudstack.apache.org> Subject: [Consultation] Remove DB HA feature (db.ha.enabled) Hello everyone, A few weeks ago I asked you if you use or managed to use the DB HA Cloudstack feature (db.ha.enabled)[1] and after reading some of the replies and doing intensive testing myself I have found out that the feature is indeed non-functional, it's broken. In my testing I discovered DB HA can easily be done outside of Cloudstack by employing load balancers and other techniques. Personally I have achieved that by using Haproxy in front of Galera cluster, but also introduced Keepalived (vrrp) in my setup to "balance" multiple Haproxies which also worked well. As such, since the feature is basically broken, it will not be trivial to fix it and there are better ways of doing HA, then I propose to remove it altogether. Thoughts? Anyone against it? Cheers [1] - https://docs.cloudstack.apache.org/en/latest/adminguide/reliability.html#database-high-availability
