maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #03788
Semi-sync replication hangs when changing binlog filename.
-
To:
"maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
Joseph Glanville <jpg@xxxxxxxxx>
-
Date:
Fri, 29 Jul 2016 02:11:51 +0000
-
Accept-language:
en-AU, en-US
-
Authentication-results:
spf=none (sender IP is 10.152.252.54) smtp.mailfrom=jpg.id.au; lists.launchpad.net; dkim=none (message not signed) header.d=none;lists.launchpad.net; dmarc=none action=none header.from=jpg.id.au;
-
Spamdiagnosticmetadata:
NSPM
-
Spamdiagnosticoutput:
1:99
-
Thread-index:
AQHR6T6PNgduvAUNBk6tyslXmBACfg==
-
Thread-topic:
Semi-sync replication hangs when changing binlog filename.
Hi,
I am using semi-sync replication with the `rpl_semi_sync_master_timeout` set to a very high value to ensure commits aren't committed on the master unless they have been replicated to the slave.
However whenever the binlog filename changes the replication stalls indefinitely.
A trace of this interaction between the master and the semi-sync slave is here:
https://gist.github.com/josephglanville/e87ae96b9be9125427b58cd3a43d5c1e
The semi-sync settings I have configured on the master are:
rpl_semi_sync_master_wait_point = "AFTER_SYNC"
rpl_semi_sync_master_timeout = 18446744073709551615 # effectively infinite as we don't want to fallback to async repl
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_master_wait_no_slave = 1 # don't allow writes if slave isn't connected
Up until the binlog filename change everything works as expected.
Anyone have any ideas on how to fix the problem or is this a bug in semi-sync replication?
Joseph.
Follow ups
