Details
-
Type:
Improvement
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Labels:None
-
Story Points:1
-
Epic Link:
-
Sprint:Spring 7 : 13 Apr to 24 Apr, Spring 8 : 24 Apr to 8 May
Description
Please see new "appstore_rds" and "provision_rds" role directories on the master branch.
Comments at the top of
- appstore_rds/tasks/main.yml
- provision_rds/tasks/main.yml
describe sequences of tasks related to RDS creation that need to be implemented.
To implement these new roles, adapt and migrate logic from deployRDS.
Note:
Variable files used by this role are be defined in (or ought to be added to):
- common.yml
- secrets.yml (based on example_secrets.yml)
which are located in appstore-playbooks/Ansible/group_vars
In addition, both roles should use reasonable defaults whenever possible, defined in "defaults/main.yml" files.
See playbook setup.yml for an understanding of how and when the roles will be run.
Attachments
Activity
https://bitbucket.org/chesterdias/chester-local-appstore-playbooks/branch/IGBF-2345#diff
Please review the above codebase
Looked at the code. On first glance it looks great. I did not try to run it. I would like to merge into master for functional testing next.
When you are ready, please submit a PR from your branch to the team repository master branch.
cc: Chester Dias
Task structure overview appstore_rds
1. Query to check if instance is present
2. if no instance is found then create a new one with db_instance_id
3. Query to retrieve the newly created db info
4. get info about the appstore EC2 to add that IP to RDS security group
5. Drop if database with name rds_db_name is present and recreate new db
6. Create a new Db user and provide it with grants
Task structure overview for provision_db
1. Query to retrieve the newly created db info
2. get info about the appstore EC2 to add that IP to RDS security group
3. Drop if database with name rds_db_name is present and recreate new db
4. Create a new Db user and provide it with grants
I made some edits to the roles and test them. So far so good!
What's next:
- Plays to set up the S3 bucket (
IGBF-2346) - Plays to run database migrations
Please take a look. It would be great if you could do this the next time you are on the job.