Virtual server specific SQL schema.

Tim Sylvester tim.sylvester at networkradius.com
Tue Jun 15 22:00:36 CEST 2010


> Thanks for the suggestion, that's actually my back-up plan.  The key
> issue is that a single MySQL server will be used, and peak-load on that
server
> can be quite high.  By creating multiple instances, I cannot scale the
maximum
> number of sockets high enough meet the requirements.  Perhaps on missing
> something with regard to MySQL optimization, but during testing I found
increasing the
> maximum number of sockets was necessary to meet the performance
requirements.

What level of performance do you need - authentication/sec & accounting
packets/sec? FreeRADIUS with MySQL is able to 1,000s of authentications/sec
and reasonably large number of accounting packets/second. You should be able
to tune MySQL to improve the performance.

Tim





More information about the Freeradius-Users mailing list