[Maria-discuss] Binding to network addresses
I am not sure whether this has been discussed.
MySQL either binds to all network interfaces/addresses or to only single specified network address.
Wouldn't this limitation be nice to have fixed in MariaDB, say I want to bind to 127.0.0.1 and a VIP network address, maybe management network address, but not to all network addresses on a server?
Hi Viljo
On 01/12/2009, at 5:40 AM, Viljo Hakala wrote:
I am not sure whether this has been discussed.
MySQL either binds to all network interfaces/addresses or to only single specified network address.
Wouldn't this limitation be nice to have fixed in MariaDB, say I want to bind to 127.0.0.1 and a VIP network address, maybe management network address, but not to all network addresses on a server?
Would be nice, but with iptables it's fairly easy to do anyway. IPv6 is more interesting IMHO.
Cheers, Arjen.
Hi Arjen,
But iptables is not multiplatform! And these kind of "workarounds" do not really fix the issue.
And if you are a DBA, you rarely touch iptables, which is another layer of "surprises" on a database server?
So rather than avoiding to fix it, why not just do it?
At least 3 "bug" reports / feature reaquests since 2006 on the Bugs.MySQL.com.
________________________________ From: Arjen Lentz arjen@openquery.com To: Maria Discuss maria-discuss@lists.launchpad.net Sent: Tue, December 1, 2009 1:19:26 AM Subject: Re: [Maria-discuss] Binding to network addresses
Hi Viljo
On 01/12/2009, at 5:40 AM, Viljo Hakala wrote:
I am not sure whether this has been discussed.
MySQL either binds to all network interfaces/addresses or to only single specified network address.
Wouldn't this limitation be nice to have fixed in MariaDB, say I want to bind to 127.0.0.1 and a VIP network address, maybe management network address, but not to all network addresses on a server?
Would be nice, but with iptables it's fairly easy to do anyway. IPv6 is more interesting IMHO.
Cheers, Arjen.
participants (2)
-
Arjen Lentz
-
Viljo Hakala