[Deploying Sakai] Oracle question from DBA
colin.tatham at unimelb.edu.au
Sun Oct 9 15:45:21 PDT 2011
Thanks, that's useful to know!
We've decided to use MySQL initially, mainly due to shortage of time, but
there's a possibility that we could move over to Oracle at a later stage, as
there's proper support in-house for Oracle rather than MySQL.
On 8/10/11 8:40 AM, Dario P wrote:
> 1) We have been working with Oracle 11g r2, since aug/2011, no problems
> at all so far.
> 2) Blobs are stored in long type columns in Oracle. That won't make your
> dba happy precisely... Long columns are deprecated in Oracle since ages.
> Use file system approach.
> You could use the posix file system that Oracle 11g r2 has
> ( http://www.oracle-base.com/articles/11g/DBFS_11gR2.php ) in order to
> simplify your backups , but I did not test it myself, and do not know
> anything performance, stability and compatibility.
> (sorry for my english)
> -----Mensaje original-----
> De: Colin Tatham <colin.tatham at unimelb.edu.au>
> Para: production <production at collab.sakaiproject.org>
> Asunto: [Deploying Sakai] Oracle question from DBA
> Fecha: Thu, 8 Sep 2011 00:49:37 +0000
> 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 :-(
Colin Tatham | Educational Technologist | Learning Environments
University Library | The University of Melbourne
More information about the production