RE: [Zope3-Users] zodb objects backup

2006-02-28 Thread Shaun Cutts
  It would be very nice if there were a faq or other doc addressing
all of
  these scalability-related questions systematically for someone like
me
  who understands what a relational database is doing for them (in
return
  for squashing all their objects). It seems I'm not the only one with
  these concerns. :)
 
 Welcome to Open Source, we look forward to seeing your newly-written
faq
 as it becomes available online ;-)

Well, I've got enough info to write one by now... only, not having
reviewed or tested the code, I couldn't actually vouch for it.

But seriously, coming to Zope for an app server, I had no idea that ZODB
was as robust as it seems to be. I think, from a marketing standpoint
for the Zope corp (and other in the community deriving sustenance from
providing zope-related products and services), it would make a lot of
sense if they at least made the claim in a prominent place that ZODB was
a serious candidate to replace a RDBMS if you didn't absolutely need
SQL. Collecting the info together could be put on the todo list, but
motivating people to seek it out would be a good first step.

  In the meantime, I had an idea about my current implementation:
maybe
  instead of __getstate__ and __setstate__ I should put the external
data
  in _v_data (marking as volatile). Then I could trap for its
existence,
  and load if necessary; and also have an explicit refresh wired to
a
  button in the GUI.
 
 Yup, this is exactly what _v_ was designed for...
 
Great.

- Shaun


___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


Re: [Zope3-Users] zodb objects backup

2006-02-27 Thread Chris Withers

Shaun Cutts wrote:

So far so good, modulo the replication issue. (We don't have much
funding yet... but if initial launch goes well, we're hopeful :)).


As people have mentioned, you can use repozo to get almost the same 
effect. Either that or do app-level replication ;-)



It would be very nice if there were a faq or other doc addressing all of
these scalability-related questions systematically for someone like me
who understands what a relational database is doing for them (in return
for squashing all their objects). It seems I'm not the only one with
these concerns. :)


Welcome to Open Source, we look forward to seeing your newly-written faq 
as it becomes available online ;-)



In the meantime, I had an idea about my current implementation: maybe
instead of __getstate__ and __setstate__ I should put the external data
in _v_data (marking as volatile). Then I could trap for its existence,
and load if necessary; and also have an explicit refresh wired to a
button in the GUI. 


Yup, this is exactly what _v_ was designed for...

cheers,

Chris

--
Simplistix - Content Management, Zope  Python Consulting
   - http://www.simplistix.co.uk

___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


RE: [Zope3-Users] zodb objects backup

