Beefy Boxes and Bandwidth Generously Provided by pair Networks Frank
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: MySQL multihomed source IP

by Anonymous Monk
on Nov 07, 2012 at 22:09 UTC ( #1002760=note: print w/ replies, xml ) Need Help??


in reply to 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
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

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1002760]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2014-04-18 03:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (460 votes), past polls