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
