[MDEV-16800] Instead of master_use_gtid=current_pos , create gtid_slave_pos_from_master=1; Created: 2018-07-23  Updated: 2021-10-25

Status: Open
Project: MariaDB Server
Component/s: Replication
Fix Version/s: None

Type: Task Priority: Major
Reporter: Sachin Setiya (Inactive) Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Make an option to CHANGE MASTER that updates the
gtid_slave_pos at_the_time_of_that_command_only, like a one-shot
master_use_gtid=current_pos. Eg. something like:

CHANGE MASTER TO master_host=xxx ... gtid_slave_pos_from_master=1;

The idea is that to make old master a slave, a CHANGE MASTER command will
usually be needed anyway. And that is the point at which user wants the
binlog position to migrate to the slave position.

But with the current master_use_gtid=current_pos, this migration happens at
every future slave reconnect, which is very much not expected, and users are
all the time confused that a random manual transation on their slave later
makes GTID replication break.

Credit:- Kristian


Generated at Thu Feb 08 08:31:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.