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?]
(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]
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