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 <abalas...@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@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 >
__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions * sr-users@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