Anyone out there with some guide or atleast some pitfalls i should try and avoid on Replicating the radius server ? Sarky ---------- Original Message ----------- From: "Sarkis Gabriel" <sarky@raycon.net> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Sent: Thu, 7 Dec 2006 17:29:22 +0100 Subject: Choosing The best replication system.

Hello all,

With the way work is and the pops are growing looks like i need to start centralising the database.

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.

Each pop will have a live radius / mysql db feeding info back to a master machine in the UK and that would replicate the info down to the slaves on the other pops, this is the wishfull thinking i have :).

I have read about Replication with MySQL (One-Way) and radrelay, then i noticed there is rlm_slq_log and 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.

Any one out there with some ideas they can send my way..

Thanks

Sarky - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ------- End of Original Message -------

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@sitadelle.com> To: FreeRadius users mailing list <freeradius-users@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 -------

Sarkis Gabriel wrote:

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?

MySQL replication isn't real-time. I think you can espect a few seconds of lag between the master and the slaves. But I note this isn't a FreeRADIUS question, it's a question for the MySQL mailing list.

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?

Yes. (if everything is configured properly) -- Nicolas Baradakis

The question is in which way do u backup it? Using mysqldump in your cronjob? Maybe its a better way to simply create a copy of /var/lib/mysql. All your databases are in there and copying tis don't affect the running mysqld in any way. We do that on lots of server every night... cheers Sebastian Peter Nixon wrote:

On Sun 12 Mar 2006 16:05, Sarkis Gabriel wrote:

...

Hi all

i started backing up the db using a crontab job early in the morning which backs up everything, but i have had complains from users who try to logon after the backup process.

What is the best way to backup an active database with radiusd waiting for connection?

You could use postgresql instead of mysql. It doesn't lock the database while doing a backup so everything just slows down a little while backing up, but keeps on working..

------------------------------------------------------------------------

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- mfg S.Wild Cronon AG - Technik - +49 941 56 71 23 95 Fon direkt +49 941 59 57 91 64 Fax +49 941 79 77 58 9 SIP +49 941 58 41 03 9 Fon Technik zentral "Die Predigt in einer Kirche macht den Blitzableiter auf der selbigen nicht überflüssig!" Georg Christoph Lichtenberg