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
311
April 18, 2023 02:38PM
186
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.