[Zope] Zope's scalability across multiple web servers

[J. Atwood]

I am using PostGreSQL 6.5.3 which I am really enjoying. It is very stable,
pretty fast, has tons of features and above all, open source (7.0 which is
to come out in a month has a slew more). Most of the data for the site is
coming from the database (ZODB = 1.1 MB) and by playing with Zope's SQL
Method caching I am really able to customize each and every SQL statement as
to how much to cache and for how long. This really improves performance as
cached material is said to be about 10x faster (not my tests).

I have done some testing and on my server (RH 6.1, 300Mhz, 256 RAM) I think
I can handle roughly 1,000,000 a day so should be ok for a bit. :)

I have read everything I can get my hands on about ZEO but am still unclear
about a few details like setup, management and the nuts and bolts of having
one ZODB over many servers.

All in good time.

J



> From: "Jason Spisak" <444@hiretechs.com>

>> There are also huge issues in terms of keeping multiple SQL databases synced
>> up so there is a case to be made to spread ZEO across many webservers with
>> one beefy DB server in the background serving them. That, combined with
>> Zope's ability to cache creates a highly scalable solution (IMHO).
>> 
>> I, personally, am just salivating at the chance to get my hands on ZEO.
> 
> I too am waiting with my dinner napkin, knife and fork.  Right now I have a
> 300MB ZODB and not having to deal with the overhead of a RDBMS (and the
> headaches everyone is having on the list) is very conforting.  What DB are
> you using?