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
