Skip to content

Instantly share code, notes, and snippets.

@jonathanbarton

jonathanbarton/steps_for_rollback

Created August 18, 2016 20:04
Show Gist options
  • Save jonathanbarton/5794396ee655d86714b28f1b1162493d to your computer and use it in GitHub Desktop.
Save jonathanbarton/5794396ee655d86714b28f1b1162493d to your computer and use it in GitHub Desktop.
Download ZIP
STEPS FOR ROLLBACK
Raw
steps_for_rollback
1. ) Take backup/snapshot of current data AND schema for current PROD database:
dledimsum-prod-aurora
2. ) Export data for dimsum.productEnrollments view -> .sql file
3.) Perform code rollback steps
4.) Create new database with name dledimsum-prod-120-aurora
5. Restore last Datapipe snapshot from dledimsum-prod-aurora into dledimsum-prod-120-aurora (referenced during call as UTC 8-17 PM time)
6.) Import data from step 2.) .sql file into dledimsum-prod-120-aurora dimsum.productEnrollments TABLE.
7.) Rename dledimsum-prod-aurora to dledimsum-prod-saved-aurora
8.) Rename dledimsum-prod-120-aurora to dledimsum-prod-aurora
9.) Compare last db snapshot from Datapipe and data and schema in PROD
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment