MySQL Forums
Forum List  »  InnoDB

MySQL Group Replication - does read only operations supported for disconnected node?
Posted by: Evgeni Aizikovich
Date: May 29, 2017 07:46AM

Please consider the following topology of some organization, consisting of 4 branches (A,B,C,D). All branches are located in different geo locations and interconnected with VPN.

This organization using a solution based on MySQL. In order to provide High Availability and improve scalability, I considering to use MySQL Group Replication. I planning to put in each branch a database node, so all "read" operations will be performed from local node, while "write" operations will be performed on primary "master".

I reviewed MySQL documentation several times but I can't find a clear answer to this question: in case of VPN disconnection in some branch (e.g. database will be not connected anymore to Group), does that branch still will be able to perform "read" operations against local database node?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Group Replication - does read only operations supported for disconnected node?
92
May 29, 2017 07:46AM


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.