<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE-AT" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT">We have a customer zone with ~1.1 mio RRs (~200K NSEC3 RRs) with zone updates every few minutes. We use the Postgresql backend and replicate the zone to the secondaries using logical replication.
It is not very smart pushing out 5GB of (almost same) data every few minutes, and it is causing additional load to the database (write operations) on secondaries with older hardware.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT">Hence, I would consider enabling IXFR for this zone, but until now I always tried to stay away from IXFR as there were always bugs in PDNS regarding IXFR, and according to the documentation removing
of ENTs is not supported (does this have a real word impact?).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT">So, I reach out for some people how use or have used PDNS with IXFR and DB backend, regarding stability and if my concerns are justifiable or over-the-top?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT">Thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE-AT">Klaus</span><o:p></o:p></p>
</div>
</body>
</html>