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

[BERGANZ François]

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.kamailio.org/pipermail/users/attachments/20081203/1539a1cd/attachment.htm