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.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
