AWS RDS Service

An AWS RDS Service is a distributed RDBMS service that is an AWS DBMS service.

• Context:
  • It can support several AWS DB Instance Types, such as a db.t2.micro (for ~0ドル.017/hr).
  • It can (typically) instantiate AWS RDS Instance DBs.
• Example(s):
  • Amazon RDS for MySQL, for MySQL.
  • Amazon RDS for MariaDB, for MariaDB.
  • Amazon RDS for PostgreSQL, for PostgreSQL.
  • Amazon RDS for Oracle, for Oracle RDBMS.
  • Amazon RDS for SQL Server, for MS SQL Server.
  • ...
• Counter-Example(s):
  • AWS Redshift.
  • AWS DynamoDB.
  • AWS Athena.
  • AWS EMR.
• See: Amazon Aurora, Point-in-Time Recovery, EC2 Instance Type.

References

2018

• (Wikipedia, 2018) ⇒ https://en.wikipedia.org/wiki/Amazon_Relational_Database_Service Retrieved:2018年9月18日.
  • Amazon Relational Database Service (or Amazon RDS) is a distributed relational database service by Amazon Web Services (AWS). ^[1] It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications. ^[2] Complex administration processes like patching the database software, backing up databases and enabling point-in-time recovery are managed automatically. ^[3] Scaling storage and compute resources can be performed by a single API call as AWS do not offer ssh connection to RDS instances ^[4] . Amazon RDS was first released on 22 October 2009, supporting MySQL databases. ^{[5] [6] [7]} This was followed by support for Oracle Database in June 2011, Microsoft SQL Server in May 2012, ^[8] PostgreSQL in November 2013, and MariaDB (a fork of MySQL) in October 2015, and additional 80 features during 2017 ^[9] . In November 2014 AWS announced Amazon Aurora, a MySQL-compatible database offering enhanced high availability and performance ^[10] , and in October 2017 a PostgreSQL-compatible database offering ^{[11] [12]} was launched. ^[13]

2018b

• https://aws.amazon.com/rds/faqs/#versioningGuidance
  • QUOTE: For the list of supported database engine versions, please refer to the documentation for each engine:

Amazon RDS for MySQL Amazon RDS for MariaDB Amazon RDS for PostgreSQL Amazon RDS for Oracle Amazon RDS for SQL Server Amazon Aurora

2018

• https://aws.amazon.com/rds/faqs/
  • QUOTE: Amazon RDS manages the work involved in setting up a relational database: from provisioning the infrastructure capacity you request to installing the database software. Once your database is up and running, Amazon RDS automates common administrative tasks such as performing backups and patching the software that powers your database. With optional Multi-AZ deployments, Amazon RDS also manages synchronous data replication across Availability Zones with automatic failover.

    Since Amazon RDS provides native database access, you interact with the relational database software as you normally would. This means you're still responsible for managing the database settings that are specific to your application. You'll need to build the relational schema that best fits your use case and are responsible for any performance tuning to optimize your database for your application’s workflow.

2015

• (Wikipedia, 2015) ⇒ http://en.wikipedia.org/wiki/Amazon_Web_Services#Database Retrieved:2015年8月21日.
  • Amazon Relational Database Service (RDS) provides a scalable database server with MySQL, Oracle, SQL Server, and PostgreSQL support. * Amazon Redshift provides petabyte-scale data warehousing with column-based storage and multi-node compute.

• Concept