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

[Chhavi Mittal]

Yes, I didn't realize that the 'content' column is not indexed. It's
actually a much bigger problem then.
Is there any other smarter way to perform IP address updates?
I know powerdns has a strong plugin support, is this something that I can
write a plugin for ?

On Mon, Mar 22, 2021 at 11:10 PM Thomas Mieslinger via Pdns-users <
pdns-users at mailman.powerdns.com> wrote:

> The content column is not indexed, so it might take a long time for the
> database to figure out which records need to be changed.
>
> At mysql/mariadb is mvcc (multi version concurrency control) so your
> table stays readable (powerdns can create answers) during updates.
>
> On 3/23/21 1:22 AM, Kevin P. Fleming via Pdns-users wrote:
> > If it's 10K records all pointing to the same host, then yes... making
> > those CNAMEs to a single name (with an A record) will be much quicker
> > to update than if they were all A records. There are many reasons why
> > that might be a bad idea though, so be careful :-)
> >
> > On Mon, Mar 22, 2021 at 6:36 PM Chhavi Mittal via Pdns-users
> > <pdns-users at mailman.powerdns.com> wrote:
> >>
> >> 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://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.powerdns.com_mailman_listinfo_pdns-2Dusers&d=DwICAg&c=sWW_bEwW_mLyN3Kx2v57Q8e-CRbmiT9yOhqES_g_wVY&r=zhXmtZOB8qouWS1ukhEyCOSrM390DVZ1dg-asUtrEKo&m=HvVlmpVYyrMRm_bjyEDrTlfBRCuHN0dIWdIIHiWNapQ&s=Sz97QkI6XgJ6OKf6VlNdI_WYMiDYL5zo5jnTDPazWSk&e=
> >>
> >> _______________________________________________
> >> Pdns-users mailing list
> >> Pdns-users at mailman.powerdns.com
> >>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.powerdns.com_mailman_listinfo_pdns-2Dusers&d=DwICAg&c=sWW_bEwW_mLyN3Kx2v57Q8e-CRbmiT9yOhqES_g_wVY&r=zhXmtZOB8qouWS1ukhEyCOSrM390DVZ1dg-asUtrEKo&m=HvVlmpVYyrMRm_bjyEDrTlfBRCuHN0dIWdIIHiWNapQ&s=Sz97QkI6XgJ6OKf6VlNdI_WYMiDYL5zo5jnTDPazWSk&e=
> > _______________________________________________
> > Pdns-users mailing list
> > Pdns-users at mailman.powerdns.com
> >
> https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.powerdns.com_mailman_listinfo_pdns-2Dusers&d=DwICAg&c=sWW_bEwW_mLyN3Kx2v57Q8e-CRbmiT9yOhqES_g_wVY&r=zhXmtZOB8qouWS1ukhEyCOSrM390DVZ1dg-asUtrEKo&m=HvVlmpVYyrMRm_bjyEDrTlfBRCuHN0dIWdIIHiWNapQ&s=Sz97QkI6XgJ6OKf6VlNdI_WYMiDYL5zo5jnTDPazWSk&e=
> >
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.powerdns.com_mailman_listinfo_pdns-2Dusers&d=DwICAg&c=sWW_bEwW_mLyN3Kx2v57Q8e-CRbmiT9yOhqES_g_wVY&r=zhXmtZOB8qouWS1ukhEyCOSrM390DVZ1dg-asUtrEKo&m=HvVlmpVYyrMRm_bjyEDrTlfBRCuHN0dIWdIIHiWNapQ&s=Sz97QkI6XgJ6OKf6VlNdI_WYMiDYL5zo5jnTDPazWSk&e=
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20210323/33e6e66b/attachment.htm>