Question about Quorum
Hello,
I am testing some scenarios with our InnoDB Cluster.
Our environment is a 3 node InnoDB Cluster based on version 8.0.32.
All works well - we implemented MySQL Router on application side, connection works like a charm.
I now wanted to test some failure scenarios and did not get the result I excpected. I turned off two out of three machines hosting the InnoDB instances.
As excpected MySQL Router & the Error Log of MySQL reported two failed nodes.
cluster.status() reported status "MISSING".
If 2 out of 3 members are offline/missing I assumed a complete cluster outage due to quorum loss. But... the cluster remains online with a single r/w instance and I am able to place transactions inside of this single instance.
Why the InnoDB cluster is not going down due to quorum loss?
Many regards
Kai
Edited 3 time(s). Last edit at 04/18/2023 02:54PM by Kai Koppelmann.
Subject
Views
Written By
Posted
Question about Quorum
287
April 18, 2023 02:38PM
162
April 18, 2023 11:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.