db performance

[Peter Nixon]

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