On Mon, Dec 7, 2009 at 11:00 AM, Alan Runyan <runy...@gmail.com> wrote:
...
> A design pattern for RDBMS is to have 2 pools. READ pool and WRITE pool.
> Often the READ pool comes from some replica and WRITE is to the master.
> I'm unsure this pattern would work for ZODB.  I know Malthe was thinking
> about this but unsure if he had anything concrete.

Would both pools be used by a single process? Or is the assumption that
some applications would have a read-only view of the database and some
have a read-write view.

We've had customers that used read-only replicas.  We've thought of
doing the ourselves, but so far, the benefit hasn't outweighed the hassle
of separating our applications into read-only and read-write instances.

Jim

-- 
Jim Fulton
_______________________________________________
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev

Reply via email to