Re: MySQL multihomed source IP

Sure, the answer is in the mysql documentation (IIRC host=), see also http://www.ConnectionStrings.com/

Comment on Re: MySQL multihomed source IP

Replies are listed 'Best First'.
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]