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

[LetMeKnow]

If not, Use Mysql-Cluster

Thanks &Regards
Ravi Prakash Sunkara
VoIP Architect & JAVA-SIP Developer
+91-9999882776


2008/12/3 BERGANZ François <francois at acropolistelecom.net>

>  I want to have less as possible HA-linux, DNS solutions…
>
> It is always the same problem:
>
>                 When we add a solution for failover, if that solution is
> down, the failover is out of work!
>
>
>
> I don't want to have DNS solution, Linux-HA…
>
>
>
> *De :* LetMeKnow [mailto:sunkara.raviprakash.feb14 at gmail.com]
> *Envoyé :* mercredi 3 décembre 2008 11:06
> *À :* BERGANZ François
> *Cc :* Daniel-Constantin Mierla; users at lists.kamailio.org
>
> *Objet :* Re: [Kamailio-Users] how to use 2 mysql servers?
>
>
>
> Hi ,
>
> Can you use the Heart-Beat.
>
>
> Thanks &Regards
> Ravi Prakash Sunkara
> VoIP Architect & JAVA-SIP Developer
> +91-9999882776
>
>  2008/12/3 BERGANZ François <francois at acropolistelecom.net>
>
> I have 2 Kamailio (if one is down, I can continue)
> 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
>
>
> _______________________________________________
> 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.sip-router.org/pipermail/sr-users/attachments/20081203/0d5dd968/attachment.htm>