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@lists.freeradius.org [mailto:freeradius-users-bounces+davidp=wirelessconnections.net@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@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@freeradius.org> FreeRADIUS Development Team - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html