Amazon Relational Database Service

Amazon Relational Database Service
Name	Amazon Relational Database Service
Developer	Amazon Web Services
Released	October 26, 2009
Operating system	Cross-platform
Genre	Cloud database
License	Proprietary

Amazon Relational Database Service. It is a managed database as a service offering from Amazon Web Services that simplifies the setup, operation, and scaling of a relational database in the cloud. The service provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as migration, backup, and software patching. It allows users to focus on their applications to give them the fast performance, high availability, security, and compatibility they require.

Overview

Launched in 2009, this service was a foundational component in the expansion of Amazon Web Services's enterprise cloud offerings, providing a direct alternative to on-premises database management system installations. It operates within the global infrastructure of AWS Availability Zones, ensuring high availability and durability through features like Multi-AZ deployment. The service integrates deeply with other AWS products such as Amazon Elastic Compute Cloud, Amazon Virtual Private Cloud, and AWS Identity and Access Management for comprehensive cloud solutions. Its management is primarily conducted through the AWS Management Console, AWS Command Line Interface, or various software development kits.

Features

Key capabilities include automated backups, database snapshots, and point-in-time recovery, which are essential for disaster recovery planning. It offers read replicas to scale read-heavy database workloads and enhance performance for applications like content management or e-commerce platforms. Security features are robust, incorporating network isolation with Amazon Virtual Private Cloud, encryption at rest using AWS Key Management Service, and encryption in transit with Transport Layer Security. Performance monitoring is facilitated through integration with Amazon CloudWatch and Enhanced Monitoring, providing detailed metrics on CPU utilization, database connections, and input/output operations.

Supported database engines

The service supports several popular commercial and open-source database engines, providing flexibility for different application requirements. These include MySQL, PostgreSQL, MariaDB, Oracle Database, and Microsoft SQL Server. For each engine, Amazon Web Services manages the underlying infrastructure and common database tasks. A fully managed, MySQL- and PostgreSQL-compatible service, Amazon Aurora, is also offered as a high-performance option, featuring distributed, fault-tolerant, and self-healing cloud storage systems. Compatibility with these major engines allows for easier database migration from on-premises environments.

Deployment and management

Deployment options are versatile, allowing for instances to be launched in a single AWS Availability Zone or across multiple zones for fault tolerance. Management tasks such as software patching, operating system maintenance, and minor version upgrades are handled automatically. Scaling compute and storage resources can be performed with minimal downtime through operations like instance resizing and storage autoscaling. The service also supports Blue/Green Deployments for safer updates and uses the AWS Database Migration Service to facilitate seamless migrations from sources like Microsoft SQL Server or Oracle Database.

Use cases

Common applications include serving as the backend for web applications and mobile applications, where it manages user data, transactions, and catalog information for companies like Netflix and Airbnb. It is widely used for enterprise resource planning and customer relationship management systems, providing a managed database layer for software from vendors like SAP and Salesforce. The service also supports online analytical processing workloads for business intelligence tools such as Tableau and Amazon QuickSight, and is integral to gaming platforms for managing player state and leaderboards.

Pricing

Pricing follows a pay-as-you-go model, with costs primarily based on the selected database instance type, storage provisioned, and data transfer out of the AWS Region. Additional charges may apply for features like Provisioned IOPS storage, backup storage, and running in a Multi-AZ deployment. Reserved Instances offer significant discounts for committed use over a one- or three-year term, similar to the model for Amazon Elastic Compute Cloud. Users can estimate costs using the AWS Pricing Calculator and monitor expenditures with AWS Cost Explorer.

Category:Amazon Web Services Category:Cloud databases Category:2009 software