MySQL Forums
Forum List  »  InnoDB clusters

Re: Router and Group Replication
Posted by: J Sauve
Date: October 02, 2019 07:48AM

Merci Fred, c'est bien appreciƩ.

Group Replication on it`s own gives me everything I need: redundancy with automatic fail-over. Basically 3 synchronized servers, with one primary handling writes.

If one goes down or is taken out for maintenance, I still have working website and still have redundancy as the other two keep going until the third is ready to be put back in.

The only gap is how do I tell my website what the current primary is.

Even if I write something to query any member before a page load (expensive) I`d have to do a DNS round-robin or something to make sure I`m not always asking the same node, but if one goes down, DNS will still send traffic to it.

If I was doing multi-primary, I could just use a proxy, or even Router, but multi-primary doesn't fit our solution.

I need something to run on all client servers so they all independently agree with the Group as to who is the primary. All on Windows, mostly PHP but one third party app using ODBC.

Is there anything that can do that? I was hoping Router could.

J

Encore une fois, merci

Options: ReplyQuote


Subject
Views
Written By
Posted
4394
January 17, 2019 10:35AM
899
January 24, 2019 11:54AM
612
October 01, 2019 02:06PM
Re: Router and Group Replication
530
October 02, 2019 07:48AM
474
October 07, 2019 07:14AM
474
October 08, 2019 07:20AM


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.