Today i set up a circular replication between three nodes A,B & C
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
I followed the below link for setting this circular replication :-
Is it possible to achieve whatever i needed or i need to create Multi
Master set up 2 nodes only.