[isp-dns] Re: DNS with MySQL backend

[Len Conrad <LConrad@...>]

> > >Are there any noticeable performance hits using Bind with Mysql ?
> >
> > BIND is a purely in-memory server.  MySQL is an on-disk server.
> >
> > Which data access do you think will be faster?
>
> In reality it should be done somewhat in between, providing for fast
> access with convinience of database storage. The server should read
> record from the database when first request comes in and cache it.
the BIND-data-in-external-db project approach is simplified to be being 
almost trivial by leaving BIND just as it is.

The external database exports to standard BIND text files, and then BIND is 
signalled to "reload" or "reconfig".

> If there is no request in given time, it should be removed from the cache
> automaticly so as not to waste the memory.
BIND holds its entire authoritative db in zone memory (not in cache), why 
would it need purge data obtained through an external database interface?

>  Any modifictions to database
> should be logged as to which record was notified so that running server
> could automaticly reload that particular record when next request comes in.
BIND doesn't read individual changed records from the zone files, it 
reloads the entire zone file (for static zones).

> Now am I dreaming or did somebody actually implement something like this?
I'm sure nobody has implemented your approach with BIND since it is a poor 
approach that would require extensive modification to BIND itself.

If your DNS records are changing so rapidly to need such poor approach, 
then have the database up send dynamic updates to BIND.

Len


_____________________________________________________________________
http://MenAndMice.com/DNS-training : Atlanta; SFO; Denver; NYC
http://IMGate.MEIway.com : free anti-spam gateway, runs on 1000's of sites







To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016

Please include the email address which you have been contacted with.

------------------------ANNOUNCEMENT---------------------------------
---------------------------------------------------------------------
       - ISPCON Spring 2004 - Washington DC Hilton & Towers -

            - The ISP and WISP event - www.ispcon.com -

 - Fill your brain. Meet the people. Join the industry gathering! -
----------------------------------------------------------------------
----------------------------------------------------------------------