On Fri, 29 Mar 2002, Vo Minh Thanh wrote: > Hi, > I am using FreeRadius version 0.4 with MySQL. I test it with a small > database, some users in radcheck table. > It's so good. What about very large database ? (1,000,000 users or more). > And which database is better?Oracle or MySQL or LDAP? > Sinserly. >
SQL databases are very good when you do both reads and writes. LDAP databases are very good when you do a lot of reads. I don't think that there will be much difference between a well tuned Oracle SQL server and an ldap server. In general though ldap is more simple and scales very well. It is also the best choise when you want to base a lot of services on the same user database. I would suggest using an ldap backend for user authentication/authorization and sql (mysql with innodb tables or oracle) for accounting especially if we are talking about such numbers (1000000 users). -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 10 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
