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