[OpenSIPS-Users] [NEW] Easily cache your SQL data into any OpenSIPS NoSQL module!

[Liviu Chircu]

Hello all,

A new module [1] which allows you to cache an arbitrary number of tables 
from your preferred SQL database into the cache database of your choice 
will be officially released in the upcoming OpenSIPS 2.2 LTS beta.

The module acts as a liaison, periodically transferring data during 
runtime from the SQL database over to the NoSQL one, as it keeps the 
cached information up-to-date. The amount OpenSIPS script code required 
in order to use it is minimal, with only a few module parameters, a 
scripting variable used to access the data and the optional possibility 
of triggering SQL->NoSQL transfers externally, through the MI interface. 
A usage example can be found in the module documentation.

Here is the initial feature set for the new "sql_cacher":
* works with all OpenSIPS-supported SQL and NoSQL backends, including 
the local cache
* two caching modes:
     - "full caching", where the entire SQL table is moved into the 
NoSQL cache (with periodic full refresh)
     - "on demand caching", where OpenSIPS starts faster, and will only 
cache rows as it needs them
* a read-only script variable to access the NoSQL data
* an MI command to trigger full or granular cache refreshes
* customizable data expiry intervals
* customizable number of rows loaded at once when doing "full caching" 
(for resource-constrained systems)

So, the next time someone wants to cache their data into OpenSIPS [2], 
please make sure to warmly instruct them to test out this wonderful 
addition by Vlad-Robert Pătrașcu!

All the best,
OpenSIPS team

[1]: http://www.opensips.org/html/docs/modules/2.2.x/sql_cacher.html
[2]: http://lists.opensips.org/pipermail/users/2016-February/033875.html

-- 
Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com