From: Rick James Date: July 20 2011 7:39pm Subject: Re: Slave receives end packet from master List-Archive: http://lists.mysql.com/replication/2125 Message-Id: <4E272EFE.4010404@yahoo-inc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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" >> >> 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