Hello guys!
For the last couple of weeks I've been working on "dynamic zones" for NSD,
which at the moment means MySQL backend with simple cache (or "zones
dictionary", if you prefer) to avoid "zone matching" via database queries.
--- HOW IT WORKS? ---
Upon receiving query (class IN or ANY) new code checks in cache if there is
matching zone in MySQL database. If it finds one then all records for that
zone are imported from MySQL database, parsed, checked and then whole zone
is injected into regular NSD workflow instead of NSD's database. After reply
is sent, zone is discarded from memory.
"Soft-fail" approach is used for parsing and checking, which means that
error in single record doesn't discard whole zone and as long as SOA record
is imported properly, zone will be injected into NSD.
Cache is updated periodically (at the same time when BIND8 stats are
generated or every 60s if NSD was compiled without this feature).
--- PERFORMANCE ---
Test machine:
Intel Atom 1.6Ghz running OpenBSD 4.5 and MySQL 5.0.77.