Using different MySQL server with freeradius 3.x ?

[Fajar A. Nugraha]

On Tue, Feb 27, 2018 at 9:43 AM,  <philippe2.legoff at 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