Hosting Provided By

Re: Replication constantly restarting

From: Ben Clewett <ben(at)clewett.org.uk>
Date: Tue Jun 26 2007 - 08:02:37 EDT

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@dbms-04-r1.xxxxxxxx: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
>>
>>
>>
>>

>

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com

Received on Tue Jun 26 08:10:45 2007

This message: [ Message body ]
Next message: Paul McCullagh: "[ANN] First release of the BLOB Streaming engine for MySQL"
Previous message: Ravi Prasad: "Re: Replication constantly restarting"
In reply to: Ravi Prasad: "Re: Replication constantly restarting"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Tue Jun 26 2007 - 08:20:01 EDT