Hi Daniel,<br><br>There is a thread at opensips users list (Sbjt "How to do failover of mysql connection") where Krunal Patel says:<br><br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
I have installed mysql-proxy.<br>I have tested it for failover.<br>It seems working.</blockquote><div><br>As you know it stills alpha, but I see it as a good solution.<br>BR<br><br>Pablo<br></div><br><div class="gmail_quote">
On Tue, Dec 2, 2008 at 9:03 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</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;">Hello,<br>
<div><div></div><div><br>
On 12/01/08 19:49, Jeremy McNamara wrote:<br>
> BERGANZ François wrote:<br>
>><br>
>> Hello,<br>
>><br>
>> I need to know how to use 2 mysql servers, if my first server go down…<br>
>><br>
>> Have you an idea?<br>
>><br>
><br>
> Quite a few different ways depending on your ultimate goal. I believe<br>
> the simplest method would be to setup<br>
> a master-master replication between your two mysql servers.<br>
><br>
><br>
> Then place both IP addresses in a single DNS A record, which gives you<br>
> a round robin effect, but doesn't necessarily achieve 'high<br>
> availability.'<br>
><br>
><br>
> A more complex situation would be ultramonkey (linux-ha) and/or some<br>
> sort of mysql connection proxying environment.<br>
</div></div>anyone having good/bad experience with mysql-proxy?<br>
<a href="http://forge.mysql.com/wiki/MySQL_Proxy" target="_blank">http://forge.mysql.com/wiki/MySQL_Proxy</a><br>
<br>
It should be a simple solution to solve the issue discussed here.<br>
<br>
Cheers,<br>
Daniel<br>
<font color="#888888"><br>
--<br>
Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
</font><div><div></div><div><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br>