AWS Quick Labs - Introduction to Amazon Relational Database Service (RDS) (Linux)

Introduction to Amazon RDS (Linux)

RDS is a cloud-based database service that is easy to setup,operate and scale. It is compactable to MySQL, PostGRE, Oracle and SQL.

This blog covers how to create an RDS instance and connect to RDS from a Linux client. 

Create an RDS Instance  

1) Verify the AWS region for better latency, you can find the region settings on the top of the AWS screen, by default it will be Oregon. You can change it as per your business needs and location.

2) Navigate to services then select RDS, you will get an RDS window click start the installation.


3) Select MySQL from next window, for MySQL, compacted RDS. Select the MySQL option under Dev/Test which is a free service.

4) In the DB details, the DB instance should be micro one for the minimum configuration. the allocated storage is 5GB for the DBand provide a username and password. This credentials we have to use when login to the RDS instance.

5) In the advanced settings the publicly accessible option give no and choose new security group. The security group provides the permissions for the RDS. Provide a database name and backup period give 0 days to copy immediately.

6) Navigate to EC2 security group, select 'RDS-launch-wizard'.

7) In the action\edit inbound rules select source to Anywhere. This allows the MySQL port open in the Security group. 

Create a Linux Instance

1) Go to EC2 menu and create a Linux, Refer to my previous blog for more details on How to create a Linux instance. 

Connect To EC2 Instance

1) Download the PPK file from the quick lab and save it and copy the Public DNS front instance and save it as well.

2) Open putty.which you can download from the Quicklab, and use the DNS and PPK file to connect to the instance.

3) You must be able to get the Linux instance. 

4) Install MySQL client by entering following command "sudo yum install mysql"

5) Copy the Endpoint name from RDS dashboard and replace it  in the endpoint section of the following command "mysql --host <endpoint-url> --password --user AWSMaster", then insert it in the Linux machine to connect it to your RDS.

6) Once you connect You can find mysql> in the Linux screen. we can use "show databases;" command to view database details.

Confirmation of Lab Completion