Build Your DB Server and Interact With Your DB Using an App

Amazon RDS:

Amazon RDS is flexible web service to setup, Operate and scale in rational database in AWS cloud.

Amazon RDS database engines:

Amazon Aurora, PostgreSQL,MySQL,MaraDB,Oracle,SQLServer.

Task 1: Create a Security Group for the RDS DB Instance:

DB Instance is the main structure of Amazon RDS also and isolated database in the AWS cloud.

Login to your AWS management console and click on the VPC on the service menu. And Create a Security Group.

Task 1: Create a Security Group for the RDS DB Instance:

DB Instance is the main structure of Amazon RDS also and isolated database in the AWS cloud.

Login to your AWS management console and click on the VPC on the service menu. And Create a Security Group.

Edit inbound Rules:

Task 2: Create a DB Subnet Group

Configure and launch a Multi-AZ Amazon RDS for MySQL database instance.   

Configure:

·       Name: DB-Subnet-Group

·       Description: DB Subnet Group

·       VPC: Lab VPC

·       Availability zone: Select the first Availability Zone

·       Subnet: 10.0.1.0/24

Then:

·       Availability zone: Select the second Availability Zone

·       Subnet: 10.0.3.0/24

Task 3: Create an Amazon RDS DB Instance:

Configure and launch a multi-AZ Amazon RDS for MySQL database instance using the configuration given. When you use Multi-AZ DB instance, Amazon RDS automatically synchronized it to replicate using the primary database.

 Once you click on the lab-db. You can review the configuration.

Copy the endpoint field in Connectivity and security section:

Task 4: Interact with Your Database

You can copy the web server IP address from the detail menu. Once you navigate to that you can see the following page.

Configure the following setting on the RDS tab.

·       Endpoint: Paste the Endpoint you copied to a text editor earlier

·       Database: lab

·       Username: master

·       Password: lab-password

·       Click Submit

After the successful execute message you can see an address book which is using RDS to store data.

Test the web application by adding, editing and removing contacts.

Benefits of AWS RDS:

1.     Scale: vertically or horizontally.

2.     Multisport for structured data.

3.     Simplicity.

4.     Automatic Management.

5.     Robust MYSQL Support.

6.     Minimal Downtime.

7.     Affordability.

8.     Speed & Performance.

9.     Automated Backup.

10.  Security.

Amazon RDS Use cases:

1.     Web and Mobile Applications (airnb)

2.     Ecommerce Applications because Amazon RDS provides flexible, secured, highly scalable and low cost database solutions offers for small and large ecommerce businesses.(Insracart)

3.     Mobile and online games. (Bandai Namco)

Amazon RDS is very useful for applications if user is not operating database.