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 http://www.bluefrog.com