[sr-dev] usrloc concurrency

[Alex Balashov]

Does anyone know of any issues running usrloc with DB backing 
('location') in a multi-master DB-replicated environment?  I am 
referring to plain usrloc, not p_usrloc.

I have such an environment set up with db_mode = 1 (immediate 
write-through) and have run into a problem where Kamailio occasionally 
stops writing to the location table for no apparent reason.  I am 
wondering if this is because another Kamailio instance bound to the 
secondary replica is performing a DB sync as well, and at some point 
they collide in some sort of race condition.   Would db_mode 2 fix? 
Would anything fix?  Is this even the problem?

-- 
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/