Re: Router and Group Replication

[J Sauve]

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