[Pdns-users] Reset Data on Slave

[Klaus Darilion]

Hi Sebastian!

The term "cached data" usually does not refer to the data in the database, but to data cached in the PDNS process (packet cache, query cache).

If you want to clean the "cache" the fastest method is to restart the PDNS process (a short service interruption). To adjust caching timeouts see https://doc.powerdns.com/authoritative/settings.html and grep for "ttl".

You do not mention how to replicate the data to your 2 slaves:
a) Using DNS zone transfers (AXFR), or
b) MySQL replication

If you use a) the you could just force a zone transfer on the slave with "pdns_control retrieve <zone-name>".
If you use b) there actually should not be any needs to do that manually, the MySQL replication will take care that everything is consistent. But if for whatever reason the data on the Slave DB is out of sync, you have to delete the data on the Slave DB an re-sync from the master. How this is done depends on the type of replication you are using - refer to the MySQL manual. But be aware: When you delete the data in the slave DB and resync, this will cause service interruptions on the Slave, and even worse the slave may return wrong data. 

Regards
Klaus

> -----Ursprüngliche Nachricht-----
> Von: Pdns-users <pdns-users-bounces at mailman.powerdns.com> Im
> Auftrag von sebastian--- via Pdns-users
> Gesendet: Dienstag, 9. Januar 2024 19:55
> An: pdns-users at mailman.powerdns.com
> Cc: sebastian at debianfan.de
> Betreff: [Pdns-users] Reset Data on Slave
> 
> Hi @all,
> 
> how do i reset the DNS-Data on the first & second slave-dns-server?
> 
> We have dns01 - master, dns02 - slave & dns03 - slave.
> 
> The two slave-servers should forget all the caching information and
> should ask the master for new and complete data.
> 
> How to do? (i found a tutorial but i don't want to edit the mysql
> database...).
> 
> Is there any shell command at powerdns ?
> 
> Tnx
> 
> Sebastian
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users