Re: [gentoo-server] ldap or mysql?

[Claudinei Matos]

Is there a way to make system accounts authentication on mysql?
I know theres a way to do that with ldap but I already have one mysql
database to authenticate my domain email accounts and also to my
website login system.
I will be so happy if it could be done.

claudinei matos

On 5/19/05, Eric Paynter <eric@×××××××××××.com> wrote:
> I assume you mean OpenLDAP...
>
> The key difference is performance. A web application will typically do an
> authorization every time the user hits a page. That's a lot of lookups - a
> lot of hits to the database. On the other hand, updates to an
> authorization database are relatively rare. OpenLDAP, as an
> authentication/authorization tool, is tuned for extremely fast lookups.
> The whole way the database is indexed and stored on disk is to provide
> lightning fast lookups. However, it's quite slow for updates. Mysql is a
> general purpose database. It is tuned quite well for both lookups and
> updates. It is much faster than OpenLDAP for updates, but can't even come
> close for lookups.
>
> That being said, with today's hardware, unless you are expecting a lot of
> traffic, either one will do. Unless under load, mysql will respond in
> milliseconds. However, if load is a concern, OpenLDAP might save you on
> hardware costs (don't have to buy as many servers), and it will not add
> any latency to you web transactions. But mysql is probably easier to
> manage, especially if you already know SQL.
>
> -Eric

-- 
gentoo-server@g.o mailing list