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
_______________________________________________
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
