- Amazon RDS - Home
- Amazon RDS - Overview
- Amazon RDS - Environment
- Amazon RDS - Interfaces
- Amazon RDS - DB Instances
- Amazon RDS - DB Storages
- Amazon RDS - MS SQL features
- Amazon RDS - MS SQL creating DB
- Amazon RDS - MS SQL Connecting to DB
- Amazon RDS - MS SQL DB Export Import
- Amazon RDS - MS SQL DB with SSL
- Amazon RDS - MS SQL DBA Tasks
- Amazon RDS - Oracle Features
- Amazon RDS - Oracle Creating DB
- Amazon RDS - Oracle Connecting to DB
- Amazon RDS - Oracle DB Data Import
- Amazon RDS - Oracle DBA Tasks
- Amazon RDS - MariaDB Features
- Amazon RDS - MariaDB Creating DB
- Amazon RDS - MariaDB Connecting to DB
- Amazon RDS - MariaDB Data Import
- Amazon RDS - PostgreSQL Features
- Amazon RDS - PostgreSQL creating DB
- Amazon RDS - PostgreSQL Connecting to DB
- Amazon RDS - PostgreSQL Data Import
- Amazon RDS - MySQL Features
- Amazon RDS - MySQL Creating DB
- Amazon RDS - MySQL Connecting to DB
- Amazon RDS - MySQL DB Export Import
- Amazon RDS - MySQL DBA Tasks
- Amazon RDS - Multi-AZ Deployments
- Amazon RDS - DB Snapshots
- Amazon RDS - DB Monitoring
- Amazon RDS - Event Notifications
- Amazon RDS - DB Access Control
Amazon RDS - Overview
As RDS is a managed service provided by AWS, we can expect that like other AWS services it will provide scalability, security and cost effectiveness to the various RDBMS it provides. The database products available through AWS RDS are as listed below.
MySQL - Support versions for MySQL 5.5 to 5.7. Minor upgrades happen automatically without needing any involvement from the user.
MariaDB – Support versions for MariaDB from 10.0 to 10.2.
Oracle – Supports version 11g and 12c. You can use the oracle license provided by aws or bring your own license. The costing for these two are different.
Microsoft SQL Server – Supports version 200t to 2017. Also AWS supports the various editions like – Enterprise, Standard, Web and Express.
PostgreSQL – Supports version 9 to 11. Can be configured as a multi A-Z deployment with read replicas.
Amazon Aurora – This is Amazon’s own RDBMS. We will be covering it in a separate tutorial.
Each of these Database software is offered as Software as a Service (saas) by providing following features.
Customization of CPU capacity, Memory allocation and IOPS(Input Output per second) for a database instance.
Manage software patching, failure and recovery of the RDBMS software without any user intervention.
Allow manual or automated backup of the database using snapshots. Restore the database from these snapshots.
Provide high availability by creating a primary and secondary instance which are synchronous. In case of a failure of primary AWS RDS automatically fails over to secondary.
Put the databases in a virtual private cloud (VPC) and aslo use AWS IAM (Identity and Access management) service to control access to the databases.
There are two purchase options for AWS RDS service. On-Demand Instances and Reserved Instances. For on-Demand instance you pay for every hour of usage while for Reserved instance you make a upfront payment for one year to three period time frame.