Redundant Accounting

[Alan DeKok]

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

  Don't.

  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.