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>