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

[Daniel-Constantin Mierla]

On 12/03/08 12:16, BERGANZ François wrote:
>
> 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!
>
that happens to every solution. The HA is given by the fact you add a 
new node managed by a system that is less exposed to unavailability than 
the new node.

It can happen that the router before your network crashes. So you don't 
have anymore to worry for your HA, but you can add a backup link.

So there is no simple and 100% reliable HA solution. You have to go to 
the level that satisfies your needs.

If a software crashes, then can be started by another application which 
does just monitoring of that application. But of course, if monitoring 
and application crashes in the same time, you are unlucky, adding 
another monitor for monitoring app decreases the chance that all 3 apps 
crashes in the same time ...

Cheers,
Daniel


> 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 
> <mailto: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 
> <mailto:miconda at gmail.com>]
> Envoyé : mercredi 3 décembre 2008 10:56
> À : BERGANZ François
> Cc : users at lists.kamailio.org <mailto: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>
> > [mailto: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 <mailto: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> 
> <mailto: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> 
> <mailto: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 <mailto: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 <mailto:Users at lists.kamailio.org>
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>

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