Status: Closed (View Workflow)
10.6, 10.7, 10.8
MDEV-21117 had to relax own events acceptance condition for a case when
a former semisync master server recovers after crash as the semisync slave.
That however admits a possibility for endless event "orbiting" in the semisync circular setup
where the master is also a slave.
As a work-around CHANGE MASTER TO ... ignore_domain_ids=(`own_domain_id`) can do,
where own_domain_id is the value of this_server@@global.gtid_domain_id. The command should be invoked
on every server node of the circle configuration.
Also @@global.gtid_strict_mode = ON blocks any attempt to execute own event; the event circulation would stop, but the slave errors out.
- relates to
MDEV-28292 Allow both --replicate-same-server-id=on and --log-slave-updates=on to be enabled at the same time