Re: [ZODB-Dev] Version of mysql to use with Relstorage

2009-03-31 Thread Shane Hathaway
Anthony Gerrard wrote:
> The Relstorage pypi site recommends against using version 5.1.23 of
> MySQL because of "major bugs".  As it doesn't state explicitly what
> these bugs are I can't tell whether they're fixed in the latest
> version (5.1.32).  Does anyone know whether it's safe to use this
> latest version of MySQL 5.1 with relstorage or whether I should be
> using the latest 5.0 version (5.0.77).

I still recommend 5.0 over 5.1.  MySQL 5.1 is less stable.

Shane
___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev


Re: [ZODB-Dev] difference between RAM and cache in ZODB

2009-03-31 Thread Paul Winkler
On Tue, Mar 31, 2009 at 09:29:07AM +0100, Chris Bainbridge wrote:
> 2009/3/31 Sandra 
> >
> > For example, my computer have 1 GB RAM, could i have 2 GB objects loaded in 
> > ZODB memory? I don´t well understand what is the cache in ZODB compared to 
> > the RAM.
> 
> A ZODB client has an in-memory cache in RAM, and an optional on-disk
> cache.

Note that the latter only applies when using ZEO.

-- 

Paul Winkler
http://www.slinkp.com
___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev


Re: [ZODB-Dev] Relstorage and ZEO

2009-03-31 Thread Shane Hathaway
Anthony Gerrard wrote:
> OK thanks.  To confirm you can have a cluster of Zope instances all
> using relstorage to connect to the same database.  This negates the
> need for ZEO as the database handles the multi-threaded data access.

Yes.  Nice ASCII art. :-)

Shane

___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev


[ZODB-Dev] Version of mysql to use with Relstorage

2009-03-31 Thread Anthony Gerrard
Hi,

The Relstorage pypi site recommends against using version 5.1.23 of MySQL 
because of "major bugs".  As it doesn't state explicitly what these bugs are I 
can't tell whether they're fixed in the latest version (5.1.32).  Does anyone 
know whether it's safe to use this latest version of MySQL 5.1 with relstorage 
or whether I should be using the latest 5.0 version (5.0.77).

thanks in advance

Anthony

___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev


Re: [ZODB-Dev] Relstorage and ZEO

2009-03-31 Thread Anthony Gerrard
OK thanks.  To confirm you can have a cluster of Zope instances all using 
relstorage to connect to the same database.  This negates the need for ZEO as 
the database handles the multi-threaded data access.

+-+   +-+
|Zope Server 1|   |Zope Server 2|
+-+   +-+
| Relstorage  |   | Relstorage  |
+-+   +-+
   `-..-'
  `.  _.-'
`-..-'
  ++
  |Database|
  ++


Shane Hathaway wrote:
> Alan Runyan wrote:
>> Ask this question on either Zope/Plone mailing list.
>>
>> My understanding about relstorage is that each Zope application client
>> uses relstorage.
>> There is no ZEO server in the mix.
>>
>> Is that correct Shane/others?
> 
> Yes.  ZEO is not needed when you use RelStorage.
> 
> Shane
> 
> 
___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev


Re: [ZODB-Dev] difference between RAM and cache in ZODB

2009-03-31 Thread Chris Bainbridge
2009/3/31 Sandra 
>
> For example, my computer have 1 GB RAM, could i have 2 GB objects loaded in 
> ZODB memory? I don´t well understand what is the cache in ZODB compared to 
> the RAM.

A ZODB client has an in-memory cache in RAM, and an optional on-disk
cache. The server stores lots of objects. When the client needs one of
these objects it connects to the server, sends the object ID, and the
server sends the object. The ZODB client will cache this downloaded
object in RAM so that operations on it are faster. However, RAM size
is limited, so when there are many objects the cache gets full, and
old objects have to be removed - if the removed objects are needed
again in the future, they must be re-downloaded from the ZODB server.
If the ZODB client file cache is enabled, then a copy of all the
downloaded objects is kept in a file on the local hard disk of the
client. Since hard disk capacity is greater than RAM this provides a
storage space for a much greater number of objects - accessing the
file cache is slower than RAM, but (usually) faster than retrieving an
object from the ZODB server.

ZODB caching is done at the application level, but you're operating
system will also be managing its own hard disk cache; caching in ZODB
and caching in the operating system have a similar function, but are
completely separate, so try not to confuse them.
___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev


Re: [ZODB-Dev] difference between RAM and cache in ZODB

2009-03-31 Thread Sandra
For example, my computer have 1 GB RAM, could i have 2 GB objects loaded in 
ZODB memory? I don´t well understand what is the cache in ZODB compared to the 
RAM.
don´t De: Andreas Jung 
Objet: Re: [ZODB-Dev] difference between RAM and cache in ZODB
À: elsand...@yahoo.fr
Cc: zodb-dev@zope.org
Date: Lundi 30 Mars 2009, 23h52

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 30.03.2009 12:10 Uhr, Sandra wrote:
> Hello!
> Could someone please tell me the difference between the RAM and the
> Cache of ZODB?

This question does not make sense to me. What do you want to know in detail?

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAknRPw4ACgkQCJIWIbr9KYwt+wCbBc3bS3t2kY2mC9rZrlGKZBu6
9CUAn2daFCQ5DGefTG894/zSuacMYvpt
=I5Ah
-END PGP SIGNATURE-



  ___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev