Hi Sai, While the installation documentation states how to do the proper database setup with HA enablement, this HA functionality doesn't seem to work. In the usage guide <https://docs.cloudstack.apache.org/en/4.19.1.1/adminguide/reliability.html#database-high-availability>it is stated how to setup database replication and how HA enablement is supposed to work. However, in the installation guide <https://docs.cloudstack.apache.org/en/4.19.1.1/installguide/optional_installation.html>, it is stated how to setup database replication, but that automatic failover doesn't work and then states the steps on how to perform a manual failover. (stop mgt servers, change replica configuration, point mgt servers to new database (former replica), restart mgt servers)
I vaguely remember a post on this subject from not too long ago that perhaps the whole HA-enablement in the mgt server configuration should be done away with. Kind regards, Jeroen Kleijer On Tue, Sep 10, 2024 at 11:51 PM sai <sai.kr...@gmail.com> wrote: > Hi All, > > I have configured DB HA for the first time following this > https://docs.cloudstack.apache.org/en/latest/adminguide/reliability.html > document. > > when I stop master database, the second slave node doesn't comes up and > management server throws a simple error. Unable to keep the db connection > for LockMaster1 > com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link > failure > can anyone please help me what might be the issue or any other settings > need to done. > > Thanks, > sai >