Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16800

Instead of master_use_gtid=current_pos , create gtid_slave_pos_from_master=1;

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Replication
    • 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

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            sachin.setiya.007 Sachin Setiya (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.