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

[Liviu Chircu]

Sorry, I didn't fully read your request.  The "restart_persistency" 
parameter is a selector: either A) or B). What you want is something 
like: "perform A). if it fails, fall back to B)".  And this is, indeed, 
not possible as of now.

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

On 05.07.2018 10:30, Liviu Chircu wrote:
> 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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users