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=3Dgcdmg-mysql-2@m.gmane.o rg

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@lovefilm.com]=20
Sent: 11 August 2009 16:12
To: mysql@lists.mysql.com
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

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dandrew.braithwaite@love film.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Replication - connecting a slave to a master on the same hostvia a port or socket

Andrew,

Yes it's true, because when you specify localhost, you're using the local s=
ocket file. The port only has meaning for TCP connections.

Regards,
Gavin Towey

-----Original Message-----
From: Andrew Braithwaite [mailto:andrew.braithwaite@lovefilm.com]
Sent: Tuesday, August 11, 2009 8:38 AM
To: mysql@lists.mysql.com
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@lovefilm.com]
Sent: 11 August 2009 16:12
To: mysql@lists.mysql.com
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=3Dandrew.braithwaite@love film.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Replication - connecting a slave to a master on the same host via

--0016e6d7f07a0eb2c60470f1292a
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 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@lovefilm.com]
> Sent: Tuesday, August 11, 2009 8:38 AM
> To: mysql@lists.mysql.com
> 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@lovefilm.com]
> Sent: 11 August 2009 16:12
> To: mysql@lists.mysql.com
> 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=andrew.braithwaite@lovefi lm.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=gtowey@ffn.com
>
>
> 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=vegivamp@tuxera.be
>
>


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

--0016e6d7f07a0eb2c60470f1292a--