[Building Sakai] Experience with Oracle RAC

[Jon Gorrono]

Did you say Oracle RAC? Slowly I turned... step by step....
(http://www.youtube.com/watch?v=9pQii1L8fGk)

We have some cool headed doc's about our experiences with rac in out
confluence, which I can dig out if you would like the details.

In contrast I can give you a sense of our experience with RAC: it was
not good. There were to issues that bubbled to the top of the heap and
lingered long enough for us to decide to give ip on the RAC

1). a) the RAC insists on managing segment fragmentation and b) it sux at it
 - we would setup our tables views and mviews and a bunch of nicely
performing indexes and the RAC would split up the table and index
segments until the performance tanked. And we coul dnot turn it off
even though it appeared that we had declaratively
2) There was a lot of speculation that the number of small tables used
in sakai for simple low data lookups would harm performance in a RAC
environment due to the added overhead for synch'ing those tables over
the RAC private network... but we never tested this: #1 killed the
project.

On Tue, Oct 6, 2009 at 11:12 AM, Mame-Awa Diop <mame-awa.diop at hec.ca> wrote:
> Hello everybody,
>
> I was wondering if you guys using Oracle as a database for Sakai and using a
> clustering tool like Oracle RAC has had any special behavior with the
> clustering tool ? Is there something worth monitoring with the clustering
> tool ?
> If you use another clustering tool, your input would be appreciated also.
>
>
> Cheers,
>
> --
>
> Mame Awa Diop
> Analyste programmeur
> Service de gestion des technologies et de l'information
> HEC Montréal
> 3000, chemin de la côte-Sainte-Catherine
> Montréal  (Québec)   H3T 2A7
>
> GTI: 514.340.6000 #2029 - Bureau 3.755
> Projet OpenSyllabus: 514.340.6776 - Bureau 4.521
> 5255, avenue Decelles
> Montréal (Québec) Canada
> H3T 2B
>
> Télécopieur: (514)340-5637
>
> _______________________________________________
> 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"
>



-- 
Jon Gorrono
PGP Key: 0x5434509D -
http{pgp.mit.edu:11371/pks/lookup?search=0x5434509D&op=index}
Thawte Notary - https{www.thawte.com/cgi/personal/wot/directory.exe?node=312}
GSWoT Introducer - {GSWoT:US75 5434509D Jon P. Gorrono <jpgorrono - gswot.org>}
http{ats.ucdavis.edu}

Sent from Davis, CA, United States