SQLIP pool backend - MySQL or PostgreSQL

rsg ranil.santhish at gmail.com
Wed May 7 17:57:25 CEST 2008

>From my experience when MySQL InnoDB (for ip-pool-table) and row-level
locking is used, I didn't come across any issue with duplicate IPs for
250+ concurrent auth requests made.

I have different architectural issues for successful Auth and
Accounting, but aren't related to SQLIPPOOL..

On Wed, May 7, 2008 at 4:43 PM, Flamur Rogova <flamur at ipko.net> wrote:
> Hi,
>  I have been using rlm_ippool successfully for more than a year, and didnt
> have problems with it.
>  Since we have many IP pools(~4-10 per nas) and we need non-continuous IP
> addresses in pool, I would try SQL based pools.
>  I have read some posts that in MySQL you might get duplicate IPs if you
> have a lot of connections towards db...
>  Could you share your experience/opinions on sqlip/MySQL or sqlip/PostgreSQL
> under heavy load, if you use any ?
>  Thanks,
>  Flamur
>  -
>  List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

More information about the Freeradius-Users mailing list