[Kamailio-Users] how to use 2 mysql servers?

[Daniel-Constantin Mierla]

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 at gmail.com] 
> Envoyé : mercredi 3 décembre 2008 10:56
> À : BERGANZ François
> Cc : users at 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 at lists.kamailio.org 
>> [mailto:users-bounces at lists.kamailio.org] *De la part de* Pablo Hernan 
>> Saro
>> *Envoyé :* mardi 2 décembre 2008 20:03
>> *À :* Daniel-Constantin Mierla
>> *Cc :* users at 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 at gmail.com <mailto:miconda at 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 at lists.kamailio.org <mailto:Users at lists.kamailio.org>
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>   
>>     
>
>   

-- 
Daniel-Constantin Mierla
http://www.asipto.com