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

Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for mysqlbinlog

Details

    Description

      In addition to the features requested in MDEV-4989, it would also be helpful to filter GTIDs based on specific gtid_domain_id values when using mysqlbinlog. To do this, mysqlbinlog could have the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options, which would be similar to the DO_DOMAIN_IDS, IGNORE_DOMAIN_IDS, and IGNORE_SERVER_IDS options available for CHANGE MASTER TO.

      https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids

      https://mariadb.com/kb/en/library/change-master-to/#ignore_domain_ids

      https://mariadb.com/kb/en/library/change-master-to/#ignore_server_ids

      From the commit message:
      "For completeness, this patch additionally adds the option --do-server-ids as an alias for
      --server-id, which now accepts a list of server ids instead of a
      single one."

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-28112 prepare 10.9.0 preview releases

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-4989 Support for GTID in mysqlbinlog

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-22905 Support DO_DOMAIN_IDS and IGNORE_DOMAIN_IDS in replication handshake

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MXS-2581 Support DO_DOMAIN_IDS and IGNORE_DOMAIN_IDS for the Binlog Router

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MXS-2589 Adapt binlog router to

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Field Original Value New Value
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Labels mysqlbinlog replication
            GeoffMontee Geoff Montee (Inactive) made changes -
            Labels mysqlbinlog replication gtid mysqlbinlog replication
            julien.fritsch Julien Fritsch made changes -
            Assignee Andrei Elkin [ elkin ] Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5 [ 23123 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Andrei Elkin [ elkin ]
            bnestere Brandon Nesterenko made changes -
            Assignee Andrei Elkin [ elkin ] Brandon Nesterenko [ JIRAUSER48702 ]
            bnestere Brandon Nesterenko made changes -
            Fix Version/s 10.7 [ 24805 ]
            bnestere Brandon Nesterenko made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bnestere Brandon Nesterenko added a comment -

            Hi Andrei,

            This relies on some ground-work laid by MDEV-4989, so it pends your review of that, but it is good for review otherwise.

            Commit: 85214cb4f7386bf10aa20fa7d97c2a46cb926001

            Buildbot: bb-10.7-MDEV-20119

            bnestere Brandon Nesterenko added a comment - Hi Andrei, This relies on some ground-work laid by MDEV-4989 , so it pends your review of that, but it is good for review otherwise. Commit: 85214cb4f7386bf10aa20fa7d97c2a46cb926001 Buildbot: bb-10.7-MDEV-20119
            bnestere Brandon Nesterenko made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ] Andrei Elkin [ elkin ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.7 [ 24805 ]
            bnestere Brandon Nesterenko made changes -
            Assignee Andrei Elkin [ elkin ] Brandon Nesterenko [ JIRAUSER48702 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            bnestere Brandon Nesterenko added a comment -

            Changing status back to in progress to update with MDEV-4989 comments.

            bnestere Brandon Nesterenko added a comment - Changing status back to in progress to update with MDEV-4989 comments.
            bnestere Brandon Nesterenko made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            bnestere Brandon Nesterenko made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 98416 ] MariaDB v4 [ 131835 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.8 [ 26121 ]
            bnestere Brandon Nesterenko added a comment - - edited

            Hi Andrei! This is ready for review

            Commit: b8e3790bd5f9ee
            BB: bb-10.9-MDEV-20119

            Edit: Updated commit to account for gtid-strict-mode fixes

            bnestere Brandon Nesterenko added a comment - - edited Hi Andrei! This is ready for review Commit: b8e3790 bd5f9ee BB: bb-10.9-MDEV-20119 Edit: Updated commit to account for gtid-strict-mode fixes
            bnestere Brandon Nesterenko made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ] Andrei Elkin [ elkin ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.10 [ 27530 ]
            Fix Version/s 10.9 [ 26905 ]
            bnestere Brandon Nesterenko made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            bnestere Brandon Nesterenko made changes -
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Angelique Sklavounos [ JIRAUSER50741 ]
            serg Sergei Golubchik made changes -
            julien.fritsch Julien Fritsch made changes -
            Description In addition to the features requested in MDEV-4989, it would also be helpful to filter GTIDs based on specific gtid_domain_id values when using mysqlbinlog. To do this, mysqlbinlog could have the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options, which would be similar to the DO_DOMAIN_IDS, IGNORE_DOMAIN_IDS, and IGNORE_SERVER_IDS options available for CHANGE MASTER TO.

            https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_server_ids             		In addition to the features requested in MDEV-4989, it would also be helpful to filter GTIDs based on specific gtid_domain_id values when using mysqlbinlog. To do this, mysqlbinlog could have the --do-domain-ids, --ignore-domain-ids, and --ignore-server\-ids options, which would be similar to the DO_DOMAIN_IDS, IGNORE_DOMAIN_IDS, and IGNORE_SERVER_IDS options available for CHANGE MASTER TO.

            https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_server_ids
            julien.fritsch Julien Fritsch made changes -
            Description In addition to the features requested in MDEV-4989, it would also be helpful to filter GTIDs based on specific gtid_domain_id values when using mysqlbinlog. To do this, mysqlbinlog could have the --do-domain-ids, --ignore-domain-ids, and --ignore-server\-ids options, which would be similar to the DO_DOMAIN_IDS, IGNORE_DOMAIN_IDS, and IGNORE_SERVER_IDS options available for CHANGE MASTER TO.

            https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_server_ids             		In addition to the features requested in MDEV-4989, it would also be helpful to filter GTIDs based on specific gtid_domain_id values when using mysqlbinlog. To do this, mysqlbinlog could have the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options, which would be similar to the DO_DOMAIN_IDS, IGNORE_DOMAIN_IDS, and IGNORE_SERVER_IDS options available for CHANGE MASTER TO.

            https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_server_ids
            angelique.sklavounos Angelique Sklavounos (Inactive) added a comment -

            OK to push.

            angelique.sklavounos Angelique Sklavounos (Inactive) added a comment - OK to push.
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Assignee Angelique Sklavounos [ JIRAUSER50741 ] Brandon Nesterenko [ JIRAUSER48702 ]
            bnestere Brandon Nesterenko made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            bnestere Brandon Nesterenko added a comment -

            Final commit: c132bce

            bnestere Brandon Nesterenko added a comment - Final commit: c132bce
            bnestere Brandon Nesterenko made changes -
            Fix Version/s 10.9.1 [ 27114 ]
            Fix Version/s 10.9 [ 26905 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels gtid mysqlbinlog replication Preview_10.9 gtid mysqlbinlog replication
            ralf.gebhardt Ralf Gebhardt made changes -
            Description In addition to the features requested in MDEV-4989, it would also be helpful to filter GTIDs based on specific gtid_domain_id values when using mysqlbinlog. To do this, mysqlbinlog could have the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options, which would be similar to the DO_DOMAIN_IDS, IGNORE_DOMAIN_IDS, and IGNORE_SERVER_IDS options available for CHANGE MASTER TO.

            https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_server_ids             		In addition to the features requested in MDEV-4989, it would also be helpful to filter GTIDs based on specific gtid_domain_id values when using mysqlbinlog. To do this, mysqlbinlog could have the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options, which would be similar to the DO_DOMAIN_IDS, IGNORE_DOMAIN_IDS, and IGNORE_SERVER_IDS options available for CHANGE MASTER TO.

            https://mariadb.com/kb/en/library/change-master-to/#do_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_domain_ids

            https://mariadb.com/kb/en/library/change-master-to/#ignore_server_ids

            From the commit message:
            "For completeness, this patch additionally adds the option --do-server-ids as an alias for
            --server-id, which now accepts a list of server ids instead of a
            single one."
            Richard Richard Stracke made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 125514

            People

              bnestere Brandon Nesterenko
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              10 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.