Hello,
I need to know how to use 2 mysql servers, if my first server go down
Have you an idea?
thankyopu
Cordialement,
BERGANZ François
P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.
Please do not crosspost.
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?
thankyopu
Cordialement,
BERGANZ François
P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
Jeremy McNamara
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
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.comwrote:
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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
And, if the mysql-proxy is down ?
De : 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 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 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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@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 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 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
On 12/03/08 10:17, Jerome Martin wrote:
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.
down to vrrpd, ucarp ... (included by above, but can be used separately) ...
Cheers, Daniel
De :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 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 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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] *De la part de* Pablo Hernan Saro *Envoyé :* mardi 2 décembre 2008 20:03 *À :* Daniel-Constantin Mierla *Cc :* 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> 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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] Envoyé : mercredi 3 décembre 2008 10:56 À : BERGANZ François Cc : 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] *De la part de* Pablo Hernan Saro *Envoyé :* mardi 2 décembre 2008 20:03 *À :* Daniel-Constantin Mierla *Cc :* 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> 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
On 12/03/08 12:00, BERGANZ François wrote:
I have 2 Kamailio (if one is down, I can continue)
how the phones get to the active kamailio? Maybe you can reuse the same mechanism so kamailio get to active mysql.
Cheers, Daniel
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] Envoyé : mercredi 3 décembre 2008 10:56 À : BERGANZ François Cc : 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] *De la part de* Pablo Hernan Saro *Envoyé :* mardi 2 décembre 2008 20:03 *À :* Daniel-Constantin Mierla *Cc :* 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> 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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
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] Envoyé : mercredi 3 décembre 2008 10:56 À : BERGANZ François Cc : 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] *De la part de* Pablo Hernan Saro *Envoyé :* mardi 2 décembre 2008 20:03 *À :* Daniel-Constantin Mierla *Cc :* 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> 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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 dont 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
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] Envoyé : mercredi 3 décembre 2008 10:56 À : BERGANZ François Cc : 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] *De la part de* Pablo Hernan Saro *Envoyé :* mardi 2 décembre 2008 20:03 *À :* Daniel-Constantin Mierla *Cc :* 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> 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
If not, Use Mysql-Cluster
Thanks &Regards Ravi Prakash Sunkara VoIP Architect & JAVA-SIP Developer +91-9999882776
2008/12/3 BERGANZ François francois@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 isdown, the failover is out of work!
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
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] Envoyé : mercredi 3 décembre 2008 10:56 À : BERGANZ François Cc : 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] *De la part de* Pablo Hernan Saro *Envoyé :* mardi 2 décembre 2008 20:03 *À :* Daniel-Constantin Mierla *Cc :* 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> 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Users mailing list 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 http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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
--text follows this line-- Daniel-Constantin Mierla writes:
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 ...
monitoring can be avoided with two systems running independently from each other. this is possible, if your UAs are able to register via two proxies.
if you are willing to tolerate UA unavailability until it re-registers, it may be possible to avoid monitoring also in case UA registers via only one proxy.
-- juha
On 12/03/08 13:34, Juha Heinanen wrote:
--text follows this line-- Daniel-Constantin Mierla writes:
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 ...
monitoring can be avoided with two systems running independently from each other. this is possible, if your UAs are able to register via two proxies.
as you put this on the table, is there any phone that can register via two proxies?
Is anyone aware of a good sip phone doing SRV failover?
Cheers, Daniel
if you are willing to tolerate UA unavailability until it re-registers, it may be possible to avoid monitoring also in case UA registers via only one proxy.
-- juha
Hi, running old OpenSER 1.3 branch here.
Problem is as follows and I hope somebody can shed some light on it.
Our GW supplier has two SBC's that they switch between... to find these I do a DNS lookup at their domain which gives me;
$ dig sipsbc.domain.com NAPTR ; <<>> DiG 9.3.2-P2.1 <<>> ;; ANSWER SECTION: sipsbc.domain.com. 600 IN NAPTR 1 0 "s" "SIP+D2U" "" _sip._udp.sipsbc.domain.com.
... and a SRV lookup $ dig _sip._udp.sipsbc.domain.com SRV ; <<>> DiG 9.3.2-P2.1 ;; ANSWER SECTION: _sip._udp.sipsbc.domain.com. 372 IN SRV 1 1 5060 sbc2.sipsbc.domain.com. _sip._udp.sipsbc.domain.com. 372 IN SRV 1 1 5060 sbc1.sipsbc.domain.com.
The "problem" is... OpenSER tries the first server (sbc2) first everytime. Natural since it's listed first. However, this one doesn't answer most of the time, and OpenSER then has to timeout before trying the next (with frequent resends from my UAs overloading the servers more in the meantime).
With fr_timer out of the tm module I can set this timeout to 2 seconds, but it still takes nearly 10 seconds before I get a ringing signal (183) from the GW SBC.
Is it possible to somehow get OpenSER to "cache" the active server? Or query it "beforehand" with an OPTIONS message or something to see which one is alive (that is quicker than waiting for timeouts and retries?)
Thanks in advance for your prompt help since our GW changed this overnight on our production system and my users are not too happy about it :D
- Geir UNINETT
On Wednesday 03 December 2008, G.O. Jensen wrote:
Problem is as follows and I hope somebody can shed some light on it.
Our GW supplier has two SBC's that they switch between... to find these I do a DNS lookup at their domain which gives me; [..]
The "problem" is... OpenSER tries the first server (sbc2) first everytime. Natural since it's listed first. However, this one doesn't answer most of the time, and OpenSER then has to timeout before trying the next (with frequent resends from my UAs overloading the servers more in the meantime).
With fr_timer out of the tm module I can set this timeout to 2 seconds, but it still takes nearly 10 seconds before I get a ringing signal (183) from the GW SBC.
Is it possible to somehow get OpenSER to "cache" the active server? Or query it "beforehand" with an OPTIONS message or something to see which one is alive (that is quicker than waiting for timeouts and retries?)
Thanks in advance for your prompt help since our GW changed this overnight on our production system and my users are not too happy about it :D
Hi Geir,
openser used indeed in the past always the first SRV record in this case. In the 1.4 branch this limitation is fixed, here is a random one choosen when records with the same priority are returned. Perhaps you can upgrade to the 1.4 branch, if this is not possible now you could try to backport the respective changes to your version.
Cheers,
Henning
-
Alex Balashov -
BERGANZ François -
Daniel-Constantin Mierla -
G.O. Jensen -
Henning Westerholt -
Jeremy McNamara -
Jerome Martin -
jh＠tutpro.com -
LetMeKnow -
Pablo Hernan Saro