DLZ and LDAP, MySQL

Hi,

 I am thinking about moving to dlz MySQL driver, from what I read about 
performance, LDAP is not a good option. I was thinking of keeping data 
in LDAP and replicate it to local LDAP on the DNS server which uses 
back-sql. back-sql will use MySQL and DLZ will directly read from the MySQL.

Anyone tried this ?

--

-- 
Taymour A El Erian
System Division Manager
RHCE, LPIC, CCNA, MCSE, CNA
TE Data
E-mail: taymour.elerian <at> tedata.net
Web:     www.tedata.net
Tel:    +(202)-33320700
Fax:	+(202)-33320800
Ext:    1101

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

Re: DLZ and LDAP, MySQL

The more moving pieces you have the easier things will break.

Why not just use mysql's replication features?

LDAP may perform fine.  In my performance testing I might not have configured the LDAP server optimally (But
I did try!), I'm not an LDAP expert.  If you are, or know someone who is it could do better for you.

Rob

----- Original Message ----
From: Taymour A. El Erian <taymour.elerian <at> tedata.net>
To: bind-dlz-testers <at> lists.sourceforge.net
Sent: Tuesday, January 1, 2008 6:48:53 AM
Subject: [Bind-dlz-testers] DLZ and LDAP, MySQL

Hi,

 I am thinking about moving to dlz MySQL driver, from what I read about

performance, LDAP is not a good option. I was thinking of keeping data 
in LDAP and replicate it to local LDAP on the DNS server which uses 
back-sql. back-sql will use MySQL and DLZ will directly read from the
 MySQL.

Anyone tried this ?

--

-- 
Taymour A El Erian
System Division Manager
RHCE, LPIC, CCNA, MCSE, CNA

Re: DLZ and LDAP, MySQL

On Tue Jan 01 2008 at 12:48:53 CET, Taymour A. El Erian wrote:

>  I am thinking about moving to dlz MySQL driver, from what I read about 
> performance, LDAP is not a good option.

Why just read about it? It is preferable to experiment. It might very
well fully satisfy your performance requirements.

>                                         I was thinking of keeping data 
> in LDAP and replicate it to local LDAP on the DNS server which uses 
> back-sql. back-sql will use MySQL and DLZ will directly read from the MySQL.

You are asking for trouble. back-sql is nothing more than a bad hack.

> Anyone tried this ?

No. And I wouldn't.

        -JP

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

Re: DLZ and LDAP, MySQL

Rob Butler wrote:
> The more moving pieces you have the easier things will break.
>
> Why not just use mysql's replication features?
>   
Because  I prefer to use LDAP for such type of data (LDAP is serving as 
my backend for everything except billing data)
> LDAP may perform fine.  In my performance testing I might not have configured the LDAP server optimally
(But I did try!), I'm not an LDAP expert.  If you are, or know someone who is it could do better for you.
>
>   
Which version of OpenLDAP did you use and which backend ?
> Rob
>
> ----- Original Message ----
> From: Taymour A. El Erian <taymour.elerian <at> tedata.net>
> To: bind-dlz-testers <at> lists.sourceforge.net
> Sent: Tuesday, January 1, 2008 6:48:53 AM
> Subject: [Bind-dlz-testers] DLZ and LDAP, MySQL
>
>
> Hi,
>
>  I am thinking about moving to dlz MySQL driver, from what I read about
>  
> performance, LDAP is not a good option. I was thinking of keeping data 
> in LDAP and replicate it to local LDAP on the DNS server which uses 
> back-sql. back-sql will use MySQL and DLZ will directly read from the
>  MySQL.
>

Re: DLZ and LDAP, MySQL

I used whatever shipped in Fedora Core 1.  More details on my performance testing setup can be found here: http://bind-dlz.sourceforge.net/perf_tests.html

Details on the tuning and LDAP configuration I used is here: http://bind-dlz.sourceforge.net/ldap_perf.html

Rob
----- Original Message ----
From: Taymour A. El Erian <taymour.elerian <at> tedata.net>
To: bind-dlz-testers <at> lists.sourceforge.net
Sent: Wednesday, January 2, 2008 2:23:02 AM
Subject: Re: [Bind-dlz-testers] DLZ and LDAP, MySQL

Rob Butler wrote:
> The more moving pieces you have the easier things will break.
>
> Why not just use mysql's replication features?
>   
Because  I prefer to use LDAP for such type of data (LDAP is serving as

my backend for everything except billing data)
> LDAP may perform fine.  In my performance testing I might not have
 configured the LDAP server optimally (But I did try!), I'm not an LDAP
 expert.  If you are, or know someone who is it could do better for you.
>
>   
Which version of OpenLDAP did you use and which backend ?
> Rob
>
> ----- Original Message ----
> From: Taymour A. El Erian <taymour.elerian <at> tedata.net>
> To: bind-dlz-testers <at> lists.sourceforge.net

Re: DLZ and LDAP, MySQL

If the ldap driver supported multi-valued attributes it would be as fast
as MySQL, if not faster.

It seems to me that most people are using their existing bind setup
(zone files, some database with a script to export to zone files, etc)
and then replicating to bdbhpt when/if performance is an issue. I could
be wrong about this though as it's just an observation.

-john

Rob Butler wrote:
> I used whatever shipped in Fedora Core 1.  More details on my performance testing setup can be found here: http://bind-dlz.sourceforge.net/perf_tests.html
> 
> Details on the tuning and LDAP configuration I used is here: http://bind-dlz.sourceforge.net/ldap_perf.html
> 
> Rob
> ----- Original Message ----
> From: Taymour A. El Erian <taymour.elerian <at> tedata.net>
> To: bind-dlz-testers <at> lists.sourceforge.net
> Sent: Wednesday, January 2, 2008 2:23:02 AM
> Subject: Re: [Bind-dlz-testers] DLZ and LDAP, MySQL
> 
> 
> Rob Butler wrote:
>> The more moving pieces you have the easier things will break.
>>
>> Why not just use mysql's replication features?
>>   
> Because  I prefer to use LDAP for such type of data (LDAP is serving as

Bind DLZ on windows

Been a LONG time since I posted but looking into DLZ again.

I am curious of my options to get it setup on windows.

Has anyone got it setup on a virtual server like VMWare?

Directly installed on Win2003?

Can anyone report on long term stability?

Looking at starting with approximately 3000 domains, pretty basic RR's.

Thinking BDB or ODBC, would love something with a webservice interface or a 
clean management app, currently using WMI to add to MS DNS and it is VERY 
slow to add domains.

Would be willing to donate to (a) open source project(s) if I can get a good 
solution out of this, biggest factor is stability.

Would love any info possible.

David Maggard

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

Re: Bind DLZ on windows

Dave,
I have a Bind patched with DLZ for MySQL running on several Windows 2003
Enterprise Servers.  The build was done by Gabor
(http://web.axelero/marcz/dlz-bind-win32.html), 'cos I just couldn't get
it to compile on my dev machine.

Been running for a while does some strange things like hog CPU if it
fires up before MySQL does, or if the MySQL service terminates, as it
sometimes does.

I'm using it for X.25 DNS lookups for X.25 over IP networking with Cisco
routers.  The Cisco routers don't do DNS queries correctly so the BIND
server is a little slow.

Every so often I get weird errors and the service shuts down.  Windows
2003 Event Viewer does not provide me with enough information to
determine why.

A part from the above - works well for my needs.

Cheers,
mick.

-----Original Message-----
From: bind-dlz-testers-bounces <at> lists.sourceforge.net
[mailto:bind-dlz-testers-bounces <at> lists.sourceforge.net] On Behalf Of
David Maggard
Sent: Sunday, 13 January 2008 10:38 AM
To: bind-dlz-testers <at> lists.sourceforge.net
Subject: [Bind-dlz-testers] Bind DLZ on windows

PostgreSQL Table design

Hello *,

I have not used DLZ since arround 2 1/4 years and now I restarting my
business and like to setup 5-8 domains with arround 180 subdomains and
in summary nearly 800 hosts.

For easier setup I like to use a singel table.

Does anyone have a working and easy setup for it?

Thanks, Greetings and nice Day
    Michelle Konzack
    Tamay Dogan Network

--

-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSN LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
Bind-dlz-testers mailing list
Bind-dlz-testers <at> lists.sourceforge.net

Re: PostgreSQL Table design

Do you want transfers in the same table?
I do not think that's a good setup. 

Cheers,

Graham Weldon

Fluid Lino
(02) 4927 5337
(0407) 017 293
graham <at> fluidlino.com.au
www.fluidlino.com.au

-----Original Message-----
From: bind-dlz-testers-bounces <at> lists.sourceforge.net
[mailto:bind-dlz-testers-bounces <at> lists.sourceforge.net] On Behalf Of
Michelle Konzack
Sent: Thursday, 17 January 2008 6:00 AM
To: bind-dlz-testers
Subject: [Bind-dlz-testers] PostgreSQL Table design

Hello *,

I have not used DLZ since arround 2 1/4 years and now I restarting my
business and like to setup 5-8 domains with arround 180 subdomains and
in summary nearly 800 hosts.

For easier setup I like to use a singel table.

Does anyone have a working and easy setup for it?