[Pdns-users] Backup resolution

[Markus Welsch]

>     I want the ability to have a backup MySQL backend server used, in 
> case my primary MySQL server goes down.
> 
>     In the pdns.conf I can put a fqdn for the mysql-host, ie 
> mysql-host=sqlserver.domain.com, but then I have no way
>     of having a script on the fly be able to change what 
> sqlserver.domain.com resolves to.
> 
>     My train of thought is that I can have a monitoring script that 
> runs, if it detects that pdns cat resolve a name
>     that it should be able to from the sql server, then modify the pdns 
> config and then rerun the pdns server.

Well you could take a look at monit (http://www.tildeslash.com/monit/) 
for the monitoring part. Here you can specify a start script - which 
could be a "fake" start script that in fact just changes the pdns.conf 
(making use of cat and sed) and then restarts it using the real startup 
script.