Re: [Pdns-users] pdns with one mysql backend down and one up fails to process queries

2012-10-29 Thread Frank Louwers
HAproxy is very much production ready! MySQL-proxy works, but has gotchas and bugs. Best to work around mysql-proxy if you can! Regards, Frank -- Frank Louwers COO Openminds http://www.openminds.be/ Schrijf je in op onze nieuwsbrief: http://openminds.be/nieuwsbrief Stefan Tobé wrote: OK

Re: [Pdns-users] pdns with one mysql backend down and one up fails to process queries

2012-10-29 Thread Peter van Dijk
Hello Stefan, On Oct 29, 2012, at 10:00 , Stefan Tobé wrote: > OK thanks, HAproxy or mysql-proxy.are these production ready in your opinion? I have in the past been responsible for HAproxy-based failover setups, and they worked well. I do not have a lot of experience with mysql-proxy, so no opi

Re: [Pdns-users] pdns with one mysql backend down and one up fails to process queries

2012-10-29 Thread Stefan Tobé
OK thanks, HAproxy or mysql-proxy.are these production ready in your opinion? On Mon, Oct 29, 2012 at 9:42 AM, Peter van Dijk < peter.van.d...@netherlabs.nl> wrote: > Hello Stefan, > > On Oct 29, 2012, at 9:39 , Stefan Tobé wrote: > > > Thanks, for you reply > > Is it correct -taking your answer

Re: [Pdns-users] pdns with one mysql backend down and one up fails to process queries

2012-10-29 Thread Peter van Dijk
Hello Stefan, On Oct 29, 2012, at 9:39 , Stefan Tobé wrote: > Thanks, for you reply > Is it correct -taking your answer into account- to state that multiple Mysql > backends configured in pdns.conf is only there to provide load balancing to > the mysq servers and NOT to increase availability of

Re: [Pdns-users] pdns with one mysql backend down and one up fails to process queries

2012-10-29 Thread Stefan Tobé
Thanks, for you reply Is it correct -taking your answer into account- to state that multiple Mysql backends configured in pdns.conf is only there to provide load balancing to the mysq servers and NOT to increase availability of a backend to the dns service? In other words: if load on the mysql back

Re: [Pdns-users] pdns with one mysql backend down and one up fails to process queries

2012-10-29 Thread Peter van Dijk
Hello Stefan, On Oct 28, 2012, at 19:45 , s-tobe wrote: > # gmysql-socket= > > # MULTI BACKEND OPERATION, TWO INSTANCES > launch=gmysql,gmysql:connection2 > > > gmysql-connection2-password=... > gmysql-connection2-host=IP B1 > gmysql-connection2-user=power_admin > gmysql-connection2-dbname=pdn

[Pdns-users] pdns with one mysql backend down and one up fails to process queries

2012-10-28 Thread s-tobe
Hi, I created a setup with 1 x pdns auth server (3.0.1) and 2 x mysql backends (IP B1, IP B2) PDNS agrees to start with one mysql backend dead yet (non responsive) and one mysql backend operational (responding) It shows the following log snippet: Oct 22 07:47:53 pmnlapp11 pdns[8906]: gmysql Co