How fast can IP Pool SQL be? :) *a Shocker*
moonyhk at netscape.net
Sun Apr 22 08:08:26 CEST 2012
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
More information about the Freeradius-Users