[Pdns-users] Different MySQL server for reads vs writes

[Chris]

Hi,

I do this by creating a separate instance of PowerDNS for writes. As an 
example, in /etc/powerdns I have:

pdns-internal.conf - Configured to use the read only database (listening 
on port 5350 with no web server/API - queries are sent to it via dnsdist)
pdns-api.conf - Configured to use the write database (listening on port 
5351 and the API/web server on 8351)

And I use the systemd service instances to manage this (eg. 
pdns at internal, pdns at api)

On 8/07/2019 1:17 pm, Daniel Lo Nigro wrote:
> Is there a way to configure PowerDNS + the MySQL backend to send writes 
> (eg. via the API) and reads to different servers? For example, if I want 
> writes to always go to a master server, but reads to go to a slave.
> 
> Thanks!
> 
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>