buffered-sql, radsqlrelay and fault resilience

[Matthew Newton]

On Mon, Jun 10, 2013 at 05:14:16PM +0200, Yann Belin wrote:
> I am trying to build a multi-server setup, where each server uses a
> local user database (replicated from a central management server) and
> buffers its accounting data before pushing it back to the management
> server. I have tried two different methods, but none fully satisfied
> me so far.

In case it's useful:

Our "front-end" RADIUS servers[0] write a 'detail' log file to disc.

We then have a detail reader (see "copy-acct-to-home-server"
virtual server) that reads this file and relays it to the
management RADIUS server for centralised logging.

If the management server goes down, the files on disc just grow
until it comes back again and then the logs are relayed over.

It works well, and means that there are no dependencies on the
management server for service to be operational.

HTH,

Matthew


[0] recent 2.x from git

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