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 West 2 to deploy the resources in your account: CloudFormation
    1. Optionally, download the YAML template  and launch it your own way
  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.