RDS provides deployment agility and an on-demand database-as-a-service for MySQL, Oracle, and SQL servers.
With RDS, everything is turnkey and always available. For example, due to the inherent multi-availability zone feature of AWS, there is no downtime at all and you can count on AWS RDS to always be available.
For many of the Pythian customers, one salient benefit, among other benefits, is the option of spinning up a new instance whenever it is needed. Now it can be done with a few clicks, without much ado.
RDS doesn't have shell access. This could be beneficial, especially for Oracle databases.
One benefit of having shell access with RDS is that DBAs or developers could keep their own existing scripts. Especially in the case of non-enterprise versions, there is always a need to dig into performance issues and their troubleshooting. So shell access could be very handy in that case and in some other cases.
I have been using AWS RDS for the last two years.
We have not really had stability issues.
The technical support is good and prompt.
For many clients of Pythian, it’s an amalgamation of on-premises and cloud. Pythian enables its customers to reap the benefits of both worlds.
With the expertise and experience of Pythian, the initial setup was a breeze.
Read the fine print carefully and always engage experts to carry out migration.
We did not evaluate any alternatives.
Having your database on RDS doesn't mean that you don't need a DBA anymore. Mission critical and important databases must be handled by a DBA, even if the database resides on the cloud, like RDS.