Create a CloudWatch event to periodically take backup of MySQL RDS table to DynamoDB

Lab Details

  1. This lab walks you through the creation of an RDS MySQL Database, creating a table and inserting some values using MySQL Workbench. Now we will create a Lambda function and write MySQL queries to read and write data into the database.

  2. Duration: 60 minutes

  3. AWS Region: US East (N. Virginia)


  1. For testing this lab, it is necessary to download the MySql GUI Tool, To download it, go to the Download MySQL Workbench page. Based on your OS, select the respective option under Generally Available (GA) Releases. Download and Install.


Task Details

  1. Login to AWS Management Console

  2. Create a security group for RDS Instance

  3. Create an IAM Role

  4. Create a DynamoDB Table

  5. Create RDS Database Instance

  6. Connect to the RDS instance using MySQL Workbench

  7. Create a Lambda function

  8. Create a CloudWatch Event

  9. View the Table data in DynamoDB

Architecture Diagram


Join Whizlabs_Hands-On to Read the Rest of this Lab..and More!

Step 1 : Login to My-Account
Step 2 : Click on "Access Now" to view the course you have purchased
Step 3 : You will be taken to our Learn Management Solution (LMS) to access your Labs,Quiz and Video courses