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@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