Details

    Description

      The mysqlbinlog client program needs to be updated to support GTID.

      Here is a suggested list of things to be done:

      • The --start-position and --stop-position options should be able to take
        GTID positions; or maybe there should be new --start-gtid and --stop-gtid
        options. Like --start-gtid=0-1-100,1-2-200,2-1-1000.
      • A GTID position means the point just after that GTID. So starting from
        GTID 0-1-100 and stopping at GTID 0-1-200, the first GTID output will
        probably be 0-1-101 and the last one 0-1-200. Note that if some domain is
        not specified in the position, it means to start from the begining,
        respectively stop immediately in that domain.
      • Starting and stopping GTID should work both with local files, and with
        --read-from-remote-server. For the latter, there are a couple of extra
        things that need doing in the master-slave protocol, see
        get_master_version_and_clock() in sql/slave.cc.
      • At the end of the dump, put these statements, to reduce the risk of those session variables incorrectly spilling into subsequent statements run in the same session:

           SET session.server_id = @@global.server_id,
               session.gtid_domain_id=@@global.gtid_domain_id;

        Probably some more things will come up during the work, but this looks like a
        reasonable start.

      Attachments

        Issue Links

          Activity

            MDEV-20119 is somewhat related.

            GeoffMontee Geoff Montee (Inactive) added a comment - MDEV-20119 is somewhat related.
            Elkin Andrei Elkin added a comment -

            {--start.stop}-position may be reused to accept the new type of GTID format string.

            Elkin Andrei Elkin added a comment - { --start.stop}-position may be reused to accept the new type of GTID format string.
            bnestere Brandon Nesterenko added a comment - - edited

            This is ready for review.

            Commit: f7e582ff9c5ace871c9b98ea8465956c1e94fb96

            Buildbot: bb-10.7-MDEV-4989

              • Updated commit Aug 27 with some documentation, code formatting, and slight code changes to help with MDEV-20119
            bnestere Brandon Nesterenko added a comment - - edited This is ready for review. Commit: f7e582ff9c5ace871c9b98ea8465956c1e94fb96 Buildbot: bb-10.7-MDEV-4989 Updated commit Aug 27 with some documentation, code formatting, and slight code changes to help with MDEV-20119

            I have pushed a new commit which addresses an initial round of reviews from Andrei:

            Commit: 02f98a22d2caef7c2953fe02b7f7516cd08c9544
            Buildbot: bb-10.7-MDEV-4989

            bnestere Brandon Nesterenko added a comment - I have pushed a new commit which addresses an initial round of reviews from Andrei: Commit: 02f98a22d2caef7c2953fe02b7f7516cd08c9544 Buildbot: bb-10.7-MDEV-4989
            alice Alice Sherepa added a comment -

            it is ok to push it into 10.8

            alice Alice Sherepa added a comment - it is ok to push it into 10.8

            People

              bnestere Brandon Nesterenko
              knielsen Kristian Nielsen
              Votes:
              23 Vote for this issue
              Watchers:
              30 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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