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.
- The 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 (but Multi-AZ is not there for RDS for free tier). When you provision a Multi-AZ database instance, Amazon RDS synchronously replicates your data to a standby instance in a different Availability Zone (AZ).
