Choosing The best replication system.

[Nicolas Baradakis]

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