Olivier Le Moal - Fotolia
Many of the administrative tasks required to keep a relational database running are handled by the Amazon RDS service. Developers familiar with data modeling do not have to be proficient in administrative tasks, such as managing tablespaces and distributing table and index data.
There is no need to keep up with vendor security and performance patches when you use Amazon RDS -- this is taken care of by the service. RDS also includes backup and recovery services, eliminating another common task on to-do lists.
Amazon RDS now offers five database engines: MySQL, Oracle, SQL Server, PostgreSQL and Amazon Aurora. Aurora is a MySQL-compatible database designed for scaling database applications without specialized tuning skills being needed.
Developers can take advantage of existing commercial licenses when they use Amazon RDS. For example, if you already have an Oracle license for an on-premises database, you can use the "bring your own license" option, which will save on hourly charges.
RDS also manages Replication. If developers need high availability in a database, the multi-availability zone option in RDS can be used. With that option, a replica database is kept in sync with the primary database in case of failure.
Scaling is easy with Amazon RDS. Simple API calls or manual changes with the AWS Management Console are all that is needed to scale a database service up or down as the load dictates.
Another advantage of RDS is that database instances can be managed from the AWS console. When you run your own instances, you will manage them using database-specific tools.
Overall, Amazon RDS reduces or eliminates many of the database administration tasks that developers face when they run their own database instance.
Dig Deeper on AWS database and analytics strategy
Related Q&A from Dan Sullivan
When running AWS in our enterprise, it has been a challenge to keep tabs on active resources. Which native tools define and maintain configuration ... Continue Reading
With increasing use of cloud sending more enterprise data outside of the organization's control, due diligence is crucial. Expert Dan Sullivan offers... Continue Reading
Microsoft Azure VM Scale Sets help cloud admins manage a collection of VMs as a single unit. But what workloads are they best suited for? Continue Reading