[Pdns-users] Limit Returned Results from a SRV Query

[frank+pdns at tembo.be]

Hi Shawn,

You might be able to overrule the default Queries (see https://docs.powerdns.com/authoritative/backends/generic-sql.html <https://docs.powerdns.com/authoritative/backends/generic-sql.html>). 

Another option might be to use LUA records: https://docs.powerdns.com/authoritative/lua-records/index.html <https://docs.powerdns.com/authoritative/lua-records/index.html>.

Absolute worst case: create a stored procedure and use that, but it will make debugging harder and might impact speed (depending on the QPS your zone receives). I assume you’ve considered the side effects on caching and the TTLs on your records...

Kind Regards,

Frank



Frank Louwers
PowerDNS Certified Consultant @ Kiwazo.be <http://kiwazo.be/>





> On 5 Sep 2019, at 15:46, Shawn Augenstein <shawnsrabbithole at gmail.com <mailto:shawnsrabbithole at gmail.com>> wrote:
> 
> Greetings,
> 
> I have stood up a MariaDB backend for a Authoritative Server deployment and I am working under a specific requirement:
> 
> Provisioning the backend with 200 A Records associated with a SRV however, for each query to the Authoritative server only 5 of the 200 can be returned at any one time. 
> 
> This is an isolated system. 
> 
> I am looking for advisement on where to make the required edits to the query to the backend itself or guidance in general on moving forward.
> 
> Regards,
> 
> -S
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com <mailto:Pdns-users at mailman.powerdns.com>
> https://mailman.powerdns.com/mailman/listinfo/pdns-users

Frank Louwers
PowerDNS Certified Consultant @ Kiwazo.be




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20190905/5276445a/attachment.htm>