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 <[EMAIL PROTECTED]> 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 -- [email protected] mailing list
