MySQL Cluster as back-end for FreeRadius

[Arran Cudbard-Bell]

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