[Serusers] SER Reports "out of memory"

Java Rockx javarockx at gmail.com
Mon May 30 15:33:45 CEST 2005


Our current MySQL configuration has two servers in active-active state (ie, 
neither is a master, both are fully active and serving requests). The MySQL 
servers use a Network Appliance for storage.

Regards,
Paul

On 5/30/05, Jiri Kuthan <jiri at iptel.org> wrote:
> 
> At 03:40 AM 5/30/2005, Java Rockx wrote:
> >Currently, usrloc is replicated via t_replicate() using 
> db_mode=writeback.
> >
> >However, our lazy-load patch would obsolete the need for t_replicate() 
> because we have multiple MySQL servers that are active-active so __all__ 
> replication really occurs at the database layer rather than the SIP layer.
> 
> So this is the point which I am still struggling with. I mean generally 
> there is a problem
> of read-write intenstive UsrLoc operations. We can move it from SIP to DB. 
> However, whichever
> layer we choose to solve the problem, it takes careful dimensioning. 
> Otherwise the
> replication mechanism may cause peformance problems.
> 
> What Mysql setup are you exactly using? Cluster? Master/slave replication?
> 
> Otherwise I think that the cache policy "load-on-demand" makes sense.
> 
> -jiri
> 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050530/e07074c5/attachment.htm>


More information about the sr-users mailing list