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 <[EMAIL PROTECTED]> To: FreeRadius users mailing list <[email protected]> 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 ------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
