[Zope] Multiple databases/instances

[David Pratt]

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:

> 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 at 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 )
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 2796 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20050921/f15f8c7a/attachment.bin