Yes I am using mysql backend to store the records. But if I have 10K records and I am updating frequently then every time I do a sql update query my table will be locked and it takes some time to update that many records. So that's why I'm looking for a better solution.
On Mon, Mar 22, 2021 at 3:28 PM Larry Wapnitsky <la...@wapnitsky.com> wrote: > Are you storing the records in a database? If so, a select and replace > would work > > On Mon, Mar 22, 2021, 17:43 Chhavi Mittal via Pdns-users < > pdns-users@mailman.powerdns.com> wrote: > >> Hello, >> >> I am new to powerdns and trying to set it up based on my requirements. >> One issue that I am facing is how to update an IP address for all my >> records? For example, if I have 10K records that are pointing to one >> host/IP address but that host goes down and I want to update to a new host >> ip address, do I have to update all 10K records? >> Or is there a better way to set this up? Maybe I can add 'cname' to all >> these 10K records and that 'cname' could somehow resolve to an IP address >> so essentially when I run the 'dig' command the end result would be the new >> IP address. >> Also is there a powerdns supported plugin that can be written for this to >> make updates simpler? >> >> Best, >> Chhavi >> _______________________________________________ >> Pdns-users mailing list >> Pdns-users@mailman.powerdns.com >> https://mailman.powerdns.com/mailman/listinfo/pdns-users >> <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.powerdns.com_mailman_listinfo_pdns-2Dusers&d=DwMFaQ&c=sWW_bEwW_mLyN3Kx2v57Q8e-CRbmiT9yOhqES_g_wVY&r=zhXmtZOB8qouWS1ukhEyCOSrM390DVZ1dg-asUtrEKo&m=PCGGtkyxKM89qwTpIvSLben3dWfotmkt7i7FyajUd4Y&s=pX8CjF-lAVwoT8knewXj3ZSDE5DCln27kpFqhsAObYc&e=> >> >
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
