<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Try use this settings:<div><br></div><div>On master</div><div><br></div><div><div>auto_increment_increment = 2</div><div>auto_increment_offset<span class="Apple-tab-span" style="white-space:pre"> </span> = 0</div><div><br></div><div>On slave</div><div><br></div><div>auto_increment_increment = 2</div><div>auto_increment_offset<span class="Apple-tab-span" style="white-space:pre"> </span> = 1</div><div><br></div><div>This makes sure that auto-increments do not colide between master and slave so you can achieve switchover without conflicts because of auto increment columns. </div><div><br></div><div>Adrian</div><div><br></div><div><br></div><div><div>On Nov 26, 2008, at 10:18 PM, Brett Nemeroff wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Before doing this, I'd seriously consider the problems associated with master-master replication. <div><br></div><div>um, I don't know what they are.. but I know they are real problems. Such as collisions in auto-incrementing data.</div> <div>-Brett</div><div><br><br><div class="gmail_quote">On Wed, Nov 26, 2008 at 3:06 PM, Uwe Kastens <span dir="ltr"><<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> Hi Krunal,<br> <div class="Ih2E3d"><br> ><br> > I am just on my way to implement the same. At the moment I am planing a<br> > kind of Mysql Master - Master together with one VIP for<br> > Mysql-opensips-communication. So for your example you will have to<br> > mysql-servers. opensips is connection to lets say to <a href="http://192.168.1.4" target="_blank">192.168.1.4</a><br> </div>> <<a href="http://192.168.1.4/" target="_blank">http://192.168.1.4/</a>> which<br> <div class="Ih2E3d">> points on one of your mysql-servers. You will need active-active for<br> > mysql since opensips will write some information in the database as<br> > well.<br> ><br> ><br> ><br> > I am working with mysql-5 and heartbeat-2 in mode 1. Its nearly<br> > working.<br> ><br> ><br> > Would you please explain it somewhat in detail?<br> <br> </div>Sure, at the moment its only a testing platform. I took two<br> MySQL-Servers which are configured as master-master. So writing on both<br> databases is possible and is synchronized. I found a good step-by-step<br> guide under:<br> <br> <a href="http://www.howtoforge.com/mysql_master_master_replication" target="_blank">http://www.howtoforge.com/mysql_master_master_replication</a><br> <br> I configured a very simple setup for heartbeat to share one VIP between<br> both servers for client connection. So a kind of mysql-test is needed to<br> check if the database is online on the "normal" IP-Adress. If not the<br> VIP should be switched to the other server. I found a kind of<br> nagios_mysql_check usefull.<br> <br> The openser-servers are connecting only to the vip address. Read and<br> Write are working on only one database. This should be enough for a<br> small environment.<br> <br> Why no master - slave? I found it to complicate to make a slave to a<br> master by skript.<br> <br> Why not the "normal" setup (drbd with mysql and heartbeat)? I looks to<br> complicated.<br> <br> But! I have no idea how it will work in a real world.<br> <br> BR<br> <br> kiste<br> <font color="#888888">--<br> </font><div class="Ih2E3d"><br> kiste lat: 54.322684, lon: 10.13586<br> <br> </div><div><div></div><div class="Wj3C7c">_______________________________________________<br> Users mailing list<br> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br> </div></div></blockquote></div><br></div> _______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></body></html>