In doc/configurable_failover you have your answer. I've tried the same schema you wanna do and it works perfectly The mirroring between the two mysql db work with the replication mechanism of mysql (read the mysql doc) and I have two sql.conf to describe the way to connect to each db and right config on radiusd.conf to tell it how using this two db.
If you want some more help ask ... :] -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Paul Envoyé : mardi 28 septembre 2004 18:12 À : [EMAIL PROTECTED] Objet : SQL db failover Hi folks. We need to have a 2 server deployment with accounting and session tracking using an SQL db (mysql or postgres). What i would like to do is: - Each server has a local DB running - Both DB's should have data synchronized for sessino tracking - All accounting is written to local DB and remote DB with the following logic: write local then remote, if local fails ignore failure, for session query only local DB, if local fails then query the remote DB. Anyone tried something simillar ? Any suggestions to sql.conf/radiusd.conf syntax ? Thanx Paul - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html