Lab 17: Relational Data Base (RDS)

                                                  Lab 17: Relational Data Base (RDS)

What is RDS? Why we use it?

It is a web service that makes it easier  to setup ,operate ,and scale a relational database in the cloud.It provides cost –efficient,resizable capacity for an industry –standard  relational database and manages common data base administration tasks.

Some keywords:

Cross Replication :

Subnet Group

DB instance

 

Lab :Creating a RDS

Create an own vpc(Refer  above how to create an own vpc)

Go to the RDS dashboard before creating the database Create a subnet group

An RDS subnet Group is a collection of subnets that you can use to designate for your RDS database

Instance in a vpc.The database within your VPC will use the subnet Group and the preffered Availability instance zone to select a subnet and an IP address within that  subnet.An Elastic Network interface will be associated to the database instance with that IP address .Note that each DB subnet Group should have at least one subnet for every Availability Zone in a region.

 

Click on Create DB subnet group

Give a name to the Subnet Group

Choose your Vpc

 

Add subnets to the group

 

And another availability Zone Subnet Group

 

And click on Create

Then go to the RDS Dashboard

Select create a Data Base

 

Select Mysql data base

Click on next

 

Click on Next

Select dev/test my sql

Click on Next

Select DB version mysql 5.6.40

Select Database instance type t2 large

In multi AZ deployment choose create replica in Different Zone.

If one zone goes down another zone will be there (High Availability)

Leave all other as default

In settings section

Give name db identifier

In master user give name as root and give password

 

Click on next

In network and security

Give the own VPC

Select subnet group which you have created above

Public accessibility as Yes

 

Leave all other as default

Click on create database

 

DB created

To connect to the database

Download MySql client

MYSQL workbench and dbveawer

https://dev.mysql.com/download/workbench

 

From the above download mysql database

https:// dbeaver.io/download/

 

From the above link download dbeaver

Click on to the MYSQL workbench

 

Click on mysql connection + symbol

 

You will get a page like this

Give the connection name as rds-db

In hostname give the endpoint of rds database

 

 

Then click on store in vault

 

Give the password which you have gave while creating the Database

 

Then click on test connection

 

Will get like this

Then click on ok

 

SQL page will be open

Enter show database in the query page will displays what data base you have in the database.

 

You can create a database

Create database <databasenames>

And Execute the query

 

Amazon RDS Read Replica enable you to create one or more read-only copies of your database instance within the same AWS Region or in a different AWS Region. Updates made to the source database are then asynchronously copied to your Read Replicas. In addition to providing scalability for read-heavy workloads, Read Replicas can be promoted to become a standalone database instance when needed. A Read Replica in a different region than the source database can be used as a standby database and promoted to become the new production database in case of a regional disruption.

You can now use Read Replicas with Multi-AZ while creating the rds only.

For another region you can create the read replica after creating the rds.

Just go to the rds dashboard

Select The created database Click on the Actions.

Click on create Read Replica

 

You will get the page like this

Select the region in which region you want to do

Give the destination subnet group and public accessible as YES

Select the multiple availability Zones

 

Select the required details  and then click on create the read replica

Go and check  in the region you have created the read replica

Execrise:Create an rds by using maria DB and ms-sql db.