<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi John,<br>
<br>
The cachedb_xxxxx module do implement support for different noSQL
like DBs (local - in opensips memory, mongoDB, memcached, redis,
etc). The sql_cache is new transparent way of caching an SQL table
in OpenSIPS memory (while reading data from an SQL table).<br>
<br>
the cache interface works over the cachedb_xxxxx modules. If you
want to do a share cache (between several opensips instances), use
an external nosql db (like redis, cassandra or mongo) and operate
it from script via the cache API, in a similar way to do it for
the "local" cache.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 13.01.2016 04:43, John Nash wrote:<br>
</div>
<blockquote
cite="mid:CAA4rGPx5j7cbMYM5Lk0RkPSZUdqSYvj-sMku4Nb5n3iySrZ9Ew@mail.gmail.com"
type="cite">
<div dir="ltr">Yes I am also doing that with local cache but I was
confused with sql_cacher and with mongo db also it can be
done?...I was just wondering what are these for?<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Jan 13, 2016 at 1:40 AM, <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:jarrod@unixc.org" target="_blank">jarrod@unixc.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">John,<br>
<br>
I do something similar for caching auth user id and
passwords using cachedb_redis/cachedb_local and db_postgres.<br>
<br>
My basic logic first checks cache (cache_fetch) to see if
the key exists. If it does I will pv_proxy_authorize using
the value stored in the populated avp from the fetch. If
the cache does not exist, I will query Postgres
(avp_db_query) and store (cache_store) the value in cache
with a lifetime so that it will automatically repopulate at
a later time. The only time I may adjust the cache out of
band would be if the user modifies their SIP password
through the portal which causes the system to delete the
stale key/value from the cachedb store.<br>
<br>
This may or may not address your concern, but I hope it
helps.<br>
<br>
Jarrod<br>
<div>
<div class="h5"><br>
> On Jan 12, 2016, at 1:54 PM, John Nash <<a
moz-do-not-send="true"
href="mailto:john.nash778@gmail.com"><a class="moz-txt-link-abbreviated" href="mailto:john.nash778@gmail.com">john.nash778@gmail.com</a></a>>
wrote:<br>
><br>
> I am using local cache db module in order to keep
user id and password in memory and now plan to keep some
other data in memory too and that I want to keep in some
centralized cache.<br>
><br>
> It will be like Opensips1, Opensips2....
<-----> Cache server <---------> Postgresql<br>
><br>
> I also need to periodically update cache (using
some mi commands may be)<br>
><br>
> I saw many of the modules related to cache in
opensips (Like sql_cacher, cachedb_* , DB_CACHEDB) and
I am confused on what should I use for my need and how
these are all related.<br>
><br>
> Any suggestions?<br>
</div>
</div>
> _______________________________________________<br>
> Users mailing list<br>
> <a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>