Re: Is Group Replication compatible with semisynchronous replication?

Le mardi 4 décembre 2018 11:34:48 UTC+1, Axel Schwenke a écrit :
> 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.

Hi Axel,
Thank you for your clear respsonse.

The question was about a particular context: replication between two InnoDB clusters : https://lefred.be/content/mysql-innodb-cluster-with-2-data-centers-for-disaster-recovery-howto/#comment-53252

Regards
Youcef HILEM Received on Fri Dec 07 2018 - 20:18:34 CET