On Thu 17 May 2007, Alan DeKok wrote: > Angelos Karageorgiou wrote: > > Has anyone had the time to do a DB performance comparison for heavily > > loaded freeradius servers ? > > If your server is busy enough to be heavily loaded, you need multiple > machines to maintain quality service. Once you have multiple machines, > DB performance matters a lot less, because the load is spread across > multiple machines. > > For DB specific issues, look for DB performance on google. PostgreSQL > usually has better performance than MySQL. The application using the DB > (radius, web, etc.) has very little effect on DB performance.
Unless you are doing monthly or yearly summary reports which can take a lightly loaded DB server and peg it for minutes at a time... The lesson.. Keep a second DB for reporting :-) -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
