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

Implement MASTER_BIND for CHANGE MASTER

Details

    Description

      MySQL has allowed the MASTER_BIND option for CHANGE MASTER since MySQL 5.6.2:

      MASTER_BIND is for use on replication slaves having multiple network interfaces, and determines which of the slave's network interfaces is chosen for connecting to the master.

      The address configured with this option, if any, can be seen in the Master_Bind column of the output from SHOW SLAVE STATUS. If you are using slave status log tables (server started with --master-info-repository=TABLE), the value can also be seen as the Master_bind column of the mysql.slave_master_info table.

      The ability to bind a replication slave to a specific network interface was added in MySQL 5.6.2. This is also supported by MySQL NDB Cluster 7.3.1 and later.

      https://dev.mysql.com/doc/refman/5.6/en/change-master-to.html

      Do we want to implement this option?

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

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21465 Add --bind-address parameter for outgoing client connections

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled
          links to

          Web Link MySQL 9.2

          Web Link WL#3127

          Activity

            Ascending order - Click to sort in descending order
            ParadoxV5 Jimmy Hú added a comment -

            https://github.com/MariaDB/server/pull/3883

            I don’t want this to be merely a dummy compatibility field, yet I can’t tell if the function I coded works. susil.behera could you lend a hand?

            ParadoxV5 Jimmy Hú added a comment - https://github.com/MariaDB/server/pull/3883 I don’t want this to be merely a dummy compatibility field, yet I can’t tell if the function I coded works. susil.behera could you lend a hand?
            susil.behera Susil Behera added a comment -

            ParadoxV5surely!

            susil.behera Susil Behera added a comment - ParadoxV5 surely!
            bnestere Brandon Nesterenko added a comment -

            Taking this for review, as we may still be able to get it into the 12.0 preview

            bnestere Brandon Nesterenko added a comment - Taking this for review, as we may still be able to get it into the 12.0 preview
            bnestere Brandon Nesterenko added a comment -

            Where the code of the patch looks ok, the functionality doesn't actually work. The patch relies on option MYSQL_OPT_BIND, but it looks like that option may be dead. We'll have to investigate further in the 12.1 feature development cycle.

            bnestere Brandon Nesterenko added a comment - Where the code of the patch looks ok, the functionality doesn't actually work. The patch relies on option MYSQL_OPT_BIND , but it looks like that option may be dead. We'll have to investigate further in the 12.1 feature development cycle.

            People

              ParadoxV5 Jimmy Hú
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              9 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.