tnt-4 wrote:
I don't use authentication.
I hope this means "I don't use radius authentication."
I'll give you the full description of my system and maybe you think of a solution without modifying the source code: A client sends only Accounting Start Requests(the same request for the 2 servers) to my 2 radius servers (geographically separated). The requests
are
send to separate DBs.
OK. You are independantly processing the same information by two radius servers storing data in different databases in parallel. No interaction whatsoever. Unsuprisingly, when things go wrong, it's not going to be easy to sync them up again. If they were in sync at all.
Considering that freeradius is multithreaded and that it has multiple threads to the database what chance is there that database info will be consistant after a while? On low load - good. With high loads or spikes - slim to none.
Processing information independantly is a bad idea if you want to have identical copies of data. You can have both redundancy and consistancy using built-in capability of your devices: NAS should have easily configurable radius server fail-over; freeradius has configurable sql module fail-over (see man unlang); sql servers can manage replication between databases and maintain identical data sets. So, if radius1 fails, radius2 takes over; sql1 will replicate data to sql2; if sql1 fails data will be sent to sql2 and replicated to sql1 whan it comes back (multimaster replication). If basic capabilities are not good enough for you, there are high availability solutions that can improve on fail-over and replication.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
The load will be very low: maximum 30 requests/second. I'm now thinking of altering the code so that when the connection to the DB is reestablished a stored procedure( named SYNC_DB) will be launched. Does anyone know which files I have to modify ? -- View this message in context: http://www.nabble.com/SQL-Query-question-tp19992564p20031606.html Sent from the FreeRadius - User mailing list archive at Nabble.com.