User:RobertKaye/May15 Release Plan

15 May 2012 Schema Change Release Plan

Prior to release

• commit MP::Table changes
• Prepare production branch
• Run tests

Actual Release

On totoro

• turn on replication logging
  • see http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Cloning_a_Live_Database

On astro

• turn off cron on astro
• take down servers
• clear memcached
• check out updated production branch
• run upgrade.sh
  • upgrade.sh exports final replication packets for schema 14
• increment schema number in DBDefs.pm
• bring up servers
• test to verify things are OK

On pingu, asterix

• take down servers
• check out updated production branch
• increment schema number in DBDefs.pm
• bring up servers
• test to verify things are OK

Post release steps

• enable cron on astro
• post release notes on blog
• transclude any changed docs
• initiate a backup run