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@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@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 <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://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@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@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@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@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
