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

[Steve Swinsburg]

Hi Mark,

Yes, at present the only issue is if you want to convert your binaries  
from DB to filesystem and have already completed the XML- 
 >BINARY_ENTITY conversion which should happen between 2.4 and 2.5 and  
is the default for new installs of 2.5+

There are Jira tickets to address this as SAK-16146 for 2.5 and  
KNL-165 for 2.6+


cheers,
Steve

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

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







On 23 Apr 2009, at 17:21, Mark Breuker wrote:

> Hi all,
>
> We also store the binaries in the DB (Oracle 10g). This was the  
> recommended approach by Oracle. Currently we run Sakai 2.4 but we  
> will switch to 2.5 this month.
>
> Do I understand correctly that there's only a problem should we  
> decide to switch to storing the binaries on the file system?
>
> - Mark
>
> -----Oorspronkelijk bericht-----
> Van: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org 
> ] Namens Alex Ballesté
> Verzonden: donderdag 23 april 2009 16:48
> CC: Sakai-Dev Developers
> Onderwerp: Re: [Building Sakai] Is anybody storing resource bodies  
> in database?
>
> Hi,
> In University of Lleida, the content body is stored in DB. We believed
> that it was a good strategy to centralize the data  in unique point
> (simplify backups, etc.. ) because we don't have a lot of data.. Now,
> after read your mail I see that we should have a bad idea.
> We are using an Oracle 10g and we are running a sakai 2.5.3 in
> production. We migrated last december. Also we run script to convert
> content to BINARY_ENTITY style. We only have arround 60 Gb of data in
> content.
>
> What do you recomend?
>
> Thanks.
>
> Jim Eng escribió:
>> 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
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org 
>>  with a subject of "unsubscribe"
>>
>
>
> -- 
> Alexandre Ballesté Crevillén	alex at asic.udl.cat
> ===================================================
> Àrea de sistemes  d'Informació i Comunicacions
> Universitat de Lleida
>                                                                                                                            Information 
>  and Communications Systems Service
> University of Lleida
>                                                                                                                            Pça 
> . Víctor Siurana,1   25003 Lleida
> Tlfn: 34 973 702148
> ===================================================
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org 
>  with a subject of "unsubscribe"
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-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/sakai-dev/attachments/20090423/149f5ab9/attachment.bin