sql or radtmp - which best?
mcn4 at leicester.ac.uk
Thu Mar 19 12:07:59 CET 2015
On Thu, Mar 19, 2015 at 09:14:27AM +0100, Marcin wrote:
> Hi, I starting with freeradius 2.4 with flat files. I've heard that
> freeradius with flat files works faster than works with sql (postgres or
Plain text files are pretty much always going to be faster than a
> Which should i chose to accounting users, sql or files? maybye both?
Depends on what is "fast enough" for your use case. SQL or another
database may be easier to manage.
> In some documents I've read that accountigs should be stored with two
> tables. one table to online sessions and second table to archive data, but
> how to split it? In that case when client disconnects i should use two
> questions to database with different tables, one to delete online sessions
> and second to insert data to "archive" table.
Update one table with the accounting stop time, archive as a
background job separate from FreeRADIUS?
> but when we use database we should replicate data, how to synchronize
Ask your DBA.
> What are the best practices to store users, nas and accounting data, sql or
Depends on your situation and what you are trying to achieve.
Matthew Newton, Ph.D. <mcn4 at le.ac.uk>
Systems Specialist, Infrastructure Services,
I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom
For IT help contact helpdesk extn. 2253, <ithelp at le.ac.uk>
More information about the Freeradius-Users