1 Dec
2008
1 Dec
'08
3:06 p.m.
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.
1 Dec
1 Dec
3:15 p.m.
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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
--
Alex Balashov
Evariste Systems
Web : http://www.evaristesys.com/
Tel : (+1) (678) 954-0670
Direct : (+1) (678) 954-0671
Mobile : (+1) (706) 338-8599
6:49 p.m.
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
2 Dec
2 Dec
12:03 p.m.
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
BERGANZ François wrote:
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
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. 
8:03 p.m.
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(a)gmail.com>wrote;wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
BERGANZ François wrote:
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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
3 Dec
3 Dec
9:14 a.m.
And, if the mysql-proxy is down
?
De : users-bounces(a)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(a)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(a)gmail.com>
wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
BERGANZ François wrote:
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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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. 
9:17 a.m.
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(a)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(a)gmail.com> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
believe
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 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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
10:54 a.m.
On 12/03/08 10:17, Jerome Martin wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com
On Wed, 2008-12-03 at 09:14 +0100, BERGANZ François
wrote:
down to vrrpd, ucarp ... (included by above, but can be used separately) ...
Cheers,
Daniel
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(a)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(a)gmail.com> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
believe
_______________________________________________
Users mailing list
Users(a)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
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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
10:55 a.m.
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(a)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(a)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(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com
BERGANZ François wrote:
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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
11 a.m.
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(a)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(a)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(a)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(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com
BERGANZ François wrote:
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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
11:04 a.m.
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(a)lists.kamailio.org
Objet : Re: [Kamailio-Users] how to use 2 mysql servers?
On 12/03/08 10:14, BERGANZ François wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com
And, if the mysql-proxy is down… ?
what do you have in place when kamailio/openser is down?
Cheers,
Daniel
*De :* users-bounces(a)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(a)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(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
BERGANZ François wrote:
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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
11:06 a.m.
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(a)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(a)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(a)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(a)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(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
BERGANZ François wrote:
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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
11:16 a.m.
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(a)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(a)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(a)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(a)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(a)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(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
BERGANZ François wrote:
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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
11:26 a.m.
If not, Use Mysql-Cluster
Thanks &Regards
Ravi Prakash Sunkara
VoIP Architect & JAVA-SIP Developer
+91-9999882776
2008/12/3 BERGANZ François <francois(a)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@gmail.com]
*Envoyé :* mercredi 3 décembre 2008 11:06
*À :* BERGANZ François
*Cc :* Daniel-Constantin Mierla; users(a)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(a)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(a)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(a)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(a)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(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/01/08 19:49, Jeremy McNamara wrote:
--
Daniel-Constantin Mierla
http://www.asipto.com
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
BERGANZ François wrote:
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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
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.
11:52 a.m.
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(a)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(a)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(a)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:
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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
<mailto:Users@lists.kamailio.org <mailto:Users@lists.kamailio.org>>
--
Daniel-Constantin Mierla
http://www.asipto.com
And, if the mysql-proxy is down… ?
what do you have in place when kamailio/openser is down?
Cheers,
Daniel
*De :* users-bounces(a)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(a)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(a)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.
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)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(a)lists.kamailio.org <mailto:Users@lists.kamailio.org>
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
12:34 p.m.
--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
2:21 p.m.
On 12/03/08 13:34, Juha Heinanen wrote:
--text follows this line--
Daniel-Constantin Mierla writes:
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 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
--
Daniel-Constantin Mierla
http://www.asipto.com
4:07 p.m.
New subject: [Kamailio-Users] Failover from SRV lookups?
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
7:26 p.m.
New subject: [Kamailio-Users] Failover from SRV lookups?
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
5644
days inactive
5646
days old
18 comments
10 participants
participants (10)
-
Alex Balashov -
BERGANZ François -
Daniel-Constantin Mierla -
G.O. Jensen -
Henning Westerholt -
Jeremy McNamara -
Jerome Martin -
jh＠tutpro.com -
LetMeKnow -
Pablo Hernan Saro