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

Create method to purge a specific domain from gtid_binlog_pos

Details

    Description

      Every once in a while users will request a way to purge one or more specific domains from gtid_binlog_pos. There does not currently seem to be a way to do this. RESET MASTER purges all domains, but it does not let you pick and choose which domains to purge.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-17853 Document that gtid_binlog_pos can lag behind gtid_current_pos after RESET MASTER

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17156 Local transactions on a Slave don't update GTID's gtid_current_pos after RESET MASTER on Slave (master_use_gtid value is not relevant)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17368 RESET MASTER doesn't completely reset gtid_current_pos

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-17369 Document how to reset gtid_current_pos

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Elkin Andrei Elkin added a comment -

            GeoffMontee: Would FLUSH BINARY LOGS DELETE_DOMAIN_ID=(list-of-domains) of MDEV-12012 provide an acceptable solution?

            Elkin Andrei Elkin added a comment - GeoffMontee : Would FLUSH BINARY LOGS DELETE_DOMAIN_ID=(list-of-domains) of MDEV-12012 provide an acceptable solution?
            GeoffMontee Geoff Montee (Inactive) added a comment -

            Hi Elkin,

            I haven't tested FLUSH BINARY LOGS DELETE_DOMAIN_ID=(list-of-domains) yet, but after reading a description of it, it does sound like that would accomplish what this FR is requesting. I didn't know that we had already implemented a feature like that.

            GeoffMontee Geoff Montee (Inactive) added a comment - Hi Elkin , I haven't tested FLUSH BINARY LOGS DELETE_DOMAIN_ID=(list-of-domains) yet, but after reading a description of it, it does sound like that would accomplish what this FR is requesting. I didn't know that we had already implemented a feature like that.

            People

              Elkin Andrei Elkin
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.