[ale] MySQL Circular Replication Issue

Jay Lozier jslozier at gmail.com
Fri Mar 14 12:58:46 EDT 2014


On 03/14/2014 12:44 PM, Robert Coggins wrote:
> Hey guys!
>
> It has been a while since I have been on here!  I am sure it is as 
> awesome as it used to be!
>
> I am having an issue with a 3 server circular replication mysql setup 
> I have.  There are servers (for the sake of this post) A, B, and C.
>
> If I insert/update/delete from A or B the writes occur on all three 
> servers.  However, if I insert/update/delete on C only servers A and C 
> have the updates.
>
> I am not seeing any obvious errors and my configs have the following 
> for offsets: 1, 2, and 3 with an increment of 3.  The server ids are 
> all unique (1,2,3).
>
> I am not sure where to go from here.  If anyone has a suggestion I 
> would appreciate it!
>
> Rob
>
Rob,

I am not a guru on MySQL replication. What are the master/slave settings 
for each? It sounds like each server should have the same settings for 
master/slave from your description.

-- 
Jay Lozier
jslozier at gmail.com



More information about the Ale mailing list