Hi<br><br>Thanks for your help.<br>I have installed mysql-proxy.<br>I have tested it for failover.<br>It seems working.<br><br>Thanks again..<br>Krunal Patel<br><br><br><br><br><div class="gmail_quote">On Thu, Nov 27, 2008 at 1:33 PM, Uwe Kastens <span dir="ltr"><<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>
<br>
As far as I know this problem is fixed in MySQL5 - but I am not sure<br>
about ...<br>
<br>
BR<br>
<br>
Uwe<br>
<br>
Brett Nemeroff schrieb:<br>
<div class="Ih2E3d">> Before doing this, I'd seriously consider the problems associated with<br>
> master-master replication.<br>
><br>
> um, I don't know what they are.. but I know they are real problems. Such<br>
> as collisions in auto-incrementing data.<br>
> -Brett<br>
><br>
><br>
> On Wed, Nov 26, 2008 at 3:06 PM, Uwe Kastens <<a href="mailto:kiste@kiste.org">kiste@kiste.org</a><br>
</div><div><div></div><div class="Wj3C7c">> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>> wrote:<br>
><br>
> Hi Krunal,<br>
><br>
> ><br>
> > I am just on my way to implement the same. At the moment I am<br>
> 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<br>
> <a href="http://192.168.1.4" target="_blank">192.168.1.4</a> <<a href="http://192.168.1.4" target="_blank">http://192.168.1.4</a>><br>
> > <<a href="http://192.168.1.4/" target="_blank">http://192.168.1.4/</a>> which<br>
> > points on one of your mysql-servers. You will need<br>
> active-active for<br>
> > mysql since opensips will write some information in the<br>
> 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>
> 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>
> --<br>
><br>
> kiste lat: 54.322684, lon: 10.13586<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
</div></div>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
<div class="Ih2E3d">> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
><br>
<br>
<br>
</div>--<br>
<div><div></div><div class="Wj3C7c"><br>
kiste lat: 54.322684, lon: 10.13586<br>
</div></div></blockquote></div><br>