<p dir="ltr">Are you all servers have the same permissions?</p>
<div class="gmail_quote">On Mar 14, 2014 1:00 PM, "Jay Lozier" <<a href="mailto:jslozier@gmail.com">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>