How many up un a sql ip pool

Alan DeKok aland at
Tue Dec 16 14:27:20 CET 2014

On Dec 15, 2014, at 4:54 PM, Fabrizio Fiore Donati <fabrizio.fioredonati at> wrote:
> we have 3 pppoe access server, now i want to use a centralized ip pool via radius, can freeradius manage an ip pool of about 10000 ip via sql-ip pool ?

  Yes.   I’ve used it with 300K IPs.

  The issue is less the number of IPs than the rate of change.  With all of the queries necessary to manage IPs, SQL databases can typically do no more than 150 or so IP address assignments per second.  So if your system is under that limit, you’re fine.  If it’s over, you’ll have to come up with a different technique to improve performance.

  Alan DeKok.

More information about the Freeradius-Users mailing list