3.8.14. AsynchronousSQL Previous topic Parent topic Child topic Next topic

This optional flag parameter tells radiusd to use asynchronous SQL queries. This flag is not set by default and the queries are synchronous which means no processing is done before the reply, or timeout, is received from the SQL database. With asynchronous queries, radiusd can do other processing while the query is being processed by the database. When the the database result is ready, radiusd continues from the point where the asynchronous query was started.
Starting with Radiator 4.18, asynchronous queries are supported with MySQL, MariaDB and PostgreSQL. Testing was mainly done with DBD::mysql 4.035 with MariaDB 10.1.13.
Note
Asynchronous SQL queries were introduced with Radiator 4.18, and as of Radiator 4.19, are only supported by AddressAllocator SQL clause.
Here is an example of AsynchronousSQL and the parameters typically used with it:
# See goodies/addressallocator.cfg for full example
# Run address allocator in asynchronous mode
<AddressAllocator SQL>
    # Other parameters
    AsynchronousSQL
    AsynchronousSQLConnections 10
    ConnectSQLAtStartup
    RoundRobinQueries
</AddressAllocator>