Choosing The best replication system.

[Sarkis Gabriel]

Thanks for the information below, just couple of questions need to clarify.

If we say Point A is the Master Server, Point B and Point C are Slaves, 
does All Authorisation as in prepaid and account info which are stored on the Master
will they replicate in real time to Point B & C?

Also if Point B uploads the accounting info at the end of the working day to the master
Server will Mysql replicate down to point C?

Thanks again

Sarky

---------- Original Message -----------
From: Nicolas Baradakis <nbk at sitadelle.com>
To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Sent: Sat, 9 Dec 2006 14:42:41 +0100
Subject: Re: Choosing The best replication system.

> Sarkis Gabriel wrote:
> 
> > At the moment i have 4 pops around the country and all are feeding
> > from a satellite links, as the company is growing it is becoming
> > very hard to maintain and we are looking to have a central MySQL DB
> > in the UK which feeds the slave machines with the updated info.
> 
> I'd suggest to have two distinct mechanisms for authorization (using a
> read-only database) and accounting (using a write-only database).
> 
> The authorization database could be replicated on each RADIUS server
> host using MySQL replication. (because FreeRADIUS will do only read-only
> requests on the local slave)
> 
> The accounting data could be saved in text files on the local disk
> using rlm_sql_log. The data can be pushed later in the central
> accounting database using radsqlrelay.
> 
> > One thing I must mention there is a lot of LAG on satellite
> > connection looking at approx 650ms and because of BW cost we do rely
> > on proxies which makes BW usage during the day very expensive, so i
> > would like to be able to replicate maybe once a night lets say at
> > midnight being less busy and cheaper.
> 
> You could try to use radsqlrelay in one-shot mode. (see the manpage)
> Just run radsqlrelay in a daily cron job to push all the accounting
> data at a fixed hour.
> 
> -- 
> Nicolas Baradakis
> 
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------- End of Original Message -------