Peter Nixon wrote:
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 :-)
Or use clustering :p What kind of performance are people getting in general ? On our test servers we get about 460 pap req/s using LDAP + SQL + SQL xlat for authorisation, and around 800ish when just using LDAP.... Which isn't that bad really... 1 LDAP lookup 5 sql selects and 1 sql insert per query ... Flat out using pap only and users file we only get 4600 req/s ... must be something weird with the G5s .... Would be nice if someone altered the make file to pass the G5 optimisation flags by default ;)