Are you using a SQL database, having issues scaling up, why not try RDS?
July 25, 2017
Are you using a SQL database, having issues scaling up, why not try RDS?
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Amazon Relational Database Service
We use Amazon RDS very heavily in our company. It's being used by the database management team most of the times, however, to interact with the service we often try to write APIs to access the database. Currently, the main business problem it overcomes is the problem of scaling and adding new hardware, if we are running out of space. We don't really need to worry about buying new hardware, we just increase the size without any issues.
- Amazon RDS is exceptionally good as it offers a wide variety of database engines.
- Adding the security model to the RDS instance is amazing, you don't need to worry setting up SQL managers and servers for this purpose of handling security, it can be easily done using the security groups.
- You can place the database instance in public/private subnets as needed, and it's easily accessible remotely which I feel is another big advantage.
- Personally, I feel, RDS though it scales much, the pricing is too expensive, if the pricing for larger instance types are reduced, it would be much better.
- ROI can't be judged with just one factor, if the hardware has to be brought and maintained, we might need an additional resource for maintaining the database (database admin).
- Comparatively there are only positive ROIs to date, so we would highly recommend using Amazon RDS.
Initially, we planned to move everything to Dynamo DB, however, we had our initial architecture with MySQL, so we thought it would be a good option to migrate and use AWS RDS which seemed to be a good idea actually. I feel the security and the placing it in a VPC, is one advantage over the other products.