Happy to contribute a doc on how to achieve HA if we decide to remove
this.
Thanks
On 2023-08-22 15:01, Rohit Yadav wrote:
+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