2006-02-26 Thread Shaun Cutts


 From: Tom Dossis [mailto:[EMAIL PROTECTED]
 Shaun Cutts wrote:
  But with replication, this issue is taken care of. (Too bad
replication
  isn't part of the core functionality)
 
 Maybe soon..
http://hathawaymix.org/Software/PGStorage
 
Great!

Another potential issue on the scalability front I had forgotten about
earlier:

How do BTrees perform under lots of concurrent updates? (I know this is
a tricky one, as implementations can get pretty complex to deal with
this.)

I note that 
http://www.zope.org/Wikis/ZODB/FrontPage/guide/node6.html#SECTION0006300
00

Says that As with a Python dictionary or list, you should not mutate a
BTree-based data structure while iterating over it.

Does this apply only to thread-local modifications or to any
modification by anyone else? Ie, are BTrees versioned as the ZODB
is... if I'm iterating over a BTree in my process (in ZEO, say), and
another process modifies the BTree, does that sometimes show up in my
copy, or only after commit?

Also, wrt ConflictError -- is the BTree considered one object, or are
the python objects (buckets, tree structure, ...) treated
separately?

In general, are the BTrees just written naively on top of ZODB, or do
they interact in some special way with the storage?

If they are just sitting on top of ZODB, it would seem that this dims
the possibility that one could use the ZODB as a Postgres replacement.

- Shaun


___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


[Zope3-Users] zodb objects backup

2006-02-25 Thread Alen Stanisic
Hello,

what would be the best way of taking a backup of persistent objects
inside Data.fs with possibility to rebuild it on a fresh Zope 3 install
in case of a disaster recovery lets say.

Thanks
Alen



___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


Re: [Zope3-Users] zodb objects backup

2006-02-25 Thread Andreas Jung



--On 26. Februar 2006 00:04:39 +1100 Alen Stanisic 
[EMAIL PROTECTED] wrote:



Hello,

what would be the best way of taking a backup of persistent objects
inside Data.fs with possibility to rebuild it on a fresh Zope 3 install
in case of a disaster recovery lets say.



Just backup the Data.fs file.

-aj

pgppCQEp73WCn.pgp
Description: PGP signature
___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


Re: [Zope3-Users] zodb objects backup

2006-02-25 Thread Alen Stanisic
On Sat, 2006-02-25 at 07:52 -0600, Andreas Jung wrote:
 
 --On 26. Februar 2006 00:04:39 +1100 Alen Stanisic 
 [EMAIL PROTECTED] wrote:
 
  Hello,
 
  what would be the best way of taking a backup of persistent objects
  inside Data.fs with possibility to rebuild it on a fresh Zope 3 install
  in case of a disaster recovery lets say.
 
 
 Just backup the Data.fs file.
 

For some reason it doesn't feel completely safe just relying on Data.fs.
Maybe I am thinking too much in rdb land and transaction logging where
you could rebuild your db from the logs.

Alen

___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


RE: [Zope3-Users] zodb objects backup

2006-02-25 Thread Shaun Cutts

 On Sat, 2006-02-25 at 08:59 -0600, Andreas Jung wrote:
 
  --On 26. Februar 2006 01:52:29 +1100 Alen Stanisic
  [EMAIL PROTECTED] wrote:
 
  
   For some reason it doesn't feel completely safe just relying on
 Data.fs.
 
  That means what? Why shouln't it be safe...please come up with some
  reasonable arguments..
 
  -aj
 
 
 I did mention that it could be because most rdb systems have a
database
 and also keep transaction logs.  In case of a failure you put the
latest
 backup of the db and transaction logs together and you could rebuild
 your db to the point just before the failure.  If you only had a daily
 back up of your db you could potentially lose a full day of
 transactions.
 
One could also mention failover: if one computer with Data.fs goes down,
you're down, period; whereas many RDBMSes support keeping slave copies
of the database, which are then available.

Also, there are ACID transactions (see
http://en.wikipedia.org/wiki/ACID) in a good RDBMS. I don't know how
zodb ensures consistency if there are multiple concurrent users, and can
we rollback gracefully?




___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


Re: [Zope3-Users] zodb objects backup

2006-02-25 Thread Gary Poster

Alen, please see

http://www.zope.org/Wikis/ZODB/FileStorageBackup

Shaun, many of the other questions in this thread--and others  
recently--are answered in this guide:


http://www.zope.org/Wikis/ZODB/FrontPage/guide/index.html

It is highly recommended reading if you are doing serious Zope 3 apps.

Both of these are found in the ZODB wiki, which has some other  
helpful docs:


http://www.zope.org/Wikis/ZODB/FrontPage

Gary
___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users


Re: [Zope3-Users] zodb objects backup

2006-02-25 Thread Alen Stanisic
Thanks Gary.

On Sat, 2006-02-25 at 15:39 -0500, Gary Poster wrote:
 Alen, please see
 
 http://www.zope.org/Wikis/ZODB/FileStorageBackup
 
 Shaun, many of the other questions in this thread--and others  
 recently--are answered in this guide:
 
 http://www.zope.org/Wikis/ZODB/FrontPage/guide/index.html
 
 It is highly recommended reading if you are doing serious Zope 3 apps.
 
 Both of these are found in the ZODB wiki, which has some other  
 helpful docs:
 
 http://www.zope.org/Wikis/ZODB/FrontPage
 
 Gary

___
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users