<div dir="ltr">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.</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Mar 14, 2014 at 2:02 PM, Robert Coggins <span dir="ltr"><<a href="mailto:ale@cogginsnet.com" target="_blank">ale@cogginsnet.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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.<div>
<br></div><div>A->B->C</div><div>B->C->A</div><div><br></div><div>Here is the problem:</div><div>C->AXB</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">
On Fri, Mar 14, 2014 at 1:33 PM, Chuck Payne <span dir="ltr"><<a href="mailto:terrorpup@gmail.com" target="_blank">terrorpup@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Are you all servers have the same permissions?</p><div><div>
<div class="gmail_quote">On Mar 14, 2014 1:00 PM, "Jay Lozier" <<a href="mailto:jslozier@gmail.com" target="_blank">jslozier@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
On 03/14/2014 12:44 PM, Robert Coggins wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hey guys!<br>
<br>
It has been a while since I have been on here! I am sure it is as awesome as it used to be!<br>
<br>
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.<br>
<br>
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.<br>
<br>
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).<br>
<br>
I am not sure where to go from here. If anyone has a suggestion I would appreciate it!<br>
<br>
Rob<br>
<br>
</blockquote>
Rob,<br>
<br>
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.<br>
<br>
-- <br>
Jay Lozier<br>
<a href="mailto:jslozier@gmail.com" target="_blank">jslozier@gmail.com</a><br>
<br>
______________________________<u></u>_________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org" target="_blank">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/<u></u>listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/<u></u>listinfo</a><br>
</blockquote></div>
</div></div><br>_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org" target="_blank">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>