Am Dienstag, 26. August 2014, 10:28:31 schrieb Daren Hendricks:
Hi Everyone,
We have 2 radius servers (v2.2.1) a primary and secondary. Currently both use same mysql database that lives on the primary server. For HA sake we would like to have the following setup. The primary server will read/write to it's radius DB and that will be replicated using mysql replication to the secondary server. The secondary server will then read/write to the replicated db and forward/proxy it's accounting data to the primary server.
Writing into a replicated secondary sounds like a bad idea. I am not a MySQL expert, but I would write always to the primary DB. But perhaps the replications mechanisms in MySQL go both ways.
Does this sound like a feasible solution? Also, what can we use to forward the accounting data to the primary server, would robust-proxy-accounting be something worth looking into?
Regards Mit freundlichen Grüßen,
Michael Schwartzkopff -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64, +49 (162) 165 0044 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein