Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Labels:None
-
Story Points:0.5
-
Epic Link:
-
Sprint:Summer 1: 8 Jun - 19 Jun, Summer 2: 22 Jun - 3 Jul, Summer 3: 6 Jul - 17 Jul, Summer 4: 14 Jul - 28 Jul, Summer 5: 3 Aug - 14 Aug, Summer 6: 17 Aug - 28 Aug, Summer 7: 31 Aug - 11 Sep, Fall 1: 14 Sep - 25 Sep, Fall 2: 28 Sep - 9 Oct
Description
Move database copy logic to role mysql.
Modify variables files to mention old database only. "Old" database is the one we want to copy.
example_common.yml:
- first_rds_db_name - the name of the old database we want to copy
- first_db_instance_id - the RDS hosting the old database we want to copy
example_secrets.yml:
- first_rds_admin_password - admin password for the RDS hosting the old database we want to copy
- first_rds_admin_user - admin user name for the RDS hosting the old database we want to copy
Add logic to role mysql to run the following tasks if and only if all of the above variables are defined and first_rds_db_name is different from rds_db_name. (Use when statements.)
Tasks:
- Create mysql dump from first_rds_db_name hosted on first_db_instance_id
- Load data into rds_db_name hosted on rds_instance_id
Also, modify the code to stop assuming that RDS admin user is named "admin." This should be configurable.