On Tue, Feb 27, 2018 at 9:43 AM, <philippe2.legoff@orange.com> wrote:
Hello,
With Freeradius 3.0.16, I store accountings in a MySQL 5.7 database. Authorize_checks and replies are also using this db. As I receive more than 3000 accountings/sec, I search a way to reduce the load on the db.
There are ways to handle that. My question, however, are those accounting requests absolutely necessary? Are you perhaps setting interim update time too low?
1/ Does it possible to use different MySQL servers to store accountings depending on the Framed-IP-Address ? As an example, could I have this logic with FR : If Framed-IP-Address starts with “10” Then use the MySQL1 server and store accounting on it, If Framed-IP-Address starts with “171” then use the MySQL2 server and store accounting on it Etc..
Try http://freeradius.org/radiusd/man/unlang.html You should be able to configure several instances on sql module, and call the appropriate one based on criteria of your choice (e.g. Framed-IP-Address) -- Fajar