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

[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=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/