[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    R: merging accounting records from two databases
From:       "Francesco Cristofori" <f.cristofori () satcom ! it>
Date:       2007-09-26 14:31:00
Message-ID: 40024F8DD02C1041B9A090206D9B818F01B32F9A () mail-ex ! lan-satcom ! it
[Download RAW message or body]

> 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.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]