RE: Virtual server specific SQL schema.

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