How to Query into RDS MySQL Using AWS Lambda

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)

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.

Task Details

  1. Login to AWS Management Console

  2. Create a security group for RDS Instance

  3. Create an IAM Role

  4. Create RDS Database Instance

  5. Connect to the RDS instance using MySQL Workbench

  6. Create a Lambda function

  7. View the Table data in Lambda

  8. Insert values to RDS from Lambda

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