And, if the mysql-proxy is down ?
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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
