On 24 Jul 2012, at 18:18, Arran Cudbard-Bell wrote:
>
> On 24 Jul 2012, at 14:24, Alan DeKok wrote:
>
>> Amir Tal wrote:
>>> After additional debugging the fault seems to be with a rouge backup
>>> process running on DB host, causing it to be slow to un-responsive for
>>> 10-20 minutes.
>>
>> Stop that. The database used by the RADIUS server should ONLY be used
>> by the RADIUS server.
>
> Use SQL replication to transfer the records to another system and backup from
> that. Do not perform intensive queries on a live system. It also sounds like
> you might be using MyISAM for radacct, if you are convert it to InnoDB ASAP.
>
> Yes you can use buffered SQL to protection against temporary DB outages. But
> only for Accounting. Don't try this on 2.1x branch, use 3.0 if you want
> something that actually works reliably...
>
> Yes you can use redundant to fail open or closed, but its simpler to just:
Um and
redundant {
sql
ok
}
Wouldn't work...
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
