[OpenSIPS-Users] location table in MySQL when using full-sharing-cluster

[Liviu Chircu]

Hi Schneur,

Yes, this is possible.  Unset the "working_mode_preset" and individually 
set the "cluster_mode", "restart_persistency" and "sql_write_mode" so 
you achieve this effect.

Best regards,

Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com

On 05.07.2018 09:43, Schneur Rosenberg wrote:
> Hi I have the working_mode_preset parameter in the usrloc module set
> to full-sharing-cluster, is there anyway to have the location table
> written to the MySQL database too? I need  to pull information from
> the database.
>
> Basically the database should be for informational purposes, the
> restart_persistency should still be sync-from-cluster and the
> sql_write_mode should be write-back.
>
> A nice option would be if It can also be used as a backup for
> restart_persistency if the entire cluster crashes at once.
>
> I assume I can get this done with NoSQL but that would mean that I
> need to rewrite a lot of stuff that was written for MySQL
>
> S. Rosenberg
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users