<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
Hi Oliver,<div><br><div><blockquote type="cite"><p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mysql supports Two-Way replication and you can use both nodes (obeying a</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">number of requirements). I do so for over 3 years now and it works fine...</font></p> </blockquote></div><div><br class="webkit-block-placeholder"></div><div>Do you mind if I clarify those requirements?</div><div><br class="webkit-block-placeholder"></div><div>The two-way replication (Master<->Master) replication is asynchronous, so you need to try and prevent updating the same row on both nodes simultaneously (which could cause a conflict).</div><div><br class="webkit-block-placeholder"></div><div>For inserts this is less an issue because of auto_increment_increment and auto_increment_offset</div><div><a href="http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html">http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html</a></div><br><div> <span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "></span><div>Regards,</div><div>Morgan</div><div><br class="khtml-block-placeholder"></div><div>--</div><div>Morgan Tocker, Support Engineer</div><div>MySQL AB, Montreal, Canada, <a href="http://www.mysql.com">www.mysql.com</a></div><div><br class="khtml-block-placeholder"></div><div>Discover new MySQL Monitoring & Advisory features at:</div><div><a href="http://www.mysql.com/products/enterprise/whats_new.html">http://www.mysql.com/products/enterprise/whats_new.html</a></div><br class="Apple-interchange-newline"></span></span> </div><br></div></body></html>