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

[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 backend is not a problem there is no
reason at all to have more then one mysql instance from a powerdns
perspective?
thanks
Stefan

On Mon, Oct 29, 2012 at 9:28 AM, Peter van Dijk <
peter.van.dijk at netherlabs.nl> wrote:

> 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=pdns
> > gmysql-connection2-dnssec=no
> >
> > gmysql-password=...
> > gmysql-host=IP B2
> > gmysql-user=power_admin
> > gmysql-dbname=pdns
> > gmysql-dnssec=no
> >
> > Questions 1 : why are no queries to the available backend launched, does
> > pdns need to start with all backends running initially ?
>
> PowerDNS needs all backends running, just not initially.
>
> > Questions 2 : Will pdns attempt to reconnect to mysql backend that was
> temp
> > out of service?
>
> Right now, PowerDNS expects all configured backends to be stable. The
> OpenDBX
> backend appears to support some form of failover, you might want to look
> at it. Note
> that it does not support DNSSEC.
>
> Additionally, there is work in progress on a 'nest' backend that allows
> creating a hierarchy
> of backends with support for specific backends in that hierarchy being
> down. Code at
> https://github.com/habbie/powerdns/tree/gmysql-nest
>
> Kind regards,
> --
> Peter van Dijk
> Netherlabs Computer Consulting BV - http://www.netherlabs.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/602a86de/attachment-0001.html>