That's not my case though. The master and slave has different server-id, and the master
only has one slave.
--- On Wed, 7/20/11, Rick James <rjames@stripped> wrote:
> From: Rick James <rjames@stripped>
> Subject: Re: Slave receives end packet from master
> To: "Johan De Meersman" <vegivamp@stripped>
> Cc: "database100@stripped" <database100@stripped>, "Replication"
> <replication@stripped>
> Date: Wednesday, July 20, 2011, 2:39 PM
> Two slaves with the same server-id
> would show symptoms something like that.
>
> On 7/20/11 9:44 AM, Johan De Meersman wrote:
> > ----- Original Message -----
> >> From: "Database System"<database100@stripped>
> >>
> >> The replication keeps on and off (Slave I/O thread
> value changes
> >> between Yes and No automatically). It comes back
> on its own, but
> >> since it being off so often, and doesn't have
> enough time to catch
> > Wiggle the cable :-)
> >
> > More specifically, this sounds like the slave easily
> loses connection - set up network throughput graphs; have a
> look in your system logs if any down/ups appear there; see
> if there isn't a pattern in the disconnects; check for
> duplicate IPs (some host trying to steal the slave's IP);
> and do, indeed, check if the cables are securely in their
> socket.
> >
> >
>
> --
> Rick James - MySQL Geek
>
>
