Refer to load-balance block in SQL query
Hello List, Apologies if I missed that in documentation. Can something like the below be done in freeRadius: redundant-load-balance rlb { sql1 sql2 } %{rlb:SELECT …'} and also how to tell sqlippool module to use the load balanced sql definition. sqlippool { sql_module_instance = “rlb” } If not then how to execute a SQL query agains an sql instance that may be offline? Regards, Krzysztof
On Oct 27, 2016, at 7:36 AM, Krzysztof Grobelak <krzysztof.grobelak@enet.ie> wrote:
Can something like the below be done in freeRadius:
redundant-load-balance rlb { sql1 sql2 }
%{rlb:SELECT …'}
Yes. See raddb/radiusd.conf. Look for the "instantiate" section.
and also how to tell sqlippool module to use the load balanced sql definition.
sqlippool {
sql_module_instance = “rlb” }
That's impossible, for a host of reasons.
If not then how to execute a SQL query agains an sql instance that may be offline?
You don't. You configure two SQL modules and two sqlippool modules. Then, do fail-over for both: redundant-load-balance { sqlippool1 sqlippool2 } Alan DeKok.
Thanks Alan! All working. Regards, Krzysztof
On 27 Oct 2016, at 13:10, Alan DeKok <aland@deployingradius.com> wrote:
On Oct 27, 2016, at 7:36 AM, Krzysztof Grobelak <krzysztof.grobelak@enet.ie> wrote:
Can something like the below be done in freeRadius:
redundant-load-balance rlb { sql1 sql2 }
%{rlb:SELECT …'}
Yes. See raddb/radiusd.conf. Look for the "instantiate" section.
and also how to tell sqlippool module to use the load balanced sql definition.
sqlippool {
sql_module_instance = “rlb” }
That's impossible, for a host of reasons.
If not then how to execute a SQL query agains an sql instance that may be offline?
You don't. You configure two SQL modules and two sqlippool modules. Then, do fail-over for both:
redundant-load-balance { sqlippool1 sqlippool2 }
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Krzysztof Grobelak