MySQL Forums
Forum List  »  Replication

Re: group replication with 2 data nodes and a witness?
Posted by: Frederic Descamps
Date: January 05, 2018 02:34AM

Hi Todd,

MySQL InnoDB Cluster (and so GR) is not like NDB. Nodes don't have a role as data node, etc..

They are data centric and therefor they all must have the same data.
To achieve at least one failure, you must have 3 members (to avoid split brain situation).

3 is always safer than 2 ;) and of course this is a very discussed topic for long time and not only in database. Mirroring was never the best HA solution at the end.

So I really NOT encourage you to use only 2 nodes. It's possible (everything is possible) to run it with something like an arbitrator. See https://github.com/mattlord/myarbitratord but I won't recommend it in production.

Cheers,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: group replication with 2 data nodes and a witness?
2081
January 05, 2018 02:34AM


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.