[SR-Users] Interactions of dmq_usrloc and usrloc w/db_mode > 0

[Matteo Brancaleoni]

Well,

I asked a similar question here
https://lists.kamailio.org/pipermail/sr-users/2022-July/115160.html but no
answer yet :)

What I see on my side is that it indeed works, the only drawback is that
the same contact is getting synced to DB, which causes a duplicate error
unless you use the "db_insert_update" option.

Done that seems that it works ok (did tested in prod yet), and I had the
all the contacts live on all nodes and on db. The only downside that maybe
can happen is that the periodic sync may skew a bit the expire time and
maybe give a contact some more seconds, but it really depends on timings of
the clusters.

But I'm really interested in the answer, too :)

-- Matteo


On Mon, Sep 26, 2022 at 4:07 PM Alex Balashov <abalashov at evaristesys.com>
wrote:

> Hi,
>
> Are there any known contraindications for replicating contacts using
> dmq/dmq_usrloc, and injecting those contacts into a database on one of the
> nodes using usrloc with `db_mode` 1 or 2?
>
> Predictably, this is being done to support the use-case of getting
> registration status from database. If you think this should be done with
> JSONRPC, I am in complete agreement with you, but it’s not up to me. :-)
>
> I am doing this with `db_mode` 2 now, and finding that, for a small number
> of AORs, one can find instances where they are consistently stored in
> memory but not present in the `location` table. The overall proportion of
> these AORs, out of thousands, seems to be quite small. It was initially
> somewhat higher, and it went down once I increased usrloc `timer_processes`
> and increased the sync interval from 30 to 60 seconds.
>
> Nevertheless, it is still non-zero, and I am getting intermittent reports.
> I wonder if there are some prior experiences with this and anything to
> watch out, or if `db_mode` 1 might be a superior choice. I personally
> cannot see how that would be; it seems to have all the performance
> downsides of mode 3. But perhaps if something about it is more
> “problem-free” vis-a-vis DMQ, it’s worth a shot?
>
> — Alex
>
> --
> Alex Balashov | Principal | Evariste Systems LLC
>
> Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
>
>
> __________________________________________________________
> Kamailio - Users Mailing List - Non Commercial Discussions
>   * sr-users at lists.kamailio.org
> Important: keep the mailing list in the recipients, do not reply only to
> the sender!
> Edit mailing list options or unsubscribe:
>   * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20220926/13d53d7c/attachment.htm>