From: Benjamin Stillman Date: September 24 2012 2:33pm Subject: RE: Doubt Regd. Circular Replication In Mysql List-Archive: http://lists.mysql.com/mysql/228246 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Sounds like you're missing the following in your my.cnf on server B (probab= ly all of them): replicate-same-server-id =3D 0 log-slave-updates While you're checking, might as well as make sure your auto-increment setti= ngs are in there and correct also. -----Original Message----- From: Adarsh Sharma [mailto:eddy.adarsh@stripped] Sent: Monday, September 24, 2012 10:23 AM To: mysql@stripped Subject: Doubt Regd. Circular Replication In Mysql Hi all, Today i set up a circular replication between three nodes A,B & C successfu= lly. I expect whatever writes on A will propagated to B & then Propagated to C b= ecause the structure is like below :- A -> B - > C -> A I created a sample table stag in test database in A and insert few records = that are also replicated to B but not to C. Now when i created the same tab= le in C , it shows errors in show slave status\G output in A node. I needed this setup because all these servers are in different colos so th= at whatever writes to any node would replicated to others also for one data= base. I followed the below link for setting this circular replication :- http://www.howtoforge.com/setting-up-master-master-replication-on-four-node= s-with-mysql-5-on-debian-etch-p2 Is it possible to achieve whatever i needed or i need to create Multi Maste= r set up 2 nodes only. Thanks ________________________________ Notice: This communication may contain privileged and/or confidential infor= mation. If you are not the intended recipient, please notify the sender by = email, and immediately delete the message and any attachments without copyi= ng or disclosing them. LBI may, for any reason, intercept, access, use, and= disclose any information that is communicated by or through, or which is s= tored on, its networks, applications, services, and devices.