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

Implement MASTER_BIND for CHANGE MASTER

    XMLWordPrintable

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

          Activity

            People

              Unassigned Unassigned
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              5 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.