List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:August 12 2009 12:43pm
Subject:Re: Replication - connecting a slave to a master on the same host via
a port or socket
View as plain text  
You can easily get around that behaviour by specifying 127.0.0.1, though :-)

On Tue, Aug 11, 2009 at 8:56 PM, Gavin Towey <gtowey@stripped> wrote:

> Andrew,
>
> Yes it's true, because when you specify localhost, you're using the local
> socket file.  The port only has meaning for TCP connections.
>
> Regards,
> Gavin Towey
>
> -----Original Message-----
> From: Andrew Braithwaite [mailto:andrew.braithwaite@stripped]
> Sent: Tuesday, August 11, 2009 8:38 AM
> To: mysql@stripped
> Subject: RE: Replication - connecting a slave to a master on the same host
> via a port or socket
>
> Ah.  I have found that if you use 'localhost' to connect, you cannot
> specify a port, it silently fails...
>
> You can connect using a hostname (even though it's the same server),
> specifying a port...
>
> Andrew
>
> -----Original Message-----
> From: Andrew Braithwaite [mailto:andrew.braithwaite@stripped]
> Sent: 11 August 2009 16:12
> To: mysql@stripped
> Subject: Replication - connecting a slave to a master on the same host
> via a port or socket
>
> Hi,
>
> I have 2 mysql instances running on a server on different ports with
> different datadirs and different .sock files.
>
> I can connect locally via the sock with the -S flag to mysql but I
> cannot connect locally via port (-P flag).
>
> Does anyone know if there is a way to configure a mysql slave to use a
> socket to connect to a master on localhost?
>
> If not; does anyone know a way to connect to another mysql instance on
> the same linux server using a port?
>
> Thanks for your help,
>
> Andrew
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> The information contained in this transmission may contain privileged and
> confidential information. It is intended only for the use of the person(s)
> named above. If you are not the intended recipient, you are hereby notified
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended recipient,
> please contact the sender by reply email and destroy all copies of the
> original message.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.

Thread
Replication - connecting a slave to a master on the same host via a port or socketAndrew Braithwaite11 Aug
  • RE: Replication - connecting a slave to a master on the same host via a port or socketAndrew Braithwaite11 Aug
    • RE: Replication - connecting a slave to a master on the same hostvia a port or socketGavin Towey11 Aug
      • Re: Replication - connecting a slave to a master on the same host via a port or socketJohan De Meersman12 Aug