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

[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 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.dijk at netherlabs.nl <mailto:peter.van.dijk at 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 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 backend is not a problem
>     there is no reason at all to have more then one mysql instance
>     from a powerdns perspective?
>
>     Multiple backends in PowerDNS are not a load balancing or
>     stability feature. PowerDNS normally queries -all- backends for
>     -every- query, assuming each backend might have different domains.
>
>     If you want load balancing or failover, right now I would suggest
>     an external solution like HAproxy or mysql-proxy.
>
>     Kind regards,
>     --
>     Peter van Dijk
>     Netherlabs Computer Consulting BV - http://www.netherlabs.nl/
>
>     _______________________________________________
>     Pdns-users mailing list
>     Pdns-users at mailman.powerdns.com
>     <mailto:Pdns-users at mailman.powerdns.com>
>     http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>
>
>
> -- 
> mvg
> Stefan Tobé
>
>
> Private Mobility Nederland B.V.
> Bolderweg 1
> 1332 AX Almere
> tel: 088 303 3002   /   06 21 26 59 68
> email: stefan.tobe at privatemobility.nl 
> <mailto:stefan.tobe at privatemobility.nl>
> internet: www.privatemobility.nl <http://www.privatemobility.nl>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20121029/5d37b24e/attachment-0001.html>