Hi friends i'm Gopal today we are going to discuss about Amazon RDS : Managed Relational Database in cloud.

Before going to discuss let's have a look on Relational Database

Relational Database:

Relational Database is the database in which data is represented in the form of tables.

The tables are related to each other we can retrieve required data by using queries. 

Amazon Relational Database Services:

Amazon Relational Database Services is a distribued relational database service by Amazon Web Services(AWS). It is a web service running in the cloud designed to simplify the setup,operations,and scaling of relational database for use in applications. Administration process like patching the database software, backing up databases and enabling point-in-time recovery are managed automatically. Scaling storage and compute resources can be performed by a single API call to the AWS control plane on demand. AWS does not offer an SSH connection to the underlying virtual machine as a part of the managed service.

Features of Amazon RDS:

New database instances can be launched from the AWS Management console or using the Amazon RDS APIs. Amazon RDS offers different features to support different use cases. Some of the major features are:

1)Multi-Availability Zone(AZ)deployment:

    In May 2010 Amazon announced Multi-Availability Zone deployment support. Amazon RDS Multi-Availability zone(AZ) allows users to automatically provision and maintain a synchronous physical or logical standby replica, depending on database engine, in a different availability zone.

     Multi-AZ RDS instance are optional and have a cost associated with them. When creating a RDS instance, the user is asked if they would like to a use a multi-AZ RDS instance. In multi-AZ RDS deployments backups are done in the standby instance so I/O activity is not suspenced any time but users may experience elevated latencies for a few minutes during backups.

2)Read replicas:

Read replicas allow different use cases such as to scale in for read-heavy database workloads. There are up to five replicas available for MySQL, MariaDB, and PostgreSQL. Instance use the native, asynchronous replication functionality of their respective database engines. They have no backups configured by default and are accessible and can be used for read scaling. MySQL and MariaDB read replicas can be made writeable again since October 2012, PostgreSQL read replicas do not support it. Replicas are done at database instance level and do not support replication at database or table level.

3)Performance metrics and monitoring:

       Performance metrics for Amazon RDS are available from the AWS management console or the Amazon CloudWatch API. In December 2015, Amazon announced an optional enhanced monitoring feature that provides an expanded set of metrics for the MySQL, MariaDB, and Aurora database engines.

4)RDS costs:

       Aazon RDs instances are priced very similar to AEC. RDS is charged per hour and comes in two packages: on-Demand DB instances and Reserved DB instances. Apart from the hourly cost of running in the RDS instances, users are charged for the amount of storage provisioned, data transfers and input and output operations performed. 

      Amazon RDS also has an Aurora Serviceless option. The serviceless pricing unit is dollars per ACU hour. ACU stands for 'Aurora Capacity Limit'. As part of the AWS free tier, the Amazon RDS free tier helps new AWS customers get started with a managed database services in the loud for free. You can use the Amazon RDS free tier to develop new applications, test existing applications, or simply gain hands-on-experiences with Amazon RDS.

5)Automatic backups:

      Amazon RDS creates and saves automated backups of RDS DB instances. The first snapshot of a DB instance contains the data for the full DB instance and subsequent snapshots are incremental, maximum retention period is 35 days. In multi-AZ RDS deployments backups are done in the standby instance so I/O activity is not suspended for any amount of time but you may experience elevated latencies for a few minutes during backups.

   In this way Amazon RDS provides different services that includes Managed Database Services, Multi-Engine Support, High Availability and scalability etc.

7 languages