Re: [Exim] mysql tables and lookup

Top Page
Delete this message
Reply to this message
Author: james
Date:  
To: robert rotman
CC: exim-users, Dan Kappus, Derrick MacPherson
Subject: Re: [Exim] mysql tables and lookup
On 25-May-00 robert rotman wrote:
>
> On Wed, 24 May 2000, Derrick MacPherson wrote:
>
>> http://www.netd.co.za/mysql_mail/
>> seems to be work fine. i have tested it...
>
> for me too, but
> think of ldap if you want > 10000 accounts.


We're running a mysql server for mail, apache, and ftp on a single server.
10,000 domains, 114,000 users, each of which can have up to 6 pop accounts.
It's always been very reliable. LDAP on the other hand is great for getting
single results from a large db, but something worth considering is that getting
a large result set with a query from LDAP is (and I quote from Netscape) "not
advised". You may not need to run a query of that type, but if you do, stay
well away from LDAP.

If you're worried about mysql, try looking at postgresql - I've switched all
my new developments to that out of preference (7.x is just released, but for
production systems I'd go for 6.5.x, since for example the DBD::Pg module won't
work with the new version)

james

--
James Greenhalgh - Unix Systems Architect

* The views in this message are not those of Powernet Telecom Ltd *