Support Documents
No data found.

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) us-east-1

Architecture Diagram


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.

  10. Validation of the lab.

  11. Deleting AWS resources.


  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.