[ale] MySQL Circular Replication Issue

Chuck Payne terrorpup at gmail.com
Fri Mar 14 13:33:52 EDT 2014


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20140314/658233b8/attachment.html>


More information about the Ale mailing list