List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:August 11 2009 6:56pm
Subject:RE: Replication - connecting a slave to a master on the same host
via a port or socket
View as plain text  
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.
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