MySQL Cluster as back-end for FreeRadius
Newbie question. Has someone successfully configured a high-availability MySQL cluster as a back-end for FreeRadius? 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? What other backend databases in a high avilable configureation have been used/tested. Thanks.
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. Alan DeKok.
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
On Thu, May 23, 2013 at 6:48 AM, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
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.
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.
Yeah, in my case I had to write ugly IFs using unlang to detect whether an sql node is down so that FR would go to the next sql node. If this is a dedicated FR-only mysql cluster, a poor-man's workaround would be to have several SQL nodes, with FR running on each node, and have each FR only access its own sql node. -- Fajar
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
participants (5)
-
Alan DeKok -
Arran Cudbard-Bell -
David Peterson -
Divyesh Raithatha -
Fajar A. Nugraha