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

          Activity

            GeoffMontee Geoff Montee (Inactive) created issue -
            hholzgra Hartmut Holzgraefe made changes -
            Field Original Value New Value
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4 [ 22408 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 95364 ] MariaDB v4 [ 131062 ]
            AirFocus AirFocus made changes -
            Description MySQL has allowed the MASTER_BIND option for CHANGE MASTER since MySQL 5.6.2:

            {quote}
            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.
            {quote}

            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
            MySQL has allowed the MASTER\_BIND option for CHANGE MASTER since MySQL 5.6.2:

            {quote}
            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.
            {quote}

            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
            danblack Daniel Black made changes -
            danblack Daniel Black made changes -
            Labels compat56 Papercut beginner-friendly compat56
            julien.fritsch Julien Fritsch made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Papercut beginner-friendly compat56 Compatibility MySQL Papercut beginner-friendly compat56
            julien.fritsch Julien Fritsch made changes -
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ]
            ParadoxV5 Jimmy Hú made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ] Jimmy Hú [ JIRAUSER55761 ]
            ParadoxV5 Jimmy Hú made changes -
            ParadoxV5 Jimmy Hú made changes -
            ParadoxV5 Jimmy Hú made changes -
            Fix Version/s 12.0 [ 29945 ]
            ParadoxV5 Jimmy Hú made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ParadoxV5 Jimmy Hú made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            ParadoxV5 Jimmy Hú made changes -
            Assignee Jimmy Hú [ JIRAUSER55761 ] Susil Behera [ JIRAUSER40751 ]
            bnestere Brandon Nesterenko made changes -
            Fix Version/s 12.1 [ 29992 ]
            Fix Version/s 12.0 [ 29945 ]
            bnestere Brandon Nesterenko made changes -
            Fix Version/s 12.0 [ 29945 ]
            Fix Version/s 12.1 [ 29992 ]
            bnestere Brandon Nesterenko made changes -
            Assignee Susil Behera [ JIRAUSER40751 ] Brandon Nesterenko [ JIRAUSER48702 ]
            bnestere Brandon Nesterenko made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            bnestere Brandon Nesterenko made changes -
            Status Stalled [ 10000 ] In Review [ 10002 ]
            bnestere Brandon Nesterenko made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ] Jimmy Hú [ JIRAUSER55761 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 12.1 [ 29992 ]
            Fix Version/s 12.0 [ 29945 ]

            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.