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.
Duration: 60 minutes
AWS Region: US East (N. Virginia)
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.
Login to AWS Management Console
Create a security group for RDS Instance
Create an IAM Role
Create RDS Database Instance
Connect to the RDS instance using MySQL Workbench
Create a Lambda function
View the Table data in Lambda
Insert values to RDS from Lambda