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.