[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