List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:June 26 2007 12:02pm
Subject:Re: Replication constantly restarting
View as plain text  
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
>>
>>
>>
>>
> 

Thread
Replication constantly restartingBen Clewett26 Jun
  • Re: Replication constantly restartingRavi Prasad26 Jun
    • Re: Replication constantly restartingBen Clewett26 Jun