Re: Force slave to connect from specified IP
Irek Slonina [EMAIL PROTECTED] wrote: I have two interfaces on my slave: ppp0 80.80.80.8 ( - Internet ) eth0 10.10.10.1 ( - LAN ) and remote master host 192.168.168.168 available by 80.80.80.8. How can I force mysql to start slave processes using 10.10.10.1 and not 80.80.80.8, which is he choosing by defualt. I need similiar behaviour like: ping -I 10.10.10.1 192.168.168.168 I have tried to bind mysqld only to 10.10.10.1:3336 by bind-address option but that does not make the thing. Correcting routes doesn't help? I can't surely understand what you need. To specify the source IP? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Force slave to connect from specified IP
Hello, I have two interfaces on my slave: ppp0 80.80.80.8 ( - Internet ) eth0 10.10.10.1 ( - LAN ) and remote master host 192.168.168.168 available by 80.80.80.8. How can I force mysql to start slave processes using 10.10.10.1 and not 80.80.80.8, which is he choosing by defualt. I need similiar behaviour like: ping -I 10.10.10.1 192.168.168.168 I have tried to bind mysqld only to 10.10.10.1:3336 by bind-address option but that does not make the thing. I would be very thankful for any hints, for now I will try to redirect this with firewall. Regards, Irek Slonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]