[ale] MySQL Circular Replication Issue

[Robert Coggins]

Chuck, what kind of permissions do you mean?  If you are talking about the
replication user, then yes, I would expect that to be good because the
following scenarios replicate with the first server listed being the server
with the insert/update/delete.

A->B->C
B->C->A

Here is the problem:
C->AXB


On Fri, Mar 14, 2014 at 1:33 PM, Chuck Payne <terrorpup at gmail.com> wrote:

> Are you all servers have the same permissions?
> On Mar 14, 2014 1:00 PM, "Jay Lozier" <jslozier at gmail.com> wrote:
>
>>
>> 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
>>
>> _______________________________________________
>> Ale mailing list
>> Ale at ale.org
>> http://mail.ale.org/mailman/listinfo/ale
>> See JOBS, ANNOUNCE and SCHOOLS lists at
>> http://mail.ale.org/mailman/listinfo
>>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20140314/8fbd0c36/attachment.html>