List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:September 24 2012 2:22pm
Subject:Doubt Regd. Circular Replication In Mysql
View as plain text  
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

Thread
Doubt Regd. Circular Replication In MysqlAdarsh Sharma24 Sep
  • RE: Doubt Regd. Circular Replication In MysqlBenjamin Stillman24 Sep
RE: Doubt Regd. Circular Replication In MysqlBenjamin Stillman24 Sep
  • Re: Doubt Regd. Circular Replication In MysqlShawn Green24 Sep
    • Re: Doubt Regd. Circular Replication In MysqlBenjamin Stillman24 Sep
      • RE: Doubt Regd. Circular Replication In MysqlRick James24 Sep
        • Re: Doubt Regd. Circular Replication In MysqlAdarsh Sharma25 Sep