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
Re: Choosing The best replication system.
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 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 --- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Choosing The best replication system.
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 [EMAIL PROTECTED] 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 --- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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