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

Daniel-Constantin Mierla miconda at gmail.com
Tue Dec 2 12:03:17 CET 2008


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





More information about the Users mailing list