bind with mysql

[Agnello George]

On 4/4/08, J. Peng <peng.kyo at gmail.com> wrote:
> Thanks so much for Bill and Chris. Your answers were so professional,
> that let me learn a lot.
> We have the plan to provide business domain hosting. I don't know the
> actual amount for the domains and zones, but we current time have 200
> million registered users on other products.
> So as you see we're a large internet service provider. I assume there
> will be lots of customers to use our domain hosting too.
>
> Following your suggestions, I think the database drived BIND is not
> suitable since it's going with poor performance.So I think about the
> first architecture:
>
>                                                             --->
> slave 1 (standard BIND)
>                                                            |
> web interface --->  BIND+Mysql (master)  | ---> slave 2 (standard BIND)
>                                                            |
>                                                             --->
> slave 3 (standard BIND)
>
> There are one master and more than one slaves.
> master is running with database drive, but it doesn't provide services
> to public.
> master only updates the records and zones, primarily done by web
> interface programs.
> slaves are standard BIND, when master is updated, it notify slaves to
> update their own zone records, with standard bind data transfer
> way.all slaves provide DNS service to public directly.
>
> Is this the good architecture for both performance and conveniences?
>
> If that is not good way yet, I could go with the second architecture,
> to make master to run without using DLZ, but use the standard BIND
> config files. Under this architecture, the management programs are a
> little complicated. rather than inserting and updating database
> directly, they need to parse and modify BIND's config files. But as
> Chris said, it's not so hard. Perl is strong enough for this work I
> may think.
>
> So, what's the best solution for me? the first architecture or the
> second one, or neither of them?
>
> Thank you so much for your further suggestions.
>
> B. Regards,
> Joy Peng
>
>
>
> On Fri, Apr 4, 2008 at 2:43 AM, Chris Buxton <cbuxton at menandmice.com> wrote:
> > I would tend to recommend that you look at management products available
> > before reinventing the wheel.
> >
> >  As noted by Bill Larson, using a database-driven system like this,
> > especially if you try to get BIND to read directly from the database (using
> > DLZ), can be quite problematic. It might be better to examine a third-party
> > management system that can be customized to meet your needs.
> >
> >  If you are interested in discussing how Men & Mice Suite can be used for
> > your project, please contact me off list.
> >
> >  Chris Buxton
> >  Professional Services
> >  Men & Mice
> >
> >
> >
> >  On Apr 2, 2008, at 11:44 PM, J. Peng wrote:
> >
> > > I want to setup a pair of bind (a master and a slave).
> > > This pair of bind will have lots of zones, in each zones there are at
> > > least some A records and MX records.
> > > I think I can setup a mysql for those records for bind master.
> > > Also I can setup mysql replication and use mysql slave for bind slave.
> > > Is this good resolving way? please suggest, thanks.
> > >
> > >
> >
> >
>
>

I was just reading through... and it seem to be the same issue i will
be facing in few months from now. I too work for web hosting company
having 2000+ domains . We are located in India. Well currently we use
a ready made set up plesk and cpannel ansd WCP . But as the business
is expanding we plan to come up with our own control pannel . We have
to provide services to ur customers in namely 4 areas :

mailing hosting
webhosting
FTP
Bind

with regards to Bind  i researched on bind-dlz and found it worth
while as it would be difficulty to write on plain files ( zones) . We
are are going ahead with bind dlz

here is a litte bit on  my finding on bind dlz

http://linux-vashi.blogspot.com/search?q=bind+dlz

do let me know if there are other ""better "" ways to hold zone files!



-- 
Regards
Agnello Dsouza