Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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

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

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?

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (4)
As of 2015-11-29 05:01 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (746 votes), past polls