Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  • Indiana Running VMWare
  • Cambridge Running Xen

...

Database Requirements

  • NOTES:
    • Consider versioning schemas, e.g. cm_test_2_4_x_1, cm_test_2_4_x_2, ...

      Schema Names

      New Schema Names

      Current Machine

      Proposed Machine

      Comments

      sakai

      smartsite_prod

      hammer, steele

      no change

      Production

      sakai_external

      cm_prod

      hammer, steele

      no change

      Production

      sakai

      smartsite_test

      RAC-TEST

      Luigi

      Smartsite-Test (2.4.x), should be called QA

      sakai_external

      cm_test

      RAC-TEST

      Luigi

      Smartsite-Test, should be called QA

      sakai

      sakai_dev_1

      bricker:devel

      bricker

      Development environment, host sakai OOTB for schema upgrade diffs

      N/A

      Sakai_dev_2

      ?

      bricker

      Extra space for internal database only.

      N/A

      Sakai_dev_3

      ?

      bricker

      Extra space for internal database only.

      sakai_external

      cm_dev

      bricker:devel

      bricker

      Development environment, host sakai OOTB for schema upgrade diffs

      sakai_diff

      N/A sakai_diff

      RAC-TEST

      Luigi

      used during major upgrades : 2-4-x --> 2-5-x

      *sakai_ng

      N/A sakai_ng

      RAC-TEST

      Luigi

      QA smartsite-test 2-5-x.  Use Mario as the app server.

      N/A

      sakai_beta

      bricker:devel

      Luigi

      Need new schema since we use bricker:devel

      N/A

      smartsite_beta

      ?

      Luigi

      provided with Banner data but for users to play with

       

       

       

       

      N/A

      sakai_contrib

      ?

      Luigi

      The evaluation of an OOTB contrib Sakai tool.

      N/A

      smartsite_contrib

      ?

      Luigi

      The evaluation of the Course Evaluation tool, SCORM and other Sakai tools that are adapted to our local environment.

      N/A

      smartsite_staging

      ?

      Luigi

      Stage ongoing production updates (TAGS)

       

       

       

        N/A

      smartsite_fallback

      prod

      Not required. 
      Steel is hot spare

      Use during database modifications during maintenance upgrades.

*Highest priority

Hardware suggestions:

  1. Use Luigi as a database server for all of the above schemas, internal and external.
  2. Use Caje for for smartsite-test application node.
  3. Use Saunder for smartsite-test application node.
  4. Use Littlejohn a third application server in the smartsite-test cluster.
  5. Use Braddock as the application server for smartsite-beta.
  6. Use Mario (ng) for the application server.  Luigi or the RAC can be the database for this. 
  7.  
  8.