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

[BERGANZ François]

And, if the mysql-proxy is down
 ?

 

 

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20081203/84156577/attachment.htm