Technologies
Amazon RDS
Amazon RDS (Relational Database Service) is a fully manageable and scalable environment for relational database engines such as Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server.
Developers don't have to worry about configuring, scaling, updating, and protecting database servers—the AWS layer fully handles these tasks. Database instances are fully customizable, and backups are entirely automated. Amazon RDS is an irreplaceable element in the stack of any application that uses relational databases.
Technology in our projects
Amazon Relational Database Service: DB instances
Amazon RDS DB instances (e.g., SQL server instances) are environments containing databases. They're the main foundation of the Amazon RDS service. Developers can access and manage a DB instance through the AWS management console, AWS CLI, or Amazon RDS API.
Amazon RDS: DB engines
A DB engine is a specific relational database software that operates on a DB instance. The database engine is responsible for creating, updating, reading, and deleting data from a database. Amazon RDS provides support for database engines such as IMB Db2, Maria DB, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL.
Amazon RDS: Features
Read replicas
The replication feature allows Amazon RDS to enhance read scaling for heavy database workloads. Developers can use up to five replicas for PostgreSQL, MySQL, and MariaDB, increasing the capacity of a single DB instance and improving read performance.
Metrics and monitoring
The Amazon RDS Console tracks metrics such as storage capacity, memory, compute resources, utilization, instance connections, and input/output activity. It also allows developers to monitor performance through the Amazon RDS Performance Insights feature.
Backups
Amazon RDS manages backups and patching, ensuring a database's high security and performance. Developers can set up a rendition period, which allows them to restore a database to a given point in time. All these actions can be automated.
Pricing
Amazon RDS charges per hour of use, similar to Amazon Elastic Compute Cloud. Amazon offers two -pricing packages: On-demand DB instances and reserved DB instances.
For on-demand DB instances, users are charged for compute capacity per hour of use. The main characteristic of this option is the lack of long-term commitments.
Reserved DB instances allow users to reserve instances for a prolonged period—a one- or three-year term. Reserved instances are also eligible for a discount and provide three payment options: all Upfront, Partial Upfront, and No Upfront.
Amazon RDS: Advantages
Availability
Amazon RDS provides multi-AZ deployments that improve availability and data durability. It allows developers to create a DB instance in another availability zone. This feature is available for RDS for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and Db2.
Reliable backups
As mentioned, Amazon RDS provides automated backups that enable developers to restore databases quickly and reliably.
Security
Amazon RDS ensures a high-security level by allowing developers to define users and their permissions and move a database to a private cloud.
Easy to use
Amazon RDS is easy to use, as it comes with preconfigured parameters and settings for database instances. Managing databases is also easy and doesn't require special skills. The AWS Management Console can perform all the necessary actions.
Amazon RDS. Summary
Amazon RDS is a managed database service for relational database engines. Its goal is to provide developers with a tool for managing various databases quickly and efficiently. Amazon RDS enables developers to set up databases in seconds while maintaining customizability and automation.