[Users] usrloc, presence etc. cleanup rate: OpenSER mysql backend

[Henning Westerholt]

On Monday 16 April 2007 11:32, Bogdan-Andrei Iancu wrote:
> Hi,
>
> In mode 2, the DB is periodically updated from mem. cache - what is
> removed from mem, is removed from DB also.
> At startup, the DB is cleaned of old, expired elements.
>
> If you use this db_mode, you should not operate directly on DB, but only
> via the mem cache (MI functions) to avoid de-synchronization. Even if
> this happens, after a restart, everything will be cleaned.

This works for small installations, but not if you have an installation with 
several millions customers and process 700 millions call minutes per month..

Here do you want the smallest downtime as possible, it is not feasible to 
simple restart openser. The cleanup on startup would probably need also 
several minutes.

But i don't know what your load requirements are.

Cheers,

Henning