Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
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
Attachments
Activity
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.
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.
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.
I think this should be easy to implement after MDEV-6536 is closed
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.