ahurt at ena.com
Mon Jul 22 17:34:35 CEST 2013
On Jul 22, 2013, at 10:17 AM, Aaron Hurt <ahurt at ena.com> wrote:
> On Jul 22, 2013, at 9:51 AM, Alan DeKok <aland at deployingradius.com> wrote:
>> Phil Mayers wrote:
>>> Yeah, definitely. TBH I keep wondering if a better approach to
>>> accounting long-term wouldn't be to keep live sessions in something
>>> NoSQL e.g. redis, then move them to SQL on session close, when the sum
>>> total of the data is known.
>> Yes. That allows for MUCH more performance.
>> Some ISPs, tho, want to log all accounting packets. Others want to
>> query live sessions via SQL.
>> So any redes-enabled speedup would have to be site-specific, and
>> Alan DeKok.
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
> We're working on a project with huge accounting needs and did run into some issues using the current SQL module and decided to write our own module to store accounting data and user authentication data in a nosql document database as JSON. I think this will become increasingly common and nosql/json seems to be a very natural fit for value pair data.
> -- Aaron
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
Just to clarify … there wasn't anything wrong with the rlm_sql module it was just a matter of scaling hardware to support the load on our end to do this with a traditional database.
More information about the Freeradius-Devel