[Pdns-users] [E] Re: How to update IP address of records

[Chhavi Mittal]

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 <larry at 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 at 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 at 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=>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20210322/f0337b4e/attachment.htm>