Wednesday, 2 August 2017

thumbnail

How to launch RDS (Relation Database Service) in AWS

How to launch RDS (Relation Database Service) in AWS

Introduction 

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale relational databases in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

Note :- If you dont want to use Amazon RDS service than you can launch your own EC2 instance and install the database service of your own like Mysql, Mariadb, Oracle, Aurora, MSSQL and Aurora. You will be responsible for managing your database and backup while if you use RDS then it will take care of it. You will have just schedule everything in proper manner and RDS will do the job for you.

In this tutorial we will see how to launch an RDS instance and I have free tier account so I can use 750 hours of Amazon RDS service for free.

1. First of all login to AWS console via browser and click on RDS:-


2. Now we have to click on Get Started to lauch an RDS instance :-


After that select the check box "Free tier eligible only"  so that it will show only open source free database engine . Otherwise we have to pay for the other databse engine which is paid.


Select the Engine and we will be provided with db.t2.micro instance and 20 GB of free storage  under free tier.

After that you will have give instance identifier name and  Master username and password from which will be able to login in database.


Next is how long you want to keep automated backup and monitoring service . Zero "0" will disable the automatic backup 


You can also go with default security group or create a new security as per your requirement.


It takes time to go online then afterwards we will see how to connect to it.


As you can see above the instance is available and host is up with port 3306 which is used for Mariadb and Mysql.

You might have to change the security group to allow port 3306 to connect remotely.

We will try to connect remotely from my terminal


The command to connect with terminal is given below :-

$) mysql -h hostname-aws -u masterusername -p password 

As we are using free tier Multiple AZ option is disable.  In the development environment multiple AZ is not required. But In the production environment multiple AZ is a good option. With the help of multiple AZ it will launch your instance in different AZ when configured with Auto-scaling.

  That's it enjoy using it.
Please do Comment, Likes and Share.
Tags :

Subscribe by Email

Follow Updates Articles from This Blog via Email

No Comments

Follow by Email