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

2021-03-26 Thread Brian Candler via Pdns-users
On 25/03/2021 21:49, Chhavi Mittal wrote: Hello, This ALIAS approach is exactly what I was looking for. Thank you for sharing it.! I tried to set it up and now have both pdns authoritative and recursor servers running on my host and I have added following entries in my DB but when I try to do

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

2021-03-25 Thread Chhavi Mittal via Pdns-users
Hello, This ALIAS approach is exactly what I was looking for. Thank you for sharing it.! I tried to set it up and now have both pdns authoritative and recursor servers running on my host and I have added following entries in my DB but when I try to do 'dig' on 'example.net' to get the recursor to

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

2021-03-23 Thread Brian Candler via Pdns-users
On 23/03/2021 17:29, Chhavi Mittal via Pdns-users wrote: 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? As well as CNAME, have you looked at the ALIAS pseudo-RR type? https

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

2021-03-23 Thread Chhavi Mittal via Pdns-users
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 Th

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

2021-03-22 Thread Thomas Mieslinger via Pdns-users
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. Fl

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

2021-03-22 Thread Kevin P. Fleming via Pdns-users
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 Chhav

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

2021-03-22 Thread Chhavi Mittal via Pdns-users
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:2