How fast can IP Pool SQL be? :) *a Shocker*

[Christiaan Rademan]

Greetings everyone,

I previously had a post concerning authenticate over 2 million+ mobile 
subscriber users on FreeRadius. We did performance testing yet, failed 
but due to pressure from client we went a head with the migration. The 
migration failed at this point, since the Radius Server could not hand 
out more than 25 IP addresses per second. Obviously this was due to slow 
database server / resources. FreeRadius was happy to hand out logins 
once the pool assignment was done on the GGSN.

So I am wondering, I found a solution to the problem and we are now 
handing out IP addresses easily.. 5000+ accept-accept responses per 
second with framedipaddress included from a pool within SQL.

Quad Zeon, 4 core, 8 threads, 16gig ram runnning Ubuntu Linux. Is it 
possible to hand out that many ip addresses per second? :) The box is 
also running both the radiusd and mysql process using a standard storage 
engine. Not using NDB or anything special. Is this really an impossible 
task? Maybe I can find out from our company if I may release the code we 
using to make this work.

I would really like to help improve the SQLIPPool module. Since the 
version we were using could only do 25/s now we are over 5000/s.


-- 
Christiaan Rademan - JNCIE #661

Mobile: +27 83 419 2078
E-mail: christiaan.rademan at gmail.com