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