Implementation Plan June 14, 2009

Personnel

• Programmer is James Renfro
• DBA is Prabhu Pilli
• QC is Sandra

Preparation for second pre-production release (June 12, 2009)

• (Programmer) Migrate SAK-2853.patch and SAK-2854.patch to production branch
• (Programmer) Modify prod sakai.properties to include final grade submission urls
• (Programmer) Cut gb2 prod release branch as:
  • https://source.sakaiproject.org/contrib/gradebook2/branches/Prod-2-5-x-UCD-Summer1
• (Programmer) Update svn scripts to include gradebook2 prod release branch
• (Programmer) Create prod tag sakai_2-5-x-prod-017-RC3
• (Programmer) Create sakai.properties prod tag: https://mware.ucdavis.edu/svn/ucd-sakai/sakai-properties/tags/sakai-properties-2-5-x-prod-017-RC3 from prod branch
• (Programmer) Checkout Prod-Tag-2-5-x-RC-17-RC3 on mario and deploy to staging
• (Programmer) Under config-staging, export sakai.properties as sakai.properties-prod-017-RC3 and make modifications by hand to sakai.properties
•  

Preparation for final production release (June 14, 2009)

• (Programmer) Copy over sakai and properties tags to non-release-candidate version
  • svn copy https://mware.ucdavis.edu/svn/ucd-sakai/sakai/tags/sakai_2-5-x-prod-017-RC3 https://mware.ucdavis.edu/svn/ucd-sakai/sakai/tags/sakai_2-5-x-prod-017
  • svn copy https://mware.ucdavis.edu/svn/ucd-sakai/sakai-properties/tags/sakai-properties-2-5-x-prod-017-RC3 https://mware.ucdavis.edu/svn/ucd-sakai/sakai-properties/tags/sakai-properties-2-5-x-prod-017
• sakai.properties additions/changes

  • # GB2: Help URL
    gb2.help.url=http://smartsite.ucdavis.edu:8000/smartsite/ucd-gateway/Gradebook2Documents.html
    
    # GB2 : Final Grade Submission
    final_grade_submission_url=https://classes.ucdavis.edu/CourseManagement/final_submit/fgs_direct_upload.cfm?sakai_id=
    final_grade_submission_path=/afs/.ucdavis.edu/app/sakai/gradefiles/
    
    # Stealth Tool List
    stealthTools@org.sakaiproject.tool.api.ActiveToolManager=sakai.discussion,sakai.presentation,sakai.metaobj,sakai.search,sakai.ucd.training.admin.tool,sakai.rutgers.linktool,sakai.rutgers.testlink,blogger,sakai.assignment,sakai.ucd.enterprise.data.tool,sakai.messagecenter,sakai.ucd.stats,sakai.reports,smartsite.guest.activate,smartsite.guest.register,sakai.gradebook.gwt.rpc
    

During maintenance window

• (ProjManmgt) Set database marker.
• (S + 0 min Programmer) Put all application servers into maintenance mode and shutdown Sakai on each one
• (S + 10m DBA) Backup full database
• (S + 35m DBA) Apply sql scripts at:
  • https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/gb2_data_model_changes.sql
  • https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/sakai_2_5_3-2_5_4_oracle_conversion_SAK-13474.sql
• (S + 2m Programmer) Deploy sakai release tag via setup-sakai-node.sh to sakaiprod1.
• (S + 35m Programmer) Restart sakaiprod1 sakai instance
• (S + 40m Programmer) Add gb2 to the following sites:
  • Login to sakaiprod1 as an admin user
  • Go to Administration Workspace, Sites tool
  • Search for siteid 319258e7-c2ee-4eab-80c8-65365458c345 (AAS 070 001 W06) by pasting 19258e7-c2ee-4eab-80c8-65365458c345 into the box to the left of SiteId and then clicking on SiteId
  • Drill down via the SiteId to the site properties page and scroll down to and click on "Pages"
  • Choose New Page
  • Enter Page Title: Gradebook 2
  • Click on New Tool at the top of the new page
  • Click on the radio button next to Gradebook NG (sakai.gradebook.gwt.rpc)
  • Change the title in the box at the bottom from Gradebook NG to Gradebook 2
  • Click Save
  • Visit the site to verify that the tool is there and activates the new tool
• (S + 45m QC) Verification for the following sites: (1) AAS 070 001 W06
  • Add gradebook2 to my sites
  • Verify that I can navigate to each UI panel.
  • Verify that same number of learners exist as before (screen shots).
  • Verify that I have the same number of categories and items as before (screen shots).
  • Verify that grades can be entered.
  • Verify that categories and items can be added.

• (S + 60m Programmer) Deploy release tag via setup-sakai-node.sh to sakaiprod2 . . . sakaiprod6, and sakaiprodmail1.
• (S + 70m Programmer) Start Sakaiprod2 . . . sakaiprod6, and sakaiprodmail1.
• (S + 80m Programmer) Take smartsite-prod out of maintenance mode 
• (S + 84m Sandra) Send Release Management email

Fall-back Procedure (If needed) Time D is the decision time made to fallback

• (D + 0m Programmer) Shutdown Sakai on smartsite-prod
• (D + 2m DBA) Restore all database tables from backup
• (D + 5m Programmer) Remove sakai.properties from config-staging and rename sakai.properties.016 to sakai.properties
• (D + 15m Programmer) Deploy previous tag on head node and all other app servers via setup-sakai-node.sh
• (D + 42m Programmer) Restart sakai head node after verifying with DBA that restore is complete
• (D + 45m ProjManmgt) check database marker
• (D + 50m Programmer) Restart sakai on remaining nodes
• (D + 60m Programmer) Take application servers out of maintenance mode