Explained: Amazon RDS for MySQL in Amazon Cloud-A DBaas

Amazon RDS makes it easy to set up, operate, and scale MySQL deployments in the cloud. With Amazon RDS, you can deploy scalable MySQL deployments in minutes with cost-efficient and resizable hardware capacity. Amazon RDS frees you up to focus on application development by managing time-consuming database administration tasks including backups, software patching, monitoring, scaling and replication.

Amazon Relation Database Service will support two databases. Mysql and Oracle with various versions. It is a kind of Platform as a Service in Amazon Cloud for Databases.

Features of Amazon RDS

1. Hassel free Setting up the DB Instance(machine)

No need to worry about Hardware, OS installation, MySQL Installation, and dependencies etc. Amazon is providing the simple Web Console or API’s or Command-lines to create/manage the DB Instances.

2. High Availability of DB Instance

Amazon provides High Availability, with Multi-AZ. If the Mutli-AZ is enabled on your instance, It will create a Standby copy of the DB Instance in another zone. In this way, it will provide you the high availability.

3. Great Performance with Read Replicas(RR)

You can create the Read Replicas from the master RDS instance, using this Read Replicas Instances you can diverse Read traffic to this, and writes on the Master DB. So, master DB will have less load. Amazon will take care of the Synchronization of the data between Master and Replicas.

4. Automated Backups

Amazon will provide you the automated backup, and you can configure the backups(DB snapshots) at your convenient timings. And the backups will be stored across all Availability Zones randomly. In this case, you have high availability of the Backups.

5. Easy Recovery of the DB

DB Snapshots also available in the console, you can easily recover the DB instance using Point-in-time Restore, It will restore the DB with latest Snapshot, or You can create a new DB Instance from the latest Snapshot.

6. Auto Upgradation

Upgradation of DB instance can be automatically taken care by the Amazon. The only thing is you need to provide the Maintenance Window. In the maintenance window, Amazon will execute the DB upgrades, Hardware Upgrades, and Hypervisor Upgrades etc.

7. Security

Amazon will disable the access of the instance by default for all. And you can authorize Specific IP’s or IP ranges only, for granting access and all Amazon will provide the Interfaces you.

8. Easy to manage the DB Instances

Amazon will provide all sorts of Interfaces to manage the RDS Platform. It has simple Web Console, and API’s for Developers and Command-line tools for Administrators.

9. DB parameter changes with no Downtime.

You can Change the DB parameters with Command-line tools easily without Downtime of the Instance.

10. Easy Scaling

You can simply increase the DB storage, CPU and Memory resources by modifying the DB Instance, at any point of time.

11. Monitoring and Alarming

Amazon will provide the Cloud Watch Monitoring tool, you can monitor the Amazon RDS Statistics like CPU utilization, No.of DB connections, Storage Usage, DB writes and Reads etc. And It also provides alarming to your email based on the threshold level settings by you.

12. Locality

Another benefit of using Amazon RDS is the option of selecting from multiple geographic regions to deploy your database(s).

13. DB Instances Activities Information

Amazon will provide you the Recent/History of Events happened/performed on the RDS instances, like Instance rebooting, modifying, DB snapshot taken etc..

14. Support

Amazon has great support via Amazon Forums. Lot of Amazon users and their Concept Experts and respective Feature Developers from Amazon will answer for your questions on forums. For your question, at least within 3 to 4 hours of time, you can expect a solution, and they will correct it at the backend, if you provide the details. Here is the link to post the questions on forum.

Disadvantages of Amazon RDS

1. No Complete control on the DB instances, and you cannot get the logs to analyze any issues/problems.

2. With Single-AZ RDS instance Deployment; DB backup is almost highly impossible, if DB size is more like 5GB or me.

3. We will not have any control on the Stand by DB instance on the Multi-AZ deployment mode.

4. Amazon Will not inform you about the Maintenance activities on DB instances. But you can get to know by visiting their forums.

Keep visiting this space for more on Amazon RDS management, How-to’s etc.

[Editorial Notes: Guest article contributed by Praveen Kumar Muppala, Infrastructure Technical Lead at Kuliza. Praveen earlier wrote an article on EC2 instance monitoring : Explained: Amazon EC2 Instance Status Monitoring and Managing Scheduled Events]

Also see: Amazon DynamoDB Looks Like A Game Changer