Hi Eric.  I am in the same boat and trying to determine a similar
issue.  I want to use ZEO because of what I can to to perform
maintenance and testing without affecting production sites.  I know it
is not a problem to work with a mount point (separate database) for
each virtual site in a single zope instance (but whether it is
recommended to run a single zeo instance with multiple databases so
each virtual site running under a ZEO client can still use its own
zodb I would like to know more about).  It is imperative for me to
keep each clients' data in its own zodb for a variety of reasons (ie.
backup, portability,  scalability).  I hope there are those with
experience to comment on whether an approach like this is advised
also.  Dieter responded to my message yesterday about it being
possible to run multiple zodb behind a single ZEO but whether or not
it is recommended, I would like to know more about also.


For me, the databases are small but nonetheless I want to keep them
separate (and associated with each virtual site) regardless of whether
they are being managed out of a single ZEO server or Zope instance.  I
would also like to keep this with a single ZEO if possible since a one
to one ZEO server instance to zodb would not be so great on RAM
resources of the server and in my opinion would be like using a cannon
when you may only need a slingshot.


Regards,

David


On Tuesday, September 20, 2005, at 03:36 PM, Eric Wohnlich wrote:


<excerpt><smaller>I'm working on the scalability aspect of Zope, and
am trying to see what the best practices are for creating multiple
databases or multiple Zope instances. I am using ZEO and have allowed
for multiple databases (Data.fs files) by editing zeo.conf just to try
that out, because our current database is getting very large. The way
I understand it, ZEO allows the work load to be distributed among
multiple clients when you are getting a lot of hits, but does not
address the issue of having a very large database for which it may
slow down. So for this you would either create multiple instances of
Zope/ZEO which each have their own database, or you would just create
multiple databases within a single Zope/ZEO instance. Is there what is
considered a best practice as far as choosing one of these options? Is
there a database size I should try to maintain by distributing my
Plone sites among different databases - or maybe just have a separate
database for each? Or perhaps I am way off...

 

Eric

_______________________________________________

Zope maillist  -  Zope@zope.org

http://mail.zope.org/mailman/listinfo/zope

**   No cross posts or HTML encoding!  **

(Related lists - 

 http://mail.zope.org/mailman/listinfo/zope-announce

 http://mail.zope.org/mailman/listinfo/zope-dev )

</smaller></excerpt>