Configure MySQL Environment

This chapter will create source environment on AWS as discussed during Exercise Overview. The CloudFormation template used below will create Source VPC, EC2 hosting MySQL server, IMDb database and load IMDb public dataset into 6 tables.

  1. Download the CloudFormation template
  2. Open CloudFormation, click on Create Stack and select With new resources (standard)
  3. Select Template source as Upload a template file and choose the downloaded yaml file Final Deployment Architecture
  4. Click Next
  5. Provide Stack Name, Select DBKeyName and Update Parameters as necessary (you can leave default value as well) Final Deployment Architecture
  6. Click Next
  7. Click Create stack
  8. The CloudFormation template will take 15-20 minutes to build the environment Final Deployment Architecture
  9. Go to EC2 Dashboard and ensure the Status check column is 2/2 checks passed before moving to the next step. Final Deployment Architecture