Steps To Launch RDS Instance Amazon Cloud

Launch RDS Instance Amazon Cloud

In this article, we will learn to launch RDS instance. AWS provide very user-friendly UI. It is very simple to launch any service on AWS Cloud.
Launching RDS instance, you need to follow few simple steps and You will have your database live on Aws cloud.

Below are the points we are going to cover in this article.

1. About RDS
2. Benefits of RDS
3. Steps to Launch RDS

Let's go through above points one by one.

1. About RDS [Relational Database Service]

RDS service provided by amazon cloud to setup, operate and scale a relational database in the cloud. RDS has a resizable capacity and cost-efficient feature which is a help to managing database administration tasks and give you more time to focus on the application rather than the database. RDS will provide you six different type of database engines which will fulfill your application requirement. You can choose any database engine from Amazon Aurora, Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and MariaDB. Most used RDS database engines are Mysql, PostgresSQL, Oracle.

In this article, you will find steps to launch Mysql RDS instance on AWS cloud.

2. Benefits of RDS

$ Easy to Administer

Amazon will provide a user friendly amazon management console to access or configure RDS instance in minutes. No need to maintain and install database software.

$ Scalable

You can increase or scale rds instance and storage resource using as management console with few clicks only. AWS will allow to launch one or more read replicas to transfer read traffic from the primary database instance.

$ Available and Durable

AWS will offer a feature called Multi-AZ which gives you uptime SLA of 99%. Multi-AZ allows you to create a replica of primary database in any zone and both the database are in sync so less chance of data loss.

$ Fast

Amazon provides wide range database server sizing choices up to 32 Core CPU and 244 GIB RAM. You can also have choice to use SSD-backend storage for high performance.

$ Secure

Amazon provides easy control over network access to the database. You can use Security Group to allow or restrict IP range as per your requirement. Also, you can setup RDS instance in VPC (Virtual private network). No one from outside network has access to use or damage your RDS instance.

$ Inexpensive

You need to pay very less and only for the resource you consume. Aws provides different plans like up-front, no-upfront, partial etc. You can choose any plan according to a requirement which saves your lots of money.

$ Backup

RDS will provide an automated backup facility which will make a snapshot of your database on daily, weekly basis as per your requirement.

3. Steps to Launch RDS instance

1. Login AWS account & Choose RDS

First login to your AWS account and then go to the "Services --> RDS".

screen1-rds

2. Launch DB Instance

When you click on RDS option, it will open the console with zero instance available. Now Click on "Instances" from navigation pane then Click "Launch DB Instance".

screen2-rds

3. RDS Configuration [Select Engine]

Once you click on Launch DB instance you will get configuration panel where first you need to choose "Database Engine". As I already mentioned we are going to launch MySQL database engine so we chose "Mysql" then click on "Select"

screen3-rds

4. Choose Mysql Dev/Test

In the next step, you will need to choose MySQL for your production or Dev/Test environment. If you have a requirement to use high-performance Mysql instance then go with production. Dev/Test is also provided similar kind of feature you just need to pay more for a Production environment. I will recommend going with Dev/Test and if you feel it will not suit your application then you can easily switch to Production.

Select "Dev/Test" and click "Next Step"

screen4-rds

5. Specify DB Details

In this step, you need to feel DB details like DB version, instance class, storage type etc. I have provided you screenshot with important details to filled in red mark. Let's see detail point one by one.

  • Licensed model : keep default
  • DB Engine version : Choose database version from the list of version latest version you will get is 5.7.x but recommended to use 5.6.x.
  • Multi-AZ : Choose "No"
  • Storage Type : Choose "General purpose SSD" for high performance.
  • Allocated Storage : Add storage as required.
  • DB Instance Identifier : It's a name or tag for RDS instance
  • Master username : This is the master user of rds database. save this details to use later.

Once filled all the details then click on "Next Step".

screen5-rds

6. Configuration Advance settings

Now fill some advance configuration settings to complete the launch db process.

  • VPC : if you have VPC created on AWS then choose your vpc network else to choose default vpc option.
  • Subnet : Keep Default
  • Publicly accessible : Choose YES.
  • Availability zone : Choose any zone if you're not in vpc. If you are in VPC then first check your ec2 instance zone in which you are going to use RDS.
  • Security Group : Choose "create new security group"
  • Database Name : Give your database name which you want to create on RDS.

Keep other options as it is and click on "Launch DB Instance".

screen6-rds

It will take some time to launch RDS instance. Check below screenshot which will give you close look on how RDS will look once available.

screen7-rds

Now you can access rds instance on your terminal using below command, 

mysql -u username -h endpoint-host -p

I hope you like the article if you find any difficulties in launching RDS instance then please do comment your queries or problem via the comment section, till then stay tuned to techthings.org for more such valuable articles.

Latest Comments
  1. harry December 11, 2016

Leave a Reply

Your email address will not be published. Required fields are marked *