| Table of Contents |
|---|
TODO
So far this is a copy of the 1.1.7 deploy instructions.
Preamble
- notify all stake holders before the release.
- for this deploy we are pulling from svn trunk
- execute all steps in the SF ENVs first and test the application.
- if tests pass, then execute steps on SD ENVs.
- In the unlikely event that things go very badly, we switch over to the old application in SD.
web into MAINT mode (SF_PROD_WEB)
put the web servers into maintenance mode (SF WEB, SD WEB)
| Code Block |
|---|
cd /var/www/html sudo ./set_eas_mode.sh MAINT |
Database Backup
Log onto the SF DB and back up the databases. The exact command line resides in the postgres user crontab.
| Code Block |
|---|
sudo -u postgres -i crontab -l /home/dba/scripts/dbbackup.sh > /var/tmp/dbbackup.log |
EAS ETL
Deploy new code to ETL server . There are new deploy helper scripts that you can place in the top directory. Follow the pattern shown in the DEV env.Execute the and run the following commands in order.
| Code Block |
|---|
python job.py --action INIT --job migrate_to_1.1. |
...
| Code Block |
|---|
>8 --env SF_PROD python job.py --action STAGE --job streets --env SF_PROD python job.py --action EXECUTE --job migrate_to_1.1.78 --env SF_PROD |
SFGIS ETL
Ensure the following SFGIS workspaces are of the latest version on the FME Server Production server (10.250.60.184).
...
When we run the streets STAGE job, note that DB replication will be on. This may result in a replication delay alert from NAGIOS but it should not overwhelm replication because its well under 100K records (with line geometry).
SFGIS ETL
initialize database feature classes (delete and recreate using ArcGIS)
- street_segments_provisional
- street_segments_staging
- streetnames_provisional
- streetnames_staging
- eas_addresses_flat_export (adds street_post_direction char(10))
deploy workspaces
- streets_source_to_sfgisStg_setenv.fmw
...
...
- streets_sfgisStg_to_sfgisStg_setenv.fmw
...
- change were made to account for post_direction
deploy db views
- run sql: create_views_vw_basemap_stclines_lt.sql
Web Server
Log into SF PROD WEB and deploy the application as shown here.
...
Test the application to make sure everything works.
Deploy to SD Datacenter
If testing passes, deploy the web app to SD PROD WEB.
...
| Code Block |
|---|
cd /var/www/html sudo ./set_eas_mode.sh STANDBY_SD_STANDBY |
Release Notifications
- remove 1.1.8 from road map
- publish blog post
- cross post to yammer
send email to stake holders
- remove 1.1.7 from road map
Done!
...
using automation
Code Block python job.py --action EXECUTE --job announce_new_release --env SF_PROD