MySQL Forums
Forum List  »  InnoDB clusters

Question about Quorum
Posted by: Kai Koppelmann
Date: April 18, 2023 02:38PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Question about Quorum
281
April 18, 2023 02:38PM
157
April 18, 2023 11:18PM


Sorry, only registered users may post in this forum.

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.