[Zope-dev] R: DBTab and CMF

[Fabio Paracchini]

Shane,
	I tried your suggestion and it worked seamlessly also on BDBStorage,
you
only have to copy the whole BDB directory and rename it.

Thanks once again
Fabio

-----Messaggio originale-----
Da: Shane Hathaway
Inviato: mercoledi 5 marzo 2003 22.29
A: Fabio Paracchini
Cc: zope-dev@zope.org
Oggetto: Re: DBTab and CMF


Fabio Paracchini wrote:
> Hi Shane,
> 	I was able to successfully install and use DBTab & BDBStorage, and
> to
> migrate a legacy archive of about 20Gb of Office documents.
>
> Now I run in this situation: I'd like to partition those archives, so that
> everything is not in a single giant DB, but is split among several smaller
> DBs.
>
> DBTab works perfectly if you have a 'standard' Zope environment, i.e. if
you
> have Mountpoints/Folders.
>
> I was not able to mount a different storage beneath a CMF Folder, it seems
> that inside DBTab's code a mount point is derived from Folder, and that is
> not shown in a CMF/Plone site.
>
> Do you have any clues about using DBTab's mount points in a CMF/Plone site
?

Tres and I stumbled upon the right way to do this yesterday: you make a
copy of your database first, then in the primary database you delete the
items you want to load from the secondary database and replace them with
mount points.

A concrete example: Let's say for a moment that you have one big Data.fs
and you want to move the folder at /Site/Documents to its own database.
  First make a copy of Data.fs called "Documents.fs".  Set up dbtab.conf
to open both databases and mount /Site/Documents from Documents.fs.

When you restart Zope, initially nothing will have changed--the
documents are still in the main database.  Visit the folder at /Site and
delete the Documents object.  (If you have sufficient backups, this
shouldn't make your heart race. ;-) )  Now add the DBTab mount point.
/Site/Documents will come back, this time loading from Documents.fs.
Rather than a Folder, the object at /Site/Documents will be whatever
kind of object it used to be, whether it was a CMF PortalFolder or a
Zazzywag Kanuliputz.  Everything will work like it did before--you don't
even need to restart a second time.

You'll want to use DBTab 1.1, BTW--I think it solves all the former
strange bugs, and it's significantly faster.

You'll have to adapt for BDBStorage.

> BTW is there a better way to ask you those questions, instead of mailing
you
> directly, and also make you and the Zope community happier ?

I CC'ed zope-dev@zope.org.

Shane



- Disclaimer -
This email and any attachments thereto may contain information which is
confidential and/or protected by intellectual property rights and are
intended for the sole use of the recipient(s) named above. Any use of the
information contained herein (including, but not limited to, total or
partial reproduction, communication or distribution in any form) or the
taking of any action in reliance on the contents, by persons other than the
designated recipient(s) is strictly prohibited.

If you have received this email in error, please notify the sender either by
telephone or by email and delete the material from any computer.

Thank you for your cooperation.