Re: MySQL replication breaks when taking backups.

[Reio Remma]

Pertinent settings from MySQL configuration:


log-timestamps = SYSTEM
innodb-flush-log-at-trx-commit = 1
innodb-fast-shutdown = 0
sync-binlog = 1
enforce-gtid-consistency = ON
gtid-mode = ON
binlog-format = ROW
binlog-expire-logs-seconds = 604800
binlog-cache-size = 131072
log-replica-updates = OFF

# Disable InnoDB doublewrite buffer on ZFS.
#
skip-innodb-doublewrite

rpl-semi-sync-source-wait-point = AFTER_SYNC
rpl-semi-sync-source-wait-for-replica-count = 1
rpl-semi-sync-source-wait-no-replica = ON
rpl-semi-sync-source-timeout = 500
rpl-semi-sync-source-enabled = ON