Thursday, November 12, 2009

FreeRADIUS with MySQL cluster

About:
This is all about deploying FreeRADIUS with MySQL cluster, understand about FreeRADIUS deployment options with MySQL cluster for high availability ease of database management.

Overview:
Few months ago, I was working on FreeRADIUS integration with MySQL cluster to provide a better alternative for high availability and scalability of the data store. The same is available as white paper for some time now, and the white papers are "The deployment of FreeRADIUS with MySQL cluster" and on "Strategy Guide for Building Highly Scalable & Available AAA Services".

Look here for how to configure MySQL cluster, or configure FreeRADIUS with mysql cluster database. Since the integration of FreeRADIUS with MySQL cluster and testing of the same is also carried out, this document highlights some of those areas too.

As well I ported the FreeRADIUS on Solaris 10, as I used Solaris Containers to simulate multiple systems as required. However I used 3 systems running Solaris 10 on it. The same could be used with Linux too, however we have to carefully manage co-location of MySQL clusters SQL node, Management node, and FreeRADIUS application itself.

Since mysql cluster needs minimum of 3 nodes for providing high availability of the data being stored. The stored data on both the nodes is replicated synchronously across the nodes, a third node is used as management node which also offers quorum vote in the event of node failure and also does the management of mysql cluster. This third node could be used to host the application as well as MySQL server. It becomes more easy if we have multiple systems, or multiple OS environments (high level abstraction providing virtual independent system) / solaris containers will ease the job.

When FreeRADIUS receives any request from it's clients either for authentication, authorization or accounting it looks up at it's configured data store option and sends the appropriate request to fetch the data from the data store. Based on the response from the data store FreeRADIUS takes the appropriate step. However since FreeRADIUS works with MySQL, it does lookup on the indexed columns which is very good for mysql cluster, this does not result in the any changes to FreeRADIUS data store mysql module, however there are few changes that are documented in the white paper for configuring the same. Once the request is landed on the mysql cluster either of data node would serve the request via SQL node (MySQL server).

Note: I ported the FreeRADIUS on Solaris, will share the learning of the same in my subsequent post.

Acknowledgment:
I would like to thank Alan Dekok for his help to walk me through the high level architecture and working of the modules and options available with FreeRADIUS.

10 comments:

Anonymous said...

[B]NZBsRus.com[/B]
Skip Idle Downloads With NZB Downloads You Can Instantly Search Movies, PC Games, MP3 Singles, Applications and Download Them @ Flying Rates

[URL=http://www.nzbsrus.com][B]Usenet[/B][/URL]

Anonymous said...

Subject: StartupCity: An event you shouldn't miss!

Hey,

Just wanted to let you know about an exciting event siliconindia is organizing on May 29 & 30, 2010 in Bangalore.

Limited seats. Register FREE: http://www.siliconindia.com/startupcity2010

Roll up your Sleeves. Meet over 100 cool startups. Learn new Technologies; Watch live product demonstrations; Get a peek into cutting edge technologies; Lay hands on the best-of-breed solutions; Meet young, energetic, passionate geeks; Experience the culture of innovation in small companies; Listen to Visionary Keynotes and In-depth Panel Discussions

Come. Meet the Startups that will become tomorrow's industry leaders.

Here's you chance to meet and hear inspiring entrepreneurial story from Krishnakumar Natarajan, co-founder, CEO & MD of Mindtree and Bharat Goenka, Co-Founder & MD of Tally Solutions

Heads of Dell India, Sage India, Mphasis will talk about building next generation technology companies from India.

Founders of startup companies like SMSCountry, 123 Greetings.com, Manthan Systems, Ittiam, Jade Magnet will talk about concept to success and idea to revenue.

You also get to hear interesting discussions on Mistakes entrepreneurs make when approaching VCs and Best Opportunities for Entrepreneurs in 2010, Angel Money and many others from leading venture capitalists like IDG Ventures, Intel Capital, Helion, Clearstone, NEA-IndoUS Ventures.

This is undoubtedly the biggest event for startups.

There are limited seats. You can register yourself for FREE at: http://www.siliconindia.com/startupcity_09/index.html

Thanks,
Varun
varun@siliconindia.com
07760575756

Anonymous said...

www odnolubovniki :(







www odnotrahniki 415982
179 www odnotrahniki com
www odnotrahniki ru 4173

Anonymous said...

36892 Скачать Сумасшедшее сердце !)

Anonymous said...

Online CNA classes
CNA jobs salary
CNA training online

Anonymous said...

top [url=http://www.c-online-casino.co.uk/]casino games[/url] hinder the latest [url=http://www.realcazinoz.com/]free casino[/url] free no set aside hand-out at the chief [url=http://www.baywatchcasino.com/]loosen casino
[/url].

Anonymous said...

Gοod way of ԁеscribіng, anԁ fastidіоus piеcе of writing tο take informаtіоn about my presentatіοn subjеct mаtter, whіch і am going to dеliѵеr in schоol.


My ωеb site; http://www.offersdailyus.com/3-months-half-price-hd-pack-upgrade-at-sky-online-existing-customers/

Anonymous said...

Ιt's remarkable to go to see this web page and reading the views of all friends concerning this post, while I am also eager of getting knowledge.

My web page - cccam server premium

Anonymous said...

[url=http://www.vip1michaelkorsoutlet.org]Michael Kors Outlet[/url] Well, there are still some methods to deal with our pain

[url=http://www.mislouboutinsaleuk.co.uk]Christian Louboutin Outlet[/url]They are waiting for an opportunity to part you from your shoes

[url=http://www.getfreerunaustralia.org]Nike Australia[/url]Payless Shoes is a given as they have stores in just about every city and town

[url=http://www.vipnikenewzealand.info]Cheap Nike Shoes[/url] Finding a great pair of shoes is a great moment in a woman's life

[url=http://www.upnikepascherfr.info]Nike Air Max[/url] Our shoe store is a specialist in making sexy as well as glamorous shoes for women

Anonymous said...

I like your articles. your article must be good and easy understandable .I am working in 24 hour Des Moines Towing .i really impressed to your post. I shared your post in my facebook page. Thanks for sharing this post.

FreeRADIUS with MySQL cluster

About: This is all about deploying FreeRADIUS with MySQL cluster , understand about FreeRADIUS deployment options with MySQL cluster for h...