Lab 15:To configure an Amazon Relational Database Service

                               Lab 15:To configure an Amazon Relational Database Service

Oblective:To configure Amazon Relational Database Service

Topology:

Pre-Requites:

User Should have AWS account ,or IAM user with Amazon RDS Full access

Task:

Create Amazon Relational Database service

Verify Connection from mysql client command line tool

Verify Connection from work bench client application

Practical -Steps:

To create Amazon Relational Database service

From the AWS Console 

select Database 

click on Rds service

in "Rds Dashboard",wizard

click "Get started Now ",button

in select Engine,wizard

click on MY SQL

Click on select button

in production wizard

select Dev/test,choose MYSQL

In specify DB Details,wizard provide following values

Instance specifications

For DB Engine---------->mysql

For License Model------>general-public-license

For DB Engine version---->5.6.27[leave default]

For DB instance class----->db.t2 micro

For multi-AZ Deployment----->NO

For storage type------------->General purpose SSD

For allocated storage--------->5GB

under settings

For allocated storage--------->5GB

For DB instance identifier------>rdsdatabase

For master username---------->testuser

For master password*---------->***********

For master confirm password--------->************

click on Next button.

In configure Advanced settings,wizard

under Network &security

provide following values

Vpc*-------------->Default vpc

Subnet Group----->default

publicly Accessible-------->yes

AZ----------->No prefference

vpc security groups----------->create new security group

under Database options

provide following values

Data base Name---------->salesdba

Data base port---------->3306

DB parameter group --------->

option Group---------------->default .mysql 5.6k

copy tags to snapshots---------->leave blank

Enable IAM DB Authenticattion----------->No prefference 

Enable Encryption------------------>No

provide Following values

Under Backup

Backup Rentention Period ----------->7 days

Backup window---------------->No prefference 

Under Monitoring 

Enable Enhanced Monitoring----------->No

Under Maintaince 

Auto Minor version upgrade ----------->No

Maintainance window------------------>No preferrence

Click on Launch DB instance

your DB instance is being created

click on view your Db instance button

under status column

verify creating

select MYSQL Engine

under Status column

verify backing-up

under status column

verify available

client side 

Go to linux box

Run mysql client command to connect to RDS database 

Syt:$mysql -u<username> -h <End_point_of_RDS_instance>-p <password>

To see the list of database

use the database

create table

insert values in tables

To see the structure of table;

To see the records of table;

2.To access RDS database through MYSQL work benchBench client application

Open MYSQL workbench client application,provide following details

On MYSQL connection Tag,click plus radio button

provide the following values for

connection Name----------->testcon1

connection method----------->standard (TCP/IP)

parameters

Hostname------------------>copy RDS url(rdsdatabase.clkyahad3ggx.ap-south-1.rdsamazonaws.com)

port----------------->3306

user name----------->testuser

password----------->*****************

verify

connection is getting established

so we can see that tables are listed in Mysql clients.

3.To delete the RDS instance

3.1 open RDS database,select instance

drop down instance Action button,select Delete

For create final snapshot------------->No

select ackowledge check box

click on Delete button

verify

In status column-------------->Deleting

Delete confirmed