IP Allocation FAILED : Best practice for inserting new IPs into mysql

[Arran Cudbard-Bell]

> On 20 Nov 2015, at 09:59, Sophie Loewenthal <sophie.loewenthal at trimbletl.com> wrote:
> 
> 
> 
>> <shrug>  Use a database that works.
> 
> Upgrade is being planned.

An alternative is to use v3.1.x and rlm_redis_ippool.  That has significantly higher performance than any SQL based solution, and is guaranteed not to deadlock, as Redis is largely single threaded and lockless.

It scales by distributing different ip pools between different cluster nodes.

-Arran

Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS development team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 872 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20151120/c81d582e/attachment-0001.sig>