<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Liran,<br>
<br>
Keep in mind that in the USRLOC module, the primary data storage
is memory, while the DB is just for periodic flushing (write only)
for restart persistence - the only moment when the DB is read is
at startup, when the memory is populated.<br>
So, in order to make multiple opensips to share usrloc content via
DB is to have the DB as primary data storage and this happens
exclusively for DB ONLY mode (where there is no memory 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>
OpenSIPS Bootcamp 2017, Houston, US
<a class="moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2017.html">http://opensips.org/training/OpenSIPS_Bootcamp_2017.html</a>
</pre>
<div class="moz-cite-prefix">On 07/06/2017 02:27 PM, Aknin, Liran
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAOV2HtVwjSf8Lc-Ot3prnhdc3DubXRp1Hg2J0zyCNwDGQu_Mqg@mail.gmail.com">
<div dir="ltr">Thanks again Bogdan, I assumed that what you meant.
<div><br>
</div>
<div>Using SQL, preferably PostgreSQL, is it possible to
implement clustering of some opensips servers, in terms of
shared read-write of userloc?</div>
<div><br>
</div>
<div>Regards,</div>
<div>Liran</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Jul 6, 2017 at 1:35 PM,
Bogdan-Andrei Iancu <span dir="ltr"><<a
href="mailto:bogdan@opensips.org" target="_blank"
moz-do-not-send="true">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Hi Liran,<br>
<br>
yes, typo, it should have been "</tt><tt>there is no
straight way to use an noSQL backends"<br>
<br>
But this is for location. Otherwise, OpenSIPS has a
cachedb_redis module you can use from script as a
key-value cache .<br>
<br>
Regards,<br>
</tt><span class="">
<pre class="m_8118989342806757467moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_8118989342806757467moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank" moz-do-not-send="true">http://www.opensips-solutions.<wbr>com</a>
OpenSIPS Bootcamp 2017, Houston, US
<a class="m_8118989342806757467moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2017.html" target="_blank" moz-do-not-send="true">http://opensips.org/training/<wbr>OpenSIPS_Bootcamp_2017.html</a>
</pre>
</span>
<div>
<div class="h5">
<div class="m_8118989342806757467moz-cite-prefix">On
07/06/2017 08:29 AM, Aknin, Liran wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi Bogdan,
<div><br>
</div>
<div>Thanks for your prompt reply.</div>
<div><br>
</div>
<div>Just to make sure I understood you correctly,
since I was actually asking about Redis - you
mean that there is support for <b>NO-SQL</b>
DB, right?</div>
<div>Is usrloc over Redis going to be introduced
in 2.4?</div>
<div><br>
</div>
<div>thanks,</div>
<div>Liran</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Jul 5, 2017 at
5:53 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a
href="mailto:bogdan@opensips.org"
target="_blank" moz-do-not-send="true">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Hi
Liran,<br>
<br>
Right now, due the complexity of the
usrloc data, there is no straight way to
use an SQL backend (there is a need for
list support with atomic ops). We are
working for such support for 2.4 release.<br>
<br>
Regards,<br>
</tt>
<pre class="m_8118989342806757467m_6574679798821495895moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_8118989342806757467m_6574679798821495895moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank" moz-do-not-send="true">http://www.opensips-solutions.<wbr>com</a>
OpenSIPS Bootcamp 2017, Houston, US
<a class="m_8118989342806757467m_6574679798821495895moz-txt-link-freetext" href="http://opensips.org/training/OpenSIPS_Bootcamp_2017.html" target="_blank" moz-do-not-send="true">http://opensips.org/training/O<wbr>penSIPS_Bootcamp_2017.html</a>
</pre>
<div>
<div class="m_8118989342806757467h5">
<div
class="m_8118989342806757467m_6574679798821495895moz-cite-prefix">On
07/05/2017 04:23 PM, Aknin, Liran via
Users wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="m_8118989342806757467h5">
<div dir="ltr">Hi Bogdan and all,
<div><br>
</div>
<div>We would like to cluster few
opensips servers, in terms of
sharing usrloc data between them.
We already use Redis on these
servers and we want to take
advantage of that, as well as
enjoining faster access comparing
to SQL.<br>
</div>
<div><br>
</div>
<div>Is it possible to use usrloc
module with Redis?</div>
<div>If so, can you please provide
us with an example of defining
usrloc's db_url parameter to do
so?</div>
<div><br>
</div>
<div>Thanks and regards,</div>
<div>Liran</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<fieldset
class="m_8118989342806757467m_6574679798821495895mimeAttachmentHeader"></fieldset>
<br>
</div>
</div>
<pre>______________________________<wbr>_________________
Users mailing list
<a class="m_8118989342806757467m_6574679798821495895moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank" moz-do-not-send="true">Users@lists.opensips.org</a>
<a class="m_8118989342806757467m_6574679798821495895moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank" moz-do-not-send="true">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>