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@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@le.ac.uk>