So,
a) SQL could fail sometimes (if server has high load)
b) cdb auth will not fail, but will always be _slower_ than
SQL. Did i understood right ?
And i guess, under the light of these 2 topics,
cdb auth mechanism will be better for a 'little' server.
(my 'little' term is 40-50 max domains and 2000-2500 max users)
mgm
-----Original Message-----
From: Michael Boman <[EMAIL PROTECTED]>
To: Ninad Gupte <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 13 Eylül 2000 Çarşamba 18:15
Subject: Re: Is MySQL preferred?
>Ninad Gupte wrote:
>>
>> Hello Guys,
>>
>> I have been following up on vpopmail and intend to start using it on our
>> production server now. However I would like to know whether there is any
>> advantage in using MySQL authentication over standard file based
>> authentication. I understand that as a sysadmin, I might have easier
>> control / access to user data, etc. But is this good enough on a system
>> handling say about 3000 users and hosting a few hundred domains?
>>
>> I had a past experience with an ISP who used MySQL for authentication (I
>> dont know whether he was using vpopmail, or something else), and the
>> authentication would fail at times under heavy server load. I do not want
>> such a scenario to be repeated.
>
>SQL databases has that problem, and there is not much you can do about
>it except using a caching daemon. I haven't seen anyone for qmail, but I
>know courier has a caching daemon for authication.
>
>To play it safe for now, use cdb auth.
>
>> I will wait for inputs from users who have already been running their
vpop
>> under MySQL before going ahead with the setup. Also are there any such
>> problems with filebased authentication under loads, that I probably did
not
>> realise?
>>
>> Thanks
>> Ninad
>
>Filebased auth. takes long time to update with many users (in the same
>domain) and with high server load.
>
>/Mike
>
>--
>Pager : out of order | On the contrary of what you may
>Mobile: (+65) 98 55 17 34 | think, your hacker is fully aware
>eMail : [EMAIL PROTECTED] | of your company's dress code. He
>ICQ : 5566009 | is fully aware of the fact that it
>Handle: proxy / 11 Alliance | doesn't help him to do his job.
>
