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. Launch the CloudFormation template in US East 1 to deploy the resources in your account: CloudFormation Optionally, download the YAML template and launch it your own way in the CloudFormation Console
  2. Click Next
  3. Confirm the Stack Name rdbmsmigration and update parameters if necessary (leave the default options if at all possible) Final Deployment Architecture
  4. Click “Next” twice then check “I acknowledge that AWS CloudFormation might create IAM resources with custom names.”
  5. Click “Submit”
  6. The CloudFormation stack will take about 5 minutes to build the environment Final Deployment Architecture
  7. Go to EC2 Dashboard and ensure the Status check column is 2/2 checks passed before moving to the next step. Final Deployment Architecture

Do not continue unless the MySQL instance is passing both health checks, 2/2.