[Deploying Sakai] Is anybody storing resource bodies in database?

Steve Swinsburg s.swinsburg at lancaster.ac.uk
Wed Apr 22 02:59:54 PDT 2009

Hi Jim,

A production environment I administer stores its content in a  
clustered Oracle database. We have had no production issues with this  
setup and the DB is offsite. It's been around for a while and was  
upgraded from 2.4 to 2.5.x. The conversion from XML to binary took  
place then so we are using BINARY_ENTITY serialization. There is no  
capacity to change this setup, for various reasons.


Steve Swinsburg
Portal Systems Developer
Centre for e-Science
Lancaster University

email: s.swinsburg at lancaster.ac.uk
phone: +44 (0) 1524 594870

On 22 Apr 2009, at 04:45, Jim Eng wrote:

> This is a very important question. It's not an immediate crisis, but
> we may need information in planning for how to help you convert to
> filesystem storage of resource bodies at some point. Here are my
> questions:
> If you think you might be running sakai in production or pilot using
> database storage of resource bodies, please reply to this email.
> Please also tell us what version of sakai you are running.  If you are
> running 2.5 or later, are you using BINARY_ENTITY or XML serialization
> of resources.
> I believe that Sakai out of the box is configured to store resource
> bodies as BLOB's in a database table , I believe, but that is not
> recommended for production.
> If you think you might be using database storage of content bodies in
> pilot or production and you're unsure of how to answer the other
> questions, please reply and we will help figure out what needs to be
> done.
> Jim
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org 
>  with a subject of "unsubscribe"

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2437 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20090422/448188ca/attachment.bin 

More information about the production mailing list