From: Adarsh Sharma
Date: September 24 2012 2:22pm
Subject: Doubt Regd. Circular Replication In Mysql
List-Archive: http://lists.mysql.com/mysql/228244
Message-Id: <CAGx-Qq+UoxhkjZ1P_e3DanUMs_jLe=vx1=YV0WcjeFdcFrhj1g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf306f74726d6fc104ca7352e1

--20cf306f74726d6fc104ca7352e1
Content-Type: text/plain; charset=ISO-8859-1

Hi all,

Today i set up a circular replication between three nodes A,B & C
successfully.
I expect whatever writes on A will propagated to B & then Propagated to C
because 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
table 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
that whatever writes to any node would replicated to others also for one
database.

I followed the below  link for setting this circular replication :-

http://www.howtoforge.com/setting-up-master-master-replication-on-four-nodes-with-mysql-5-on-debian-etch-p2

Is it possible to achieve whatever i needed or i need to create Multi
Master set up 2 nodes only.

Thanks

--20cf306f74726d6fc104ca7352e1--