926432 - Downtime Maintenance to migrate air.mozilla.org production to use PostgreSQL databases

Status: RESOLVED FIXED

(Infrastructure & Operations :: Change Requests, task)

Description

[Brandon Burton [:solarce]]

* Date, time, duration of maintenance
Date: 2013-10-17 (Thursday)
Time: 10AM PDT - 11AM PDT
Duration: 1 Hours

* System(s) affected

The following sites will be affected by this maintenance

air.mozilla.org

* End-user impact

End users will be redirected to maintenance page at http://hardhat.mozilla.net during the maintenance window

No AirMo events are scheduled for Thursday

* Maintenance plan and timeline (link to a wiki or etherpad is fine)

- Work being tracked in https://bugzilla.mozilla.org/show_bug.cgi?id=899267

10:00AM -  WebOps enabled Hardhat redirect
10:05AM -  DBA performs steps to migrate production data from MySQL to PostgreSQL and updated application configuration with new database details
10:35AM -  Devs validate functionality
10:45AM -  WebOps removes Hardhat redirect


* Notification mechanisms

- Email to all/everyone
- Topic set in #it on irc.mozilla.org


* Who will be point, who else will be involved

Required: 
- :peterbe, main airmo dev
- :solarce, from WebOps
- :cyborgshadow, DBA

Optional: oncall sysadmin during window

Comment 1

[Shyam Mani [:fox2mike]]

Approved by the CAB on 16 Oct to be done on 17 Oct.