Deployment Details, March 03, 2009

 This Maintenance cancelled by Liz Gibson

Preparation work

• (Thomas) Build sakai_2-5-x-prod-014 on sakaiprod1
• (Thomas) Deploy correct sakai.properties to config-staging [These next 2 links don't seem to work...should it say branches instead of tags? or prod-014-RC1?]
  • https://mware.ucdavis.edu/svn/ucd-sakai/sakai-properties/tags/sakai-properties-2-5-x-prod-014/sakai.properties
• (Thomas) Deploy correct toolOrder.xml to config-staging [I don't see anything special about the order in this file - assuming I am looking at the right one]
  • https://mware.ucdavis.edu/svn/ucd-sakai/sakai-properties/tags/sakai-properties-2-5-x-prod-014/toolOrder.xml
  •  
• added myworkspace as type for the templates (!user and !user.guest) in production March-25-2009 so this does not need to be done during the roll-out

During maintenance window : March 03, 2009 : 05:00 - 07:00

• (05:00 Thomas) Put smartsite into maintenance mode and shutdown Sakai on all 7 application servers
  • (Thomas) 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:05 Prabhu) Backup production DB
• (05:30 Prabhu) Run the following DB SQL scripts:

  • https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/SAK-2578.sql
    https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/SAK-2578-verification.sql
    -- The count should be one : for the ~admin account
    

• (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
  • Login with a user account that hasn't logged in yet and verify that the tool order is correct
  • 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