<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">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">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">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">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">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">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">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">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>