From: Ben Clewett
Date: June 26 2007 12:02pm
Subject: Re: Replication constantly restarting
List-Archive: http://lists.mysql.com/mysql/207716
Message-Id: <4681005D.4090202@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ravi,

Got it, thanks!!

Ben


Ravi Prasad wrote:
> Make sure each of the replication slaves uses different server_id.
> 
> --Ravi
> 
> 
> Ben Clewett wrote:
>> MySql,
>>
>> I am running 5.0.41 on a master and four replication slaves, all 64 
>> bit Linux.
>>
>> In the error.log on all four replication servers I keep seeing:
>>
>> 070626  8:34:23 [Note] Slave: received end packet from server, 
>> apparent master shutdown:
>> 070626  8:34:23 [Note] Slave I/O thread: Failed reading log event, 
>> reconnecting to retry, log 'dbms-04-r1.000002' position 396367467
>> 070626  8:34:23 [Note] Slave: connected to master 
>> 'slave@stripped:3306',replication resumed in log 
>> 'dbms-04-r1.000002' at position 396367467
>>
>> Approximately once every second.  I have used another master server on 
>> AIX, same version, which does the same thing.  The servers are side by 
>> site on the same gigabit switch.
>>
>> The replication does work, but it's a bit messy.
>>
>> Any ideas how to get round this problem?
>>
>> Ben
>>
>>
>>
>>
>