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

Prerequisites

  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.

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