R: merging accounting records from two databases

Francesco Cristofori f.cristofori at satcom.it
Wed Sep 26 16:31:00 CEST 2007


> Hi,

Hi Stella,
I ran in your problem just quite weeks ago and I solved this way:
- Use mysql replication for syncing the two database (you have to make
db1 slave of db2 and db2 slave of db1: every record inserted in one db
will be automatically inserted in the other one)
- Use heartbeat (or whatever you like most) to configure a virtual ip
for the two db servers. (eg: db1 has 10.0.0.1 , db2 has 10.0.0.2,
virtual ip is 10.0.0.3)
- Configure sql module to point to the virtual ip (eg: 10.0.0.3) so the
radius servers are unaware of the underlying mysql cluster.

You can find lots of docs on google about every topi listed above.

> Cheers,
> Stella

Hth,
	Francesco.




More information about the Freeradius-Users mailing list