Type:
Priority:
Resolution:
Unresolved
Fix Version/s:
None
Client library has the MYSQL_OPT_BIND option for this already, so the feature only needs to be exposed via command line option handling.
MySQLs client binaries have this option since 5.6, and had it even earlier in the MySQL Cluster releases.
mysql-5.6.40 > bin/mysql --help | grep bind
--bind-address=name IP address to bind to.
bind-address (No default value)
Background: when a client system has multiple interfaces / IP addresses, the OS kernel can pick whatever interface it prefers to connect to the server. Especially if multiple client IPs are in the same network, this usually means: pick the first one it has in the interface list.
I originally implemented the patch for this back when still working for MySQL AB, as back then my Laptop would always choose to do replication with my desktop over slow/shared WLAN, even when having a cable plugged in that connected it to the desktop directly, as the WLAN device was somehow always initialized first ...
relates to
MDEV-19248
Implement MASTER_BIND for CHANGE MASTER
Stalled
links to
made changes -
2021-12-06 21:21
Workflow
MariaDB v3
[ 102966
]
MariaDB v4
[ 131215
]
made changes -
2023-09-06 21:00
Assignee
Daniel Black
[ danblack
]
made changes -
2023-09-29 19:13
Labels
beginner-friendly
Compatibility beginner-friendly upstream-5.6
made changes -
2023-11-12 22:23
Fix Version/s
11.4
[ 29301
]
made changes -
2023-11-17 08:05
issue.field.resolutiondate
2023-11-17 08:05:22.0
2023-11-17 08:05:22.419
made changes -
2023-11-17 08:05
Fix Version/s
11.4.1
[ 29523
]
Fix Version/s
11.4
[ 29301
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
made changes -
2023-11-17 09:36
Resolution
Fixed
[ 1
]
Status
Closed
[ 6
]
Stalled
[ 10000
]
made changes -
2023-11-17 09:36
Fix Version/s
11.4
[ 29301
]
Fix Version/s
11.4.1
[ 29523
]
made changes -
2023-11-17 22:03
Status
Stalled
[ 10000
]
In Testing
[ 10301
]
made changes -
2023-11-17 22:03
Assignee
Daniel Black
[ danblack
]
made changes -
2023-11-19 13:40
Assignee
Elena Stepanova
[ elenst
]
made changes -
2023-11-19 21:04
Assignee
Elena Stepanova
[ elenst
]
Ramesh Sivaraman
[ JIRAUSER48189
]
made changes -
2023-12-05 16:46
Priority
Major
[ 3
]
Critical
[ 2
]
made changes -
2023-12-12 21:24
Issue Type
Task
[ 3
]
New Feature
[ 2
]
made changes -
2023-12-22 17:45
Fix Version/s
11.5
[ 29506
]
Fix Version/s
11.4
[ 29301
]
made changes -
2024-01-16 06:13
Assignee
Ramesh Sivaraman
[ JIRAUSER48189
]
Daniel Black
[ danblack
]
Status
In Testing
[ 10301
]
Stalled
[ 10000
]
made changes -
2024-03-19 18:31
Fix Version/s
11.6
[ 29515
]
Fix Version/s
11.5
[ 29506
]
made changes -
2024-03-21 06:44
Fix Version/s
11.5
[ 29506
]
Fix Version/s
11.6
[ 29515
]
made changes -
2024-03-22 06:22
Fix Version/s
11.6
[ 29515
]
Fix Version/s
11.5
[ 29506
]
made changes -
2024-03-22 06:22
Status
Stalled
[ 10000
]
In Progress
[ 3
]
made changes -
2024-05-05 10:25
Status
In Progress
[ 3
]
Stalled
[ 10000
]
made changes -
2024-06-04 15:39
Fix Version/s
11.7
[ 29815
]
Fix Version/s
11.6
[ 29515
]
made changes -
2024-09-24 13:54
Fix Version/s
11.8
[ 29921
]
Fix Version/s
11.7
[ 29815
]
made changes -
2024-12-10 10:46
Priority
Critical
[ 2
]
Minor
[ 4
]
made changes -
2025-02-06 07:19
Labels
Compatibility beginner-friendly upstream-5.6
Compatibility beginner-friendly foundation upstream-5.6
made changes -
2025-03-11 18:31
Remote Link
This issue links to "MySQL 9.2 (Web Link)"
[ 37451
]
{"report":{"fcp":1044.5999999046326,"ttfb":300.59999990463257,"pageVisibility":"visible","entityId":82262,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"972eefd9-02a0-4222-8d15-3e9a25f8b5d2","navigationType":0,"readyForUser":1116,"redirectCount":0,"resourceLoadedEnd":1350,"resourceLoadedStart":306,"resourceTiming":[{"duration":253.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":306,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":306,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":559.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":253.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":306.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":306.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":559.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":262.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":306.40000009536743,"connectEnd":306.40000009536743,"connectStart":306.40000009536743,"domainLookupEnd":306.40000009536743,"domainLookupStart":306.40000009536743,"fetchStart":306.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":306.40000009536743,"responseEnd":569.2000002861023,"responseStart":569.2000002861023,"secureConnectionStart":306.40000009536743},{"duration":292.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":306.59999990463257,"connectEnd":306.59999990463257,"connectStart":306.59999990463257,"domainLookupEnd":306.59999990463257,"domainLookupStart":306.59999990463257,"fetchStart":306.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":306.59999990463257,"responseEnd":599.4000000953674,"responseStart":599.4000000953674,"secureConnectionStart":306.59999990463257},{"duration":296.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":306.7000002861023,"connectEnd":306.7000002861023,"connectStart":306.7000002861023,"domainLookupEnd":306.7000002861023,"domainLookupStart":306.7000002861023,"fetchStart":306.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":306.7000002861023,"responseEnd":603.5,"responseStart":603.5,"secureConnectionStart":306.7000002861023},{"duration":297.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":306.90000009536743,"connectEnd":306.90000009536743,"connectStart":306.90000009536743,"domainLookupEnd":306.90000009536743,"domainLookupStart":306.90000009536743,"fetchStart":306.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":306.90000009536743,"responseEnd":604.3000001907349,"responseStart":604.3000001907349,"secureConnectionStart":306.90000009536743},{"duration":297.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":307,"connectEnd":307,"connectStart":307,"domainLookupEnd":307,"domainLookupStart":307,"fetchStart":307,"redirectEnd":0,"redirectStart":0,"requestStart":307,"responseEnd":604.5999999046326,"responseStart":604.5999999046326,"secureConnectionStart":307},{"duration":405.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":307.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":307.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":712.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":298,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":307.40000009536743,"connectEnd":307.40000009536743,"connectStart":307.40000009536743,"domainLookupEnd":307.40000009536743,"domainLookupStart":307.40000009536743,"fetchStart":307.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":307.40000009536743,"responseEnd":605.4000000953674,"responseStart":605.4000000953674,"secureConnectionStart":307.40000009536743},{"duration":405.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":307.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":307.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":712.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":298.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":307.80000019073486,"connectEnd":307.80000019073486,"connectStart":307.80000019073486,"domainLookupEnd":307.80000019073486,"domainLookupStart":307.80000019073486,"fetchStart":307.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":307.80000019073486,"responseEnd":606.0999999046326,"responseStart":606.0999999046326,"secureConnectionStart":307.80000019073486},{"duration":1010.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":313.5,"connectEnd":313.5,"connectStart":313.5,"domainLookupEnd":313.5,"domainLookupStart":313.5,"fetchStart":313.5,"redirectEnd":0,"redirectStart":0,"requestStart":313.5,"responseEnd":1324.2000002861023,"responseStart":1324.2000002861023,"secureConnectionStart":313.5},{"duration":1002.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":322.80000019073486,"connectEnd":322.80000019073486,"connectStart":322.80000019073486,"domainLookupEnd":322.80000019073486,"domainLookupStart":322.80000019073486,"fetchStart":322.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":322.80000019073486,"responseEnd":1325.5999999046326,"responseStart":1325.5999999046326,"secureConnectionStart":322.80000019073486},{"duration":76.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":724.5,"connectEnd":724.5,"connectStart":724.5,"domainLookupEnd":724.5,"domainLookupStart":724.5,"fetchStart":724.5,"redirectEnd":0,"redirectStart":0,"requestStart":724.5,"responseEnd":801,"responseStart":801,"secureConnectionStart":724.5},{"duration":347.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":997.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":997.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1345.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":347.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":997.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":997.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1345.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":341,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":998.5999999046326,"connectEnd":998.5999999046326,"connectStart":998.5999999046326,"domainLookupEnd":998.5999999046326,"domainLookupStart":998.5999999046326,"fetchStart":998.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":998.5999999046326,"responseEnd":1339.5999999046326,"responseStart":1339.5999999046326,"secureConnectionStart":998.5999999046326},{"duration":349.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":999,"connectEnd":999,"connectStart":999,"domainLookupEnd":999,"domainLookupStart":999,"fetchStart":999,"redirectEnd":0,"redirectStart":0,"requestStart":999,"responseEnd":1348.5999999046326,"responseStart":1348.5999999046326,"secureConnectionStart":999},{"duration":350.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/e0bf5781d46ea69fb123572974cf39de-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":999.2000002861023,"connectEnd":999.2000002861023,"connectStart":999.2000002861023,"domainLookupEnd":999.2000002861023,"domainLookupStart":999.2000002861023,"fetchStart":999.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":999.2000002861023,"responseEnd":1350,"responseStart":1350,"secureConnectionStart":999.2000002861023},{"duration":425.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1037.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1037.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1463.0999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":51,"responseStart":300,"responseEnd":322,"domLoading":304,"domInteractive":1402,"domContentLoadedEventStart":1402,"domContentLoadedEventEnd":1458,"domComplete":1915,"loadEventStart":1915,"loadEventEnd":1917,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1356.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1356.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1357},{"name":"bigPipe.activity-panel-pipe-id.end","time":1363.3000001907349},{"name":"activityTabFullyLoaded","time":1480.7000002861023}],"measures":[],"correlationId":"bbf58dd3d56829","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":188,"dbReadsTimeInMs":40,"dbConnsTimeInMs":51,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
New Feature
Minor
