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@gmail.com] *Envoyé :* mercredi 3 décembre 2008 11:06 *À :* BERGANZ François *Cc :* Daniel-Constantin Mierla; users@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@acropolistelecom.net mailto:francois@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@gmail.com mailto:miconda@gmail.com] Envoyé : mercredi 3 décembre 2008 10:56 À : BERGANZ François Cc : users@lists.kamailio.org mailto:users@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@lists.kamailio.org
mailto:users-bounces@lists.kamailio.org
[mailto:users-bounces@lists.kamailio.org
mailto:users-bounces@lists.kamailio.org] *De la part de* Pablo Hernan
Saro *Envoyé :* mardi 2 décembre 2008 20:03 *À :* Daniel-Constantin Mierla *Cc :* users@lists.kamailio.org mailto:users@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@gmail.com mailto:miconda@gmail.com
<mailto:miconda@gmail.com mailto:miconda@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@lists.kamailio.org mailto:Users@lists.kamailio.org
<mailto:Users@lists.kamailio.org mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org mailto:Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com
Users mailing list Users@lists.kamailio.org mailto:Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users