[OpenSIPS-Users] suggested sql database structure

[Bogdan-Andrei Iancu]

Hi Marcin,

Maybe you should consider different approaches for the tables you need 
as Read-Only mode versus the tables needing write access. Or just go for 
cluster DB solution, like percona or galera.

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com
OpenSIPS eBootcamp 23rd May - 3rd June 2022
   https://opensips.org/training/OpenSIPS_eBootcamp_2022/

On 3/6/22 6:20 PM, Marcin Groszek wrote:
>     I would like to deploy opensips in multiple geographical locations 
> and wondering if anyone has any suggestions on sql database structure.
>
> dialog would be local to each instant/pop
> dr_* tables are read only with possibility of dr_gateways probing
> permissions read only
> acc write only
> avpops read/write.
>
> Ideally I would like to see individual pops continue to operate even 
> if routing to other locations is interrupted.
> should I use a single centralized database , or perhaps a 
> master/master cluster over public internet; testing of it was not very 
> successful.
>
> Any suggestions would be appreciated.
>
>