[SR-Users] db_cluster together with the registrar module = signal 11

Øyvind Kolbu oyvind.kolbu at usit.uio.no
Wed Aug 29 21:15:45 CEST 2012


On 2012-08-29 at 20:16, Daniel-Constantin Mierla wrote:
> is usrloc module configured in db only mode?

Yes, db_mode is 3.

> Read operation cannot be done in 'parallel' fashion of the cluster, it 
> is only serial or round robin, stopping at first successful query (even 
> when there is no data records in the result of the query).

Not related to this thread, but would it be possible to force it to try
until data is found?

> If usrloc keeps also the records in memory, there is no select done at 
> runtime, only updates, which are write operations.
> 
> db_check_update is only for SQL UPDATE command, in MySQL you can see the 
> number of affected rows and if it is 0, then the module does an insert 
> (another write operation).

I use Postgres, which as also returns the number of affected rows. Though
perhaps Kamailio doesn't support it for Postgres.



More information about the sr-users mailing list