[OpenSIPS-Users] store data locally

[Brett Nemeroff]

Memcache is a great fit for this. Load the data in externally or thru
programmatic cache_miss. This method supports a very high rate per second.
Just be sure to consider failure cases. Caches should never be expected to
be right 100% of the time. They need to be expected and allowed to fail
gracefully.

On Tue, Sep 22, 2020 at 8:36 AM Liviu Chircu <liviu at opensips.org> wrote:

>
>
>
>
>
>
>
>
>
>
> On 22.09.2020 16:09, Alain Bieuzent
>
> wrote:
>
>
>
>
>
>
> I
>
> need to store some data locally but accessible by opensips.
>
>
> the
>
> data is almost 20 records made up of a couple IP: name
>
>
> From
>
> opensips script I want to retrieve the name associated with
>
> the IP (to put in place profiling).
>
>
> how
>
> do you set up this kind of solution without accessing each
>
> call to an external database?
>
>
>
>
> Hi, Alain!
>
>
> One way would be to use the local cacheDB [1] module through the
>
> generic cacheDB scripting functions [2].
>
>
>
>
> Alternatively, if you specifically need to load this data from an
>
> SQL DB, for example, the sql_cacher [3] module would be a perfect
>
> fit.
>
>
> Fun Fact:  if you decide to use any of these two modules, you
>
> will have to buy a guy named Vlad a beer, and they are not the
>
> same Vlad.
>
>
>
>
> Best regards,
>
>
> [1]: https://opensips.org/docs/modules/3.2.x/cachedb_local.html
>
>
> [2]:
>
> https://www.opensips.org/Documentation/Script-CoreFunctions-3-2#toc4
>
>
> [3]: https://opensips.org/docs/modules/3.2.x/sql_cacher.html
>
>
>
>
>
>
> --
>
> Liviu Chircu
>
> www.twitter.com/liviuchircu | www.opensips-solutions.com
>
>
>
>
>
>
>
> _______________________________________________
>
> Users mailing list
>
> Users at lists.opensips.org
>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200922/c4e29061/attachment.html>