[sr-dev] usrloc and db only mode

[Victor Seva]

On 02/25/2015 12:38 PM, Daniel-Constantin Mierla wrote:
[snip]
> The solutions that came in my mind for now:
> 
> - for 1) -- add the server_id as a new column in the location table. It
> was pointed to be that ser location had it. This will turn a query
> matching on many socket-representation strings to one expression done on
> an integer. The value for server_id can be set via the core parameter
> with the same name.

way better than my approach of building the string for the query from
get_sock_info_list(proto)

> - for 2) -- add a new column 'keepalive' to be set internally by the
> module to 1 if any of the flags for sending keepalive was set. Then the
> query to fetch it will just use a match on it, rather that bitwise
> operations in the match expression. Furthermore, this can be set to a
> different value when enabling the keepalive partitioning (ie., sending
> keepalives from different timer processes, each doing for a part of
> natted users) - right now, for the db only mode, the selection is done
> by column id % (number of keepalive processes).

really nice idea

Cheers,
Victor

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20150225/55238d26/attachment.sig>