Dennis Skinner dskinner at
Tue Aug 8 22:34:13 CEST 2006

Scott Hughes wrote:
> Now that I've opened this multi-radius server can of worms ... is switching
> over to use the mysql backend on another host as simple as:
> 1) Installing mysql on another server;
> 2) Running the mysql.sql on that server to setup the radius database;

2a) Populate the database

> 3) Changing the radiusd.conf (after backing it up) and un-commenting the
> area that deals with the mysql

Yeah.  You may want to setup failover in the authorization section.
Here we have a master/slave sql setup.  All reads are done on the slave
if possible and writes (accounting) are done on the master.  This should
help speed up things.

I also recommend using InnoDB engine instead of the default MyISAM.
MyISAM does table locking instead of row locking.  Also database dumps
for backups can be done without locking the table with InnoDB.

Dennis Skinner
Systems Administrator
BlueFrog Internet

More information about the Freeradius-Users mailing list