[SR-Users] usrloc + multimaster replication

[Peter Dunkley]

Hi,

The timer to delete records only runs if the timer_interval modparam is > 0.

This means you can have multiple active registrars off the same database 
table and use some external process to manage deletion of records (for 
example, a stored procedure triggered from a cron job).

Regards,

Peter



On 08/04/13 09:52, Alex Balashov wrote:
> I know I'm revisiting a problem that has been discussed in multiple 
> threads from various angles, so I might be rightly accused of laziness 
> in neglecting to research them all.  All the same:
>
> I have proxy1 and proxy2 writing to database A and database B, 
> respectively.  Database A and database B are active-active masters, 
> synchronised via some replication system attached to the underlying DB 
> technology.
>
> The 'location' table is also replicated this way. We know that 
> 'usrloc' doesn't work so well with this: one instance of Kamailio will 
> periodically delete the other's contacts, even if they have a nonlocal 
> SIP domain.
>
> Is there any db_mode that can be used (other than 0/purely in-memory) 
> to make this work right?  Or is that the essential problem that 
> p_usrloc is written to solve?
>
> Thanks,
>
> -- Alex
>