Re: Is Group Replication compatible with semisynchronous replication?

From: Axel Schwenke <axel.schwenke_at_gmx.de>
Date: Tue, 4 Dec 2018 11:34:46 +0100
Message-ID: <pu5l87$3rv$1_at_dont-email.me>


On 02.12.2018 15:25, HILEM Youcef wrote:
>
> Can the asynchronous replication between the datacenters replaced by semisynchronous replication ?

That question shows that you haven't studied the MySQL documentation at all. Semisync cannot /replace/ the async replication, but is an optional feature of the latter. Once you enable semisync, the replication master will flush a commit not only to the local redo log, but also to at least one slave (you have only one slave, so that's the one).

In effect each COMMIT by the application will have to wait until the BINLOG for that transaction has been shipped to the slave. Depending on the bandwidth and latency between data centers this can impact the performance quite heavily. Received on Tue Dec 04 2018 - 11:34:46 CET

Original text of this message