Redundant Accounting

Alan DeKok aland at
Tue Jun 22 10:18:59 CEST 2010

Marius Pesé wrote:
> Hi everyone,
> I have set up a FreeRadius2 v2.1.8 installation a while back and
> configured it according to our needs. It is running smoothly, currently
> doing Auth and Acc on one box with a MySQL database and a detail file
> being used. We now want to set up a second box which basically shall do
> the exact same thing as the first does as a failover and also give us
> two identical accounting tables in the databases.

  You're trying to configure:

	        = RADIUS + MySQL
	NAS -> /
                = RADIUS + MySQL


  Instead, configure

                 = RADIUS =     = MySQL
	NAS -> /           \ - /
               \ = RADIUS =/   \= MySQL

  i.e. Configure MySQL failover for the two RADIUS servers.

  This turns the problem into a MySQL problem, rather than a RADIUS one.
 It also gives you two points of failover, rather than one.

  Alan DeKok.

More information about the Freeradius-Users mailing list