Implementation Plan, March 31, 2009

Preparation work

During maintenance window : March 31, 2009 : 05:00 - 07:00
  • (04:55 Sandra) Setting DB restore marker: upload or create a file in Resources with text indicating this is a db marker
    • Also send an email to a couple of sites using email archive for the site (emailtestsite@smartsite.ucdavis.edu)
  • (05:00 Thomas) Put smartsite into maintenance mode and shutdown Sakai on all 7 application servers
  • (05:05 Prabhu) Backup production DB
  • (05:30 Prabhu) Run the following DB SQL scripts:
  • (05:35 Thomas) Deploy sakai_2-5-x-prod-014 tag on all 7 application servers via setup-sakai-node.sh
  • (05:40 Thomas) Startup sakaiprod1 and check for errors
  • (05:42 Sandra) Login with a user account that hasn't logged in yet and verify that the tool order is correct
    • user names used to verify included: wmjackson, obriens, and darlee.
    • Access an user's My Workspace via the SU tool and verify that the tool order is correct
  • (05:50 Thomas) Startup sakaiprod2, ..., sakaiprod6, sakaiprodmail1
  • (06:00 Thomas) Take smartsite out of maintenance mode
Fall-back Procedure (If needed)
  • (06:00 Thomas) Shutdown Sakai on all 7 application servers
  • (06:05 Prabhu) Restore Sakai DB
  • (06:35 Thomas) Startup sakaiprod1 and check for errors
    • (Sandra) Verify DB restore marker
  • (06:40 Thomas) Startup sakaiprod2, ..., sakaiprod6, sakaiprodmail1
  • (06:50 Thomas) Take smartsite out of maintenance mode
  • After done, post the results of the sql counts to this Confluence Page