Amazon Relation Database Services
By using RDS in Amazon, it is very easy to setup complete setup of database as compere to offline version of RDS. Complete Operation of the process is also be easy and also more scalable in a cloud. The main benefits to use RDS on cloud is cost-efficient and also capacity while managing time consuming database, also make administrator free from the task to focus on your applications and also on business. In RDS Amazon there are total six different types of engines, including Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, Oracle and Amazon Aurora.
This lab Will cover following steps which is as bellow,
- Create Relational Database Service (RDS) instance.
- Connect RDS with client software.
Step 1: Login using appropriate credential for AWS
First of all you have to login in AWS to access the services,
Step 2: Creating RDS Instance
To create a RDS instance first click on the services on the top of AWS management console, then go to the Database and select RDS,
In this RDS dashboard page you can see all the details like how many RDS instance is running and also count of Snapshots, Subnet Groups and many things. In this page just click on Launch a DB Instance,
In the next step we are going to select Database Engine which we discuss in top, which one we want to continue, Here we can see a 6 different DB Engine. We can go with MYSQL and hit on select.
Then they will ask us about for which purpose we are going to make this RDS instance, on the base of purpose we can select the plan so it will also beneficial for organization, In here we create for the lab practical purpose so we will go with Dev/Test option and go to next.
In the next step we are going to think about RDS in different region, if yes then go to the A-Z deployment and select yes. After that also how much storage you need to store data, apart from this all you also give a name to identify this DB, Username also with proper password, make sure you are not going to use any special character because password with special character is not acceptable.
For next step we also provide a VPC for this Instance means for which Network this Instance will work, also with a Security group of that VPC, So using VPC security group this instance will also secure with inbound and outbound rules. Database name is also required to call data from specific database,
After that in the bottom options in the same page, You have to fix that is it required to take a backup and if yes then what is the time period for this, 0 days means no backup, after click on Launch DB instance we can see a message of successfully creating this instance.
After all this process just click on VPC and go to the security group and select that group which one we use in the RDS instance, After that click on inbound rules in the bottom and add new rule for MySQL/Aurora (3306), we add this because we are going to use this port to connect this instance form the client and also give 0.0.0.0/0 means allow all the inbound traffic who want to access from the outside.
Step 3: Connect RDS to client server
For this first You have to create one EC2 instance to connect, after creating new EC2 instance select that instance and check it must be on and the status must be 2/2 check passed. After this go to the description and copy public DNS which is use to connect this Instance from our physical machine.
After that go to the connect which is step 3 on upper picture,In here we can see a new popup screen click on download remote desktop file for Linux and Mac users, For password click on Get password button
After clicking choose a key pair file which we selected while creating instance, and decrypt it, after this we will see the password.
After this just click on start of our physical machine and type mstsc (Microsoft Terminal Services Client) and click on it, copy that public DNS in the user name box,
After click on connect we get a screen for that instance,
Go to search and type MySQL Workbench 6..3 CE and press enter,
N.B: We have to download this MySQL Workbench from the internet and then install to use this service.
After click on this just click on plus sign to create a new connection and enter connection name, host name means Public DNS of that instance, username and password of RDS instance and click on OK.
In this lab we learn about how to create RDS and also how to connect in EC2 Instance but make sure you have to download MySQL workbench to use this RDS or to connect this RDS to your Instance and manage it from this instance.
On demand DB Instance it is charge on the base of total capacity per hour also base on By using which availability zone we are going to use like we used MySQL so for Sydney region we charged $0.026 per hour but if we use a different region like US west (oregon) then we will change $0.017 per hour. so the charge is base on region and standard of the instance also like db.t2.micro or small, medium, large and so on.
Charges also base how many availability zone we are use like single or multiple for example for single AZ deployment db.t2.micro we got charge $0.026 per hour but for multiple AZ Deployment we will charge for the same instance type will $0.052 per hour.