[ZODB-Dev] ZEO and relstporage performance
Shane Hathaway
shane at hathawaymix.org
Wed Oct 14 14:11:05 EDT 2009
Ross J. Reedstrom wrote:
> For my druthers, I just _trust_ PostgreSQL a lot more: the one MySQL DB
> I have that I use on an on-going basis is my MythTV media-pc. Once a
> month or so I have to repair a table. I've used PostgreSQL in
> professional high load production for years and never had a corruption
> issue: even when running out of disk! (the main culprit in my experience
> w/ MySQL, since that's the default state for a PVR: full!)
I've had similar experiences.
> shared caches: this is the main reason I've been looking at relstore:
> we're running many Zope FEs against one ZOE right now, and due to the
> nature of the load-balancer, we're seeing little gain from the caches.
> I'm looking to fix that issue, to some extent, but sharing across all
> the FEs on one box would be a big win, I'm sure.
I hope so. I must admit that I don't have great confidence in the
probable cache hit rate of the current RelStorage/memcached strategy. I
do have a lot of hope that it can be improved, possibly by adding to
memcached.
Shane
More information about the ZODB-Dev
mailing list