On 12/03/08 12:00, BERGANZ François wrote:
I have 2 Kamailio (if one is down, I can continue)
how the phones get to the active kamailio? Maybe you can reuse the same mechanism so kamailio get to active mysql.
Cheers, Daniel
I have more than 2 asterisk But, kamailio can ask just one mysql server!
-----Message d'origine----- De : Daniel-Constantin Mierla [mailto:miconda@gmail.com] Envoyé : mercredi 3 décembre 2008 10:56 À : BERGANZ François Cc : users@lists.kamailio.org Objet : Re: [Kamailio-Users] how to use 2 mysql servers?
On 12/03/08 10:14, BERGANZ François wrote:
And, if the mysql-proxy is down… ?
what do you have in place when kamailio/openser is down?
Cheers, Daniel
*De :* users-bounces@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@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@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@lists.kamailio.org mailto:Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users