[Zope] Hardware for Zope + ZEO

[Wankyu Choi]

On Wed, Jan 29, 2003 at 03:32:20PM +0900, Wankyu Choi wrote:
> I've been thinking:
>=20
> 1. Take out as much binary data as possible via External File ( my=20
> version, not the ones found in Zope products page ).

>>i can understand doing this if you're running FileStorage and want to
avoid a single bloated Data.fs file, but since you're leaning towards
DirectoryStorage, I think there's no reason to use ExternalFile at all - =
it
just complicates things.

Hm.. your reply pretty much convinces me^^

Now I'll be trying DirectoryStorage in earnest.

> 2. Store textual data  ( raw data + its rendered version, etc ) in=20
> MySQL.

>> ditto

Why shouldn't I let DirectoryStorage also take care of this? Toby =
Dickenson
seems to prefer putting everything into the storage.

( I need to keep searchable textual data in MySQL tables anyway since =
Zope's
catalog engine is a pie in the sky for me: Korean simply doesn't work =
since
there's no reliable Korean splitter; will have to rely on old '%word%'
select tricks. :(

> 3. User data goes into MySQL.

>> ditto

Again why? In fact, I want to keep the existing user data where they are =
but
am just curious what I would be missing if I didn't^^
=20
> once but that seemed a lot of hassle, so I decided to wait for other=20
> solutions like the Directory Storage.

>> Wait no longer. ;)

Okay, but is there anything I should be aware of before deciding on the
directory storage as my storage of choice? The data will be both read- =
and
write-intensive.
=20
> If most Zope users ( including yourself ) feel Filestorage is not a=20
> solution for more than 20GB of data,

>>hell, I don't like it for 2 GB of data.
>>(see recent thread "POSKeyError II: Dead by Dawn" ... I wasn't kidding
when I titled it that!)

Yeah, that POSKeyError thing scares the hell out of me ;-)

>>Anonther solution that hasn't been mentioned in this thread: multiple
mounted storages. Never done this, but I understand zope.org does it =
(one
storage for wikis, another for everything else).
http://www.zope.org/Members/jim/ZODB/MountedDatabases

Can I mix it with the DirectoryStorage?=20

>>Shane's DBTab allows you to mix-and-match storages, running several at
once. http://www.my-zope.org/exp/20030116101458
http://hathaway.freezope.org/Software/DBTab


I tried Shane's AdaptableStorage with DBTab. Works with stock Zope and =
CMF.
Doesn't work with Plone. Will have to wait for it to stabilize a bit =
more.

Thanks for your comments.

Cheers,
Wankyu Choi
---------------------------------------------------------------
      To the dedicated staff at NeoQuest, language is not a problem
          to be dealt with, but an art waiting to be performed.
  ---------------------------------------------------------------
  Wankyou Choi
  CEO/President
  NeoQuest Communications, Inc.
  3rd Floor, HMC Bldg., 730-14, Yoksam-dong, Kangnam-gu
  Seoul, Korea
  Tel: 82-2 - 501 - 7124 Fax: 82-2-501-7058
  Corporate Home: http://www.neoqst.com
  Personal  Home: http://www.zoper.net, http://www.neoboard.net
  e-mail:   wankyu@neoqst.com
--------------------------------------------------------------- =20