tion slave ON *.* TO 'fc_mirror2'@'111.111.11.11'; and the
problem should be gone.
/Mikael.
>
> -Original Message-
> From: Mikael Fridh
> To: DePhillips, Michael P; [EMAIL PROTECTED]
> Sent: 1/23/2004 6:50 PM
> Subject: Re: Replication Madness
>
> I'm not
DePhillips, Michael P; [EMAIL PROTECTED]
Sent: 1/23/2004 6:50 PM
Subject: Re: Replication Madness
I'm not sure I quite follow you here.
I think you mean that when the slave connects to the master, sometimes
the
master does not resolve the address the slave has - thus failing because
you
d
reads the host file before it
queries a name server) it will always identify the slave's hostname.
But like I said, that's the bad solution I think...
Mikael
- Original Message -
From: "DePhillips, Michael P" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi Folks
Every now and again one of my slaves try's to connect to its master via its
ip address as opposed to its dns name. This causes a problem because the ip
address does not have credentials on the master, therefore, connection
refused ->replication ends ->databases out of sync-> angry use