[ale] MySQL Circular Replication Issue

[Robert Coggins]

Well, I got it figured out!  I forgot the log-slave line in my my.cnf on
server A.  Doh!  not sure how I missed it.


On Fri, Mar 14, 2014 at 2:02 PM, Robert Coggins <ale at cogginsnet.com> wrote:

> 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/166cbf97/attachment.html>