MySQL multihomed source IP

AtmanActive has asked for the wisdom of the Perl Monks concerning the following question:

Hello all!

I'm wondering, is there a way to specify source IP address when connecting to remote MySQL via TCP (DBI/DBD) on multihomed machines.

Like 'bind to' option, or parameter or variable or something.

Thanks.

Cheers!

Comment on MySQL multihomed source IP

Replies are listed 'Best First'.
Re: MySQL multihomed source IP by Anonymous Monk on Nov 07, 2012 at 22:09 UTC
Sure, the answer is in the mysql documentation (IIRC host=), see also http://www.ConnectionStrings.com/	[reply]
Re^2: MySQL multihomed source IP by Anonymous Monk on Nov 07, 2012 at 22:47 UTC
Actually that won't work. If you're using DBD::mysqlPP you need to patch it to take LocalAddr and pass it along to Net::MySQL so it can pass it along to IO::Socket::INET bind-address= is supposed to work for libmysqlclient (ie DBD::mysql) but not all versions support this	[reply]
Re^3: MySQL multihomed source IP by AtmanActive (Novice) on Nov 08, 2012 at 09:52 UTC
Yes, that's true. It looks like one needs to upgrade to MySQL v5.6.1+ to have this feature. As this page states: http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_bind-address --bind-address=ip_address On a computer having multiple network interfaces, this option can be used to select which interface is employed when connecting to the MySQL server. This option is supported beginning with MySQL 5.6.1. Thanks for the info!	[reply]
Re^2: MySQL multihomed source IP by AtmanActive (Novice) on Nov 08, 2012 at 07:55 UTC
No, no, and no, host parameter is destination IP, ie to which IP to connect to, but I'm looking for source IP, ie from which IP to connect.	[reply]