*De :* users-bounces(a)lists.kamailio.org
[mailto:users-bounces@lists.kamailio.org] *De la part de* Pablo Hernan
Saro
*Envoyé :* mardi 2 décembre 2008 20:03
*À :* Daniel-Constantin Mierla
*Cc :* users(a)lists.kamailio.org
*Objet :* Re: [Kamailio-Users] how to use 2 mysql servers?
Hi Daniel,
There is a thread at opensips users list (Sbjt "How to do failover of
mysql connection") where Krunal Patel says:
I have installed mysql-proxy.
I have tested it for failover.
It seems working.
As you know it stills alpha, but I see it as a good solution.
BR
Pablo
On Tue, Dec 2, 2008 at 9:03 AM, Daniel-Constantin Mierla
<miconda(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
BERGANZ François wrote:
Hello,
I need to know how to use 2 mysql servers, if my first server go down…
Have you an idea?
Quite a few different ways depending on your ultimate goal. I believe
the simplest method would be to setup
a master-master replication between your two mysql servers.
Then place both IP addresses in a single DNS A record, which gives you
a round robin effect, but doesn't necessarily achieve 'high
availability.'
A more complex situation would be ultramonkey (linux-ha) and/or some
sort of mysql connection proxying environment.
anyone having good/bad experience with mysql-proxy?
http://forge.mysql.com/wiki/MySQL_Proxy
It should be a simple solution to solve the issue discussed here.
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users