MySQL Cluster as back-end for FreeRadius

[David Peterson]

MySQL cluster requires quite a bit of hardware to do properly.  I went with
the "Network Raid 1" type of setup for Freeradius, MySQL and DHCP.  This
allows you some redundancy with a plain vanilla setup of FR>  Ubuntu has a
great tutorial on how to set it up.

https://help.ubuntu.com/community/HighlyAvailableLAMP

David

-----Original Message-----
From:
freeradius-users-bounces+davidp=wirelessconnections.net at lists.freeradius.org
[mailto:freeradius-users-bounces+davidp=wirelessconnections.net at lists.freera
dius.org] On Behalf Of Arran Cudbard-Bell
Sent: Wednesday, May 22, 2013 7:48 PM
To: FreeRadius users mailing list
Subject: Re: MySQL Cluster as back-end for FreeRadius


On 22 May 2013, at 18:11, Alan DeKok <aland at deployingradius.com> wrote:

> Divyesh Raithatha wrote:
>> Has someone successfully configured a high-availability MySQL cluster 
>> as a back-end for FreeRadius?
> 
>  Yes.  There's even a white paper on it from MySQL.
> 
>> Trying to find out what architecture was used to achieve the cluster 
>> or high availabilty and how successful you have been in a Production 
>> Environment.
>> 
>> 1.  Master/Master Replication?
>> 2.  Master/Slave Replication (for DR)?
>> 3.  MySQL Cluster using NDB?
> 
>  It all works.  FreeRADIUS doesn't care what the back-end does.  Just 
> configure MySQL as a database, and it will work.
> 
>> What other backend databases in a high avilable configureation have 
>> been used/tested.
> 
>  Pretty much everything.  Oracle, Postgresql, etc.

IIRC you need to use the cluster client library to get all the advantages of
MySQL cluster, the rlm_sql module doesn't currently support it, but it
should be fairly trivial to write another driver if you're up for the
challenge.

The hardest part would be figuring out the correct build procedure to link
against the C++ library. There have been discussions about that on the list
before.

Arran Cudbard-Bell <a.cudbardb at freeradius.org> FreeRADIUS Development Team

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