[OpenSIPS-Users] Central database

[Bogdan-Andrei Iancu]

Hi Aberto,

It is not a good strategy to blindly share the tables for usrloc or 
dialog between multiple opensips instances, as this will lead to data 
conflicts. Of course, you can have all pointing to the same DB, but one 
table per opensips server.

If you want to aggregate the data (between all opensips instances), 
there is no other way than using the clustering .

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com
OpenSIPS eBootcamp 2021
   https://opensips.org/training/OpenSIPS_eBootcamp_2021/

On 1/16/22 1:47 PM, Alberto wrote:
> Hi,
> I need several opensips servers to save usrloc and dialog to the same 
> central database, not for clustering/ha, but for reporting and billing.
> Is it safe to point multiple usrloc and dialog modules to a central 
> database using the db_url? Or would they cause conflicts?
> Since it's not a cluster where they use the shared information, I 
> would prefer to avoid the complexity of the clusterer module. But I 
> need to know one server won't cancel another server location or dialog.
> Thanks
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20220118/dcaf8f6e/attachment.html>