Skip to main content
Launch this lab in the IP Lab Portal, then follow the steps below in the AWS console. Open IP Lab Portal

​
Overview

​
Prerequisites

  1. Good knowledge of AWS service
    • RDS
    • Elastic Compute (EC2)
  2. Laptop/Desktop
  3. Internet Browser
  4. Internet connection

​
Challenge Instructions

  • Region : Make Sure To Use Us-East-1 Region To Create All The Resources.
  • You Will Be Provided With The Requirements Of The Challenge. If You Are New To AWS Cloud, We Recommend You Go Through Our Hands-On Labs Before Taking This Challenge.
  • Challenge Duration: 120 Min

​

​
How to submit the challenge

  1. After Building The Infrastructure, Click On The Validation Button, To Validate If You Have Built The Required Infrastructure And Completed The Challenge Successfully.
  2. Validation Status:
    • Success - You Have Completed The Challenge Successfully.
    • Failed - You Have Failed To Complete The Challenge.
  3. Once You Have Successfully Validated The Challenge, Click On End Lab Button To End The Challenge.

​
Launching Challenge Environment

  1. To Launch The Challenge Environment, Click On The Start Challenge Button.
  2. Please Wait Until The Cloud Environment Is Provisioned. It Will Take Less Than A Minute To Provision.
  3. Once The Challenge Is Started, You Will Be Provided With IAM User Name, Password, Access Key, and Secret Access Key.
Note : You Can Only Start One Challenge At Any Given Time

​
Lab guide

​
Sign in to AWS Management Console

  1. Click On The Open Console Button, And You Will Get Redirected To AWS Console In A New Browser Tab.
  2. On The AWS Sign-In Page, Leave The Account ID As Default. Never Edit/Remove The 12 Digit Account ID Present In The AWS Console. Otherwise, You Cannot Proceed With The Challenge.
  3. Now Copy Your User Name and Password In The Lab Console To The IAM Username and Password In AWS Console And Click On The Sign In Button.
  4. Once Signed In To The AWS Management Console, Make The Default AWS Region As US East (N. Virginia) Us-East-1.

​
Cloud Challenge Details

In This Challenge, Your AWS Compute Skills Are Put To The Test. You’ll Be Given A Requirement And You Have To Reach It Using Your Knowledge Of RDS, EC2 instances and databases. Which Will Be Used In This Challenge. This Challenge Will Help You Understand The Real-Time Scenarios.

​
Architecture Diagram

A XYZ company is expanding its infrastructure on the cloud to enhance reliability and scalability. They aim to deploy a robust database solution capable of handling high volumes of user data with minimal downtime. After evaluating various options, they decided to leverage Amazon Aurora with Multi-AZ deployment on AWS for its superior performance, availability, and durability. Your task is to architect and implement an Amazon Aurora with Multi-AZ deployment on AWS to meet these demands efficiently.
  1. Launch an EC2 instance named MyRdsEc2server with Amazon Linux 2023 kernel-6.1 AMI, t2.micro type, and MySSHKey key pair.
  2. Configure the security group for the EC2 instance named MyEC2Server_SG to allow SSH access.
  3. Install MySQL on the EC2 instance using a user data script.
  4. Create a security group for the RDS instance named rds-maz-SG allowing MySQL/Aurora port (3306) from anywhere.
  5. Create an Aurora MySQL database named MyAuroraCluster with Multi-AZ deployment, specifying DB instance size as db.t3.medium, and configuring it to be publicly accessible for connectivity
  6. Connect to the Aurora database and note down the endpoints for Master (Writer) and Reader instances.
  7. Modify the RDS security group to allow access from the EC2 instance.
  8. SSH into the EC2 instance and use MySQL client to interact with the Aurora database.
  9. Perform database operations such as creating a database named whizlabsrds, table named whizlabs, with fields mentioned below and insert the data.
    • Fields:
      • subject_id (INT, AUTO_INCREMENT)
      • subject_name (VARCHAR(255), NOT NULL)
      • teacher (VARCHAR(255))
      • start_date (DATE)
      • lesson (TEXT)
  10. Initiate a failover from the RDS console to test Multi-AZ functionality.
  11. Connect to the new master instance and verify the presence of the database, table, and data.
  12. Click On The Validate To Complete The Challenge.

​
End Challenge

  1. Sign Out Of The AWS Account.
  2. You Have Successfully Completed The Challenge.
  3. Click On End Challenge Button From IP Lab Portal Labs Console And Wait Till The Process Gets Completed.

​
What gets checked

When you press Check my work, the platform verifies each of these:
  • Create RDS Cluster — Check whether RDS Cluster is created or not.
  • Force RDS Database Failover — Check whether RDS database failover is done or not.
  • Launch an EC2 Instance — Check whether an EC2 Instance is launched or not.