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

[Daniel-Constantin Mierla]

On 12/03/08 10:17, Jerome Martin wrote:
> On Wed, 2008-12-03 at 09:14 +0100, BERGANZ François wrote:
>   
>> And, if the mysql-proxy is down… ?
>>     
>
> Failover it to a spare one, cf linux-ha (dot org), aka heartbeat v1.
>   
down to vrrpd, ucarp ... (included by above, but can be used separately) ...

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> 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
>> 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
>>     
>
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>   

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