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

[Jerome Martin]

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.


> 
>  
> 
>  
> 
> 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