sql or radtmp - which best?

[Matthew Newton]

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
> mysql).

Plain text files are pretty much always going to be faster than a
database lookup.


> 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
> databases?

Ask your DBA.


> What are the best practices to store users, nas and accounting data, sql or
> files?

Depends on your situation and what you are trying to achieve.

Matthew


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