Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are using MySQL for our FreeRADIUS user store and accounting database for our web application.

I would like to separate the accounting portion of the database, move it to a new server to lighten the database reads and rights, among other things.

My first thought was redirecting the accounting portion of the NAS traffic to another server via iptables and storing it in a separate database.

This seems hacky at best, I am worried about the consistency of the accounting stream.

Has anyone come across similar issues before?

Thanks for your time.

share|improve this question
    
What do you mean by redirect NAS traffic? Are the mysql databases stored on the NAS, or what? Why would you need to do some kind of redirection with iptables, why couldn't you just mount another volume? –  Zoredache Feb 29 '12 at 23:10
    
Network Access Servers or Broadband Aggregaters, Cisco 7200s. –  notmyname Mar 1 '12 at 1:37
add comment

1 Answer

I think a load balancer would be the most common tool to help lighten the load, but you may want to look into MySql Proxy.

There are some interesting things you can do with it; however, I would test thoroughly and load test before putting it in production use.

MySql Proxy: http://forge.mysql.com/wiki/MySQL_Proxy

share|improve this answer
    
I will check it out. I would prefer to not put anything between our Authenticating RADIUS and NAS servers for the sake of another single point of failure and added issues, but I may have no other options. Thanks –  notmyname Mar 1 '12 at 1:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.