Simple 2 Server High Availability
agtmcgarry at gmail.com
Wed Aug 6 10:48:05 CEST 2014
I recently installed mysql cluster and freeradius. Each freeradius instance talks to its local mysql api only.
I used disk data tables for accounting records, except for the indexes and so far so good.
On 6 Aug 2014, at 09:38, James Bensley <jwbensley at gmail.com> wrote:
> Hi All,
> Thanks for the input, I have spoken with a DBA friend I trust and he
> also warned against master-master because it is a pain to manage. The
> two servers are going into two seperate DCs to cover things like
> maintenance windows on core routers at the DCs and also to allow us to
> take the servers themselves down for maintenance individually so they
> need to be able to operate on their own for a period of time.
> After sending yesterdays email I read more, I didn't realise Postgres
> was supported natively! :)
> The RADIUS boxes are for an ADSL platform, they will hold user records
> and accounting records. I want both user account records and
> accounting info to be in the database (but not FreeRADIUS config [if
> that is even possible?] so people can't make a change and replicate
> that taking them both out simultaneously). I think perhaps a master to
> slave is best but with the loss of a master the slave must cache DB
> updates until the master returns.
> Looks like radsqlreplay is what I need, is that DB agnostic, will it
> support either MariaDB and Postgress denpending on which one I choose?
> Many thanks,
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users