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

[Mark Breuker]

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"