BIND8 & MySQL

[Conny]

On Tue, 16 May 2000 chrismc at scrappy.primary.net wrote:

> I think you misunderstood what I'm after.  I'm not looking to have the
> named querying directly off the MySQL, merely have it load zones off
> MySQL.  I can see where you are going with that, and yes MySQL is absurdly
> slower at queries than is named.  I'm simply looking for a way to have the
> zones files maintained in MySQL, then loaded into named directly from
> there (No text zones in between).  As far as numbers for you, I don't know
> but I would guess its a lot ;-)

Doesn't the sqlbind patch in /contrib/sqlbin-8/ achieve just what you
want? While waiting for bind9:s pluggable data backend, I'd rathert go for
extraction of zonesfiles from a database than modifying bind tough.

//conny

> \ Chris McCracken
> / UNIX System Administrator
> \ Primary Networks Internet
> / chrismc at primary.net
> 
> 
> 
> On Tue, 16 May 2000, David R. Conrad wrote:
> 
> > Hi,
> > 
> > Two quick questions:  how many queries per second does your nameserver get? 
> > How many queries per second can MySQL handle?
> > 
> > Rgds,
> > -drc
> > 
> > chrismc at scrappy.primary.net wrote:
> > > 
> > > I don't think that much would be gained from exporting SQL to text files
> > > that you couldn't do with some scripting.  Has anyone actually run SQL as
> > > a backend to BIND ie. have named actually pull the queries straight as SQL
> > > queries, or import the zone files straight from MySQL to BIND database
> > > files (not text)?  I know someone has already created an interface to
> > > manage your named.conf in MySQL, but I would like to manage the zone files
> > > straight in SQL.  Any ideas wouyld be appreciated.
> > > 
> > > ~Chris
> > > UNIX SysAdmin
> > 
> > 
> > 
> > 
> 
> 
>