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 <[email protected]> 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 > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
