Details
-
New Feature
-
Status: Stalled (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
Description
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 ...
Attachments
Issue Links
- relates to
-
-
- Stalled
-
- links to
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to MDEV-19248 [ MDEV-19248 ] |
| Fixing Priority | 250 |
| Workflow | MariaDB v3 [ 102966 ] | MariaDB v4 [ 131215 ] |
| Labels | beginner-friendly |
| Assignee | Daniel Black [ danblack ] |
| Labels | beginner-friendly | Compatibility beginner-friendly upstream-5.6 |
| Fix Version/s | 11.4 [ 29301 ] |
Thank you very much Iaroslav Babanin for contributing this feature (and especially accommodating my large expansion of scope to all client utils).
| issue.field.resolutiondate | 2023-11-17 08:05:22.0 | 2023-11-17 08:05:22.419 |
| Fix Version/s | 11.4.1 [ 29523 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Fix Version/s | 11.4 [ 29301 ] | |
| Fix Version/s | 11.4.1 [ 29523 ] |
| Status | Stalled [ 10000 ] | In Testing [ 10301 ] |
| Assignee | Daniel Black [ danblack ] |
Please test https://github.com/MariaDB/server/commit/7639be7cca4d2e67b95694e1be5e841fa839e017 from PR 2750
| Assignee | Elena Stepanova [ elenst ] |
| Assignee | Elena Stepanova [ elenst ] | Ramesh Sivaraman [ JIRAUSER48189 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Issue Type | Task [ 3 ] | New Feature [ 2 ] |
| Fix Version/s | 11.5 [ 29506 ] | |
| Fix Version/s | 11.4 [ 29301 ] |
| Assignee | Ramesh Sivaraman [ JIRAUSER48189 ] | Daniel Black [ danblack ] |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Fix Version/s | 11.6 [ 29515 ] | |
| Fix Version/s | 11.5 [ 29506 ] |
| Fix Version/s | 11.5 [ 29506 ] | |
| Fix Version/s | 11.6 [ 29515 ] |
| Fix Version/s | 11.6 [ 29515 ] | |
| Fix Version/s | 11.5 [ 29506 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Fix Version/s | 11.7 [ 29815 ] | |
| Fix Version/s | 11.6 [ 29515 ] |
| Fix Version/s | 11.8 [ 29921 ] | |
| Fix Version/s | 11.7 [ 29815 ] |
| Priority | Critical [ 2 ] | Minor [ 4 ] |
| Fix Version/s | 11.8 [ 29921 ] |
| Labels | Compatibility beginner-friendly upstream-5.6 | Compatibility beginner-friendly foundation upstream-5.6 |
| Rank | Ranked higher |
| Remote Link | This issue links to "MySQL 9.2 (Web Link)" [ 37451 ] |
I would like to work on this. Thanks.