Details

      Description

      Provide a mechanism to filter replication events on the slave replication
      server based on domain_id.

      New master definitions:

      (1) DO_DOMAIN_IDS = (N[,N])

      • Accepts a comma-separated list of domain_ids, the replication events of
        which will be kept.
      • If a CHANGE MASTER command is executed without DO_DOMAIN_IDS, the
        existing list of domain ids (if any) would be preserved.
      • DO_DOMAIN_IDS=() can be used to clear the list.
      • The list should show in SHOW MASTER STATUS output and master_info file.
      • On restart, the list should automatically get populated from master_info.

      (2) IGNORE_DOMAIN_IDS = (N[,N])

      • Accepts a comma-separated list of domain_ids, the replication events of
        which will be filtered out.
      • If a CHANGE MASTER command is executed without IGNORE_DOMAIN_IDS, the
        existing list of domain ids (if any) would be preserved.
      • IGNORE_DOMAIN_IDS=() can be used to clear the list.
      • The list should show in SHOW MASTER STATUS output and master_info file.
      • On restart, the list should automatically get populated from master_info.

      Additional notes:

      • The list preservation rule is consistent with IGNORE_SERVER_IDS.
      • Both the lists (DO_ & IGNORE_) cannot be non-empty at the same time.
      • CHANGE MASTER TO command would fail with ER_MASTER_INFO if it tries
        to set both the lists.

      Examples:

      CHANGE MASTER TO .. IGNORE_DOMAIN_IDS= (1,2,3) .. ;
      CHANGE MASTER TO .. DO_DOMAIN_IDS= (99) .. ;
      CHANGE MASTER TO .. DO_DOMAIN_IDS= () .. ;

      $ tail -2 master.info
      do_domain_ids=0
      ignore_domain_ids=3 1 2 3

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              knielsen Kristian Nielsen added a comment -

              It might be better to do it like ignored server ids. Eg.

              CHANGE MASTER TO IGNORE_DOMAIN_IDS= (1,2)
              CHANGE MASTER TO ONLY_DOMAIN_IDS= (0)

              This way, it is possible to configure it per master connection, which would seem to be useful.

              Show
              knielsen Kristian Nielsen added a comment - It might be better to do it like ignored server ids. Eg. CHANGE MASTER TO IGNORE_DOMAIN_IDS= (1,2) CHANGE MASTER TO ONLY_DOMAIN_IDS= (0) This way, it is possible to configure it per master connection, which would seem to be useful.
              Hide
              nirbhay_c Nirbhay Choubey added a comment -

              Hi Kristian,
              Thanks for the suggestion. I have updated the description accordingly.

              Show
              nirbhay_c Nirbhay Choubey added a comment - Hi Kristian, Thanks for the suggestion. I have updated the description accordingly.
              Show
              nirbhay_c Nirbhay Choubey added a comment - http://lists.askmonty.org/pipermail/commits/2014-September/006553.html
              Show
              knielsen Kristian Nielsen added a comment - https://lists.launchpad.net/maria-developers/msg07703.html https://lists.launchpad.net/maria-developers/msg07704.html
              Show
              nirbhay_c Nirbhay Choubey added a comment - http://lists.askmonty.org/pipermail/commits/2014-November/006904.html
              Hide
              knielsen Kristian Nielsen added a comment - - edited
              Show
              knielsen Kristian Nielsen added a comment - - edited Review sent on maria-developers@: https://lists.launchpad.net/maria-developers/msg07895.html
              Show
              nirbhay_c Nirbhay Choubey added a comment - http://lists.askmonty.org/pipermail/commits/2014-November/007040.html
              Show
              nirbhay_c Nirbhay Choubey added a comment - https://github.com/MariaDB/server/commit/a50ddebb5cfa7b79540d155e8e41c7a07c4c3fbf

                People

                • Assignee:
                  nirbhay_c Nirbhay Choubey
                  Reporter:
                  nirbhay_c Nirbhay Choubey
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: