How to Create Relational Database Service(RDS) on Amazon Web Service(AWS).

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups.

RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic Compute Cloud (EC2).

 

  • Login to aws portal.
  • Click on Services.

 

Fig 1

 

  • Under Database select RDS.

 

Fig 2

 

  • Click on Create Database.

 

Fig. 4

 

  • Select Standard database creation method.
  • Select Engine type: MariaDB, Microsoft SQL Server, MySQL, Oracle, or PostgreSQL. Microsoft SQL Server.For example: select MySQL.

 

Fig. 5

 

  • Then select  Mysql version.
  • Select Free tier template.

 

Fig. 6

 

  • Provide Db instance profile name.
  • Provide Database credentials like Master username & password.

 

Fig. 7

 

  • Select Db instance class.
  • Select storage type(SSD).
  • Provide Allocated storage size in GB.

 

Fig 9

 

  • By default storage auto-scaling is enable.

 

Fig 10

 

  • Select existing VPC & Subnet.
  • RDS can be either public or private.
  • Create or select existing security group.

 

Fig 11

 

  • Select Database authentication for RDS.

 

Fig 12

 

  • Click on Additional configurations.
  • Provide Database name.
  • Enable the backup for database.

 

Fig 13

 

  • Set the backup retention period.

 

Fig 14

 

  • Leave the performance insights option.
  • Enable monitoring for logs.

 

Fig 16

 

  • Select log exports : error,general or slow query log.

 

Fig 17

 

  • Click on create database.

 

Fig 18

 

  • After sometime RDS is ready.

 

Fig 18

 

Create RDS using Shell

aws rds create-db-instance –engine myql –db-instance-identifier db-instance-name –allocated-storage storage-size –db-instance-class db.t3.large –vpc-security-group-ids securitygroup-id –db-subnet-group subnet-id –master-username masteruser-name –master-user-password masteruser-password –backup-retention-period 3

 

Leave a Reply