List:General Discussion« Previous MessageNext Message »
From:Ravi Prasad Date:June 26 2007 11:49am
Subject:Re: Replication constantly restarting
View as plain text  
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