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 ...

 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.




Ansible,6,AWS,1,Azure DevOps,1,Containerization with docker,2,DevOps,2,Docker Quiz,1,Docker Swarm,1,DockerCompose,1,ELK,2,git,2,git quiz,1,Git Worksheet,1,Jira,3,Kubernetes,1,Kubernetes Quiz,5,SAST DAST Security Testing,1,SDLC Quiz,4,SonarQube,3,Splunk,2,vagrant kubernetes,1,YAML Basics,1,
DevOpsWorld: AWS- RDS (Relational Database Service) Theory + Lab
AWS- RDS (Relational Database Service) Theory + Lab
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content