[MDEV-24377] [Feature suggestion] Allow listening of multiple IP (bind-address). MySQL 8.0 has that. Created: 2020-12-09 Updated: 2022-12-04 Resolved: 2022-10-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Fix Version/s: | 10.11.1 |
| Type: | Task | Priority: | Minor |
| Reporter: | naox | Assignee: | Rinat Ibragimov (Inactive) |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | beginner-friendly | ||
| Description |
|
[Feature suggestion] Allow listening of multiple IP (bind-address). MySQL 8.0 has that. It allows specifying --bind-address coma separated values. I've been waiting for that feature for more than 15 years and I have to use socat to "bridge" ports on diffrent interfaces (IPs). https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_bind_address |
| Comments |
| Comment by Vladislav Vaintroub [ 2020-12-09 ] |
|
I don't think we disallow listening on multiple IP, because we allow wildcard. We currently do not allow listening selectively on some IP, so it is either one or all. |
| Comment by naox [ 2020-12-09 ] |
|
Yes and that is bad because if you have multiple mariadb servers that neeed to listen on port 3306, each on two IPs there is no way to do it. Oracle mysql 8.0 managed to solve it hence this feature request. |
| Comment by naox [ 2020-12-10 ] |
|
Use example: You want multiple mariadb servers on same machine, on port 3306 that are accessible globaly both via some ipv6 (because IPv4 are scarse) and through LAN on private IP ranges (other clients on LAN can not connect to IPv6). No can do. I've made that feature suggestion to Mysql AB in 2004 so it only took 16 years and two companies to make that possible. I wonder if I will live long enough to see that in mariadb. |
| Comment by Vladislav Vaintroub [ 2020-12-10 ] |
|
nobody can predict whether you live long enough, in these times, but you also waited for 11 years of MariaDB existence to make this suggestion, so maybe you can't expect this to be implemented by tomorrow. |
| Comment by Sergei Golubchik [ 2020-12-10 ] |
|
I think this should be easy to implement after |
| Comment by naox [ 2021-12-11 ] |
|
|
| Comment by Gene Wood [ 2022-12-04 ] |
|
This has been fixed and is slated for release in version 10.11.1 |