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

[Schneur Rosenberg]

Thanks liviu, the failover was just something nice to have, I can live
without it, thanks again.

On Thu, Jul 5, 2018, 11:32 AM Liviu Chircu <liviu at opensips.org> wrote:

> 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
>
>
> _______________________________________________
> 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/20180705/e216d2c4/attachment.html>