Details
-
New Feature
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
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
-
MDEV-28906 MySQL 8.0 desired compatibility
-
- Open
-
- relates to
-
MDEV-21465 Add --bind-address parameter for outgoing client connections
-
- Stalled
-
- links to
Activity
Field | Original Value | New Value |
---|---|---|
Link | This issue relates to MDEV-21465 [ MDEV-21465 ] |
Fix Version/s | 10.4 [ 22408 ] |
Workflow | MariaDB v3 [ 95364 ] | MariaDB v4 [ 131062 ] |
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 |
Link | This issue is part of MDEV-28906 [ MDEV-28906 ] |
Labels | compat56 | Papercut beginner-friendly compat56 |
Issue Type | Task [ 3 ] | New Feature [ 2 ] |
Labels | Papercut beginner-friendly compat56 | Compatibility MySQL Papercut beginner-friendly compat56 |
Assignee | Sergei Golubchik [ serg ] |
Assignee | Sergei Golubchik [ serg ] |
Assignee | Brandon Nesterenko [ JIRAUSER48702 ] |
Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Jimmy Hú [ JIRAUSER55761 ] |
Remote Link | This issue links to "MySQL 9.2 (Web Link)" [ 37438 ] |
Remote Link | This issue links to "WL#3127 (Web Link)" [ 37439 ] |
Fix Version/s | 12.0 [ 29945 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | In Testing [ 10301 ] |
Assignee | Jimmy Hú [ JIRAUSER55761 ] | Susil Behera [ JIRAUSER40751 ] |
Fix Version/s | 12.1 [ 29992 ] | |
Fix Version/s | 12.0 [ 29945 ] |
Fix Version/s | 12.0 [ 29945 ] | |
Fix Version/s | 12.1 [ 29992 ] |
Assignee | Susil Behera [ JIRAUSER40751 ] | Brandon Nesterenko [ JIRAUSER48702 ] |
Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
Status | Stalled [ 10000 ] | In Review [ 10002 ] |
Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Jimmy Hú [ JIRAUSER55761 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Fix Version/s | 12.1 [ 29992 ] | |
Fix Version/s | 12.0 [ 29945 ] |