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

[Timmy]

On 2012-04-22 02:53 AM, Christiaan Rademan wrote:
> 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.
>
>

Migrate to IBM DB2.  There is a source of DB2 driver inside freeradius 
source.