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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
