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

Chris lists+pdns at gbe0.com
Mon Jul 8 05:25:04 UTC 2019


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

More information about the Pdns-users mailing list