[Deploying Sakai] Oracle question from DBA

[Matthew Jones]

We have also been running Oracle 11g against Sakai 2.7 at Michigan since
July 2nd, 2011. I would say newer (11G) Oracles are probably more supported
than older Oracles (9i).

There's nothing special stored in the database for Sakai. The goal was to
make it mostly database independent. Some SQL statements are tuned for
better performance depending on the database, and some tools use hibernate
which takes care of database transparency.

You'd probably want to avoid storing Content Blobs in the database just for
performance reasons, since that just adds additional (unnecessary) traffic
and load against the database whenever someone wants to read content. If you
have a small installation it's probably okay, and would make backups easier.

Also all LONG's should be converted to CLOB's in Oracle if you use the
correct Hibernate dialect. If they're not it's pretty easy for a DBA to
switch them, and doesn't cause any problems to the system. This was slightly
documented back in SAK-7977. We don't have any LONG's anymore in our
database.

-Matthew

On Wed, Sep 7, 2011 at 8:49 PM, Colin Tatham <colin.tatham at unimelb.edu.au>wrote:

> Hi
>
> I've been asked a couple of questions regarding our future move from
> commercial hosting to in-house, if anyone has any views please?
>
> * Confirm application support for Oracle 11g R2
> I see quite a few 11g deployments in the Jira deployment details, but the
> database support page in Confluence implies that it's not supported?
>
>
> * Any stored code, stored procedures, triggers?
>
> Also, if we went with an Oracle DB, we'd be migrating from the current
> MySQL
> DB to Oracle. The current configuration is to store blobs in the DB instead
> of the file system, and we'd probably have to continue doing that to avoid
> complication :-(
>
> Thanks
>
> Colin
>
>
> --
> Colin Tatham | Educational Technologist | Learning Environments
>  University Library | The University of Melbourne
> W http://www.trs.unimelb.edu.au
>
>
> _______________________________________________
> 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 --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20111010/7ada2bad/attachment.html