[OpenSIPS-Users] How SQL_CACHER module works?

[Ben Newlin]

The sql_cacher module doesn’t just read from SQL and store in local memory. It reads from SQL stores into a Cache-style (key-value) datastore. The Cache datastore doesn’t have to be in local memory; it can use any of the cache_db backends supported by OpenSIPS. So you must configure the cache datastore that you want to use.

In your case, and I think most use cases for sql_cacher, you want to store in local memory, so you want to use the cachedb_local [1] module.

[1] https://opensips.org/docs/modules/3.1.x/cachedb_local.html

Ben Newlin

From: Users <users-bounces at lists.opensips.org>
Date: Thursday, November 12, 2020 at 10:53 AM
To: users at lists.opensips.org <users at lists.opensips.org>
Subject: [OpenSIPS-Users] How SQL_CACHER module works?
Hi.
I’m trying to set up an environment where I can fetch data from a local mysql database at startup and have it available for opensips in cached memory.  So far I think the SQL_CACHER module can do this operation.  But I’m getting a little bit confused in the configuration.  So far in the exported parameter “cache_table”  I have:

  *   id
  *   db_url
  *   cachedb_url
  *   table
  *   key
  *   columns
  *   on_demand

In the DB_URL I have the SQL database where I store the date I want to fetch for later use.
But I’m confused with the CACHEDB_URL ?  What’s the idea of this DB?.  I’m getting the data from the DB_URL, but then I have to store it in this CACHEDB???... If so… can I use another table in the same SQL database?.. or I need to use another method?.  Can someone help me understand the whole picture here?.
In case I need to set up this “cachedb_url” what is recommended?... and how to set up?

Thanks in advance!
Best Regards,
Ricardo Martinez.-


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20201112/5b052ab4/attachment.html>