List:General Discussion« Previous MessageNext Message »
From:Jeremy Cole Date:September 14 2007 8:11am
Subject:Re: Conflicting server IDs on slaves
View as plain text  
Hi David,

This sounds strange, and should NOT occur because of a server_id conflict.

Regards,

Jeremy

David Schneider-Joseph wrote:
> Thank you.
> 
> We had a situation recently where two slaves had a conflicting server  
> ID for several minutes, and shortly thereafter the master started  
> reporting errors which were indicative of data corruption while  
> executing queries.  This happened as the CPU usage climbed very  
> rapidly, and ultimately the entire master machine crashed with an out  
> of memory error.
> 
> Does this sound like something that could have been caused by a short- 
> lived server ID conflict?  All servers involved were running 5.0.27.
> 
> Your answers would be most helpful!
> 
> Thanks,
> David
> 
> On Sep 13, 2007, at 7:58 AM, Shawn Green wrote:
> 
>> Hello David,
>>
>> David Schneider-Joseph wrote:
>>> Hi all,
>>> What do you know about the effect of conflicting slave server IDs  
>>> on the master in general?  And specifically, are you aware of any  
>>> issues with MySQL 5.0.27?
>>> Your help is very much appreciated.
>>> Thanks!
>>> David
>> Repeating the same Server ID in your slave servers is "BAD". It has  
>> caused minor problems like duplicate entries on the slaves and  
>> major problems like over a TB of error logs in just a few minutes  
>> (because of "failure to connect" errors).  There are several very  
>> good reasons why *each and every* server in a replication setup  
>> needs its own, unique server_id. Many of them are discussed in the  
>> chapter on Replication:
>> http://dev.mysql.com/doc/refman/5.0/en/replication.html
>>
>> To see what has been fixed in MySQL since 5.0.27 was released,  
>> please review the change logs documented here:
>> http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0.html
>>
>> For a list of all other bugs (active and inactive) you are invited  
>> to research the bugs database (it is a public forum) at:
>> http://bugs.mysql.com
>>
>> -- 
>> Shawn Green, Support Engineer
>> MySQL Inc., USA, www.mysql.com
>> Office: Blountville, TN
>>     __  ___     ___ ____  __
>>    /  |/  /_ __/ __/ __ \/ /
>>   / /|_/ / // /\ \/ /_/ / /__
>>  /_/  /_/\_, /___/\___\_\___/
>>         <___/
>>  Join the Quality Contribution Program Today!
>>  http://dev.mysql.com/qualitycontribution.html
>>
> 
> 

-- 
high performance mysql consulting
www.provenscaling.com
Thread
Conflicting server IDs on slavesDavid Schneider-Joseph13 Sep
  • Re: Conflicting server IDs on slavesShawn Green13 Sep
    • Re: Conflicting server IDs on slavesDavid Schneider-Joseph13 Sep
      • Re: Conflicting server IDs on slavesJeremy Cole14 Sep
        • Re: Conflicting server IDs on slavesDavid Schneider-Joseph14 Sep