Friday, March 4, 2022

AWS- RDS (Relational Database Service) Theory + Lab

 Relational Database Management System

It is a type of DBMS (Database Management System) that stores the data in Relation or Tables (which is further having rows and columns). RDBMS includes the functions that have Integrity, Security, Backup, Restore, accuracy consistency, etc.

Amazon RDS (A Relational Database service by Amazon)

  • Easy to set up, operate and scale a relational database in the cloud and no need for installing and maintaining database software.
  • It provides cost-efficient and resizable capacity while automating time-consuming administration tasks, such as hardware provisioning, database setup, patching, and backup
  • It provides fast performance, high availability, security, and compatibility. So you can focus on the application instead of spending time on DB administration-related tasks.
  • It supports 6 familiar database instance types  Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server.
  • The Amazon Aurora engine will automatically grow the size of your database volume as your database storage needs grow, up to a maximum of 64 TB or a maximum you define. The MySQL, MariaDB, Oracle, and PostgreSQL engines allow you to scale up to 64 TB of storage and SQL Server supports up to 16 TB. Storage scaling is on the fly with zero downtime.
  • The automated backup feature of Amazon RDS enables point-in-time recovery for your database instance. Amazon RDS will backup your database and transaction logs and store both for a user-specified retention period. 
  • Database snapshots are user-initiated backups of your instance stored in Amazon S3 that are kept until you explicitly delete them. You can create a new instance from database snapshots whenever you desire.
  • Amazon RDS allows you to encrypt your databases using keys you manage through AWS Key Management Service (KMS). On a database instance running with Amazon RDS encryption, data stored at rest in the underlying storage is encrypted.
  • Amazon RDS Multi-AZ deployments provide enhanced availability and durability for database instances, making them a natural fit for production database workloads. When you provision a Multi-AZ database instance, Amazon RDS synchronously replicates your data to a standby instance in a different Availability Zone (AZ).


Step 1: Search for RDS service or Goto Database-->RDS

Step 2: Click on Create Database button.

Step 3:  Chose option Standard Create

Step 4: Database Instance MySql

Step 5: Templates: Free tier

Step 6: Provide admin user password and confirm password.

Step 7: Storage Autoscaling :- Max autoscaling 21 GB

Step 8: Select Default VPC

Step 9: Public Access Yes

Step 10: Select Security Group make sure port number 3306 is opened for the Inbound rule.

Step 11: Click on Create Database

Step 12 : It takes around 10 mins to create the database.

Step 13: Once the Database get created then select the database by clicking on it from the database list.

Step 14: Copy the EndPoint and connect it from the remote system.



Post a Comment