Amazon RDS - Quick and Easy Way to Get Set up With Enterprise Database Architecture and Management
February 04, 2019

Amazon RDS - Quick and Easy Way to Get Set up With Enterprise Database Architecture and Management

Gabriel Samaroo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Amazon Relational Database Service

My organization uses Amazon Relational Database Service (RDS) to manage all of its Databases. The nice thing about RDS is you don't need to have a traditional Database Administrator on staff. Creating an instance of any of the many Database offerings (MySQL, Postgres, etc.) is as easy as a push of a button, and all the complexities around managing your data become very simple.
  • End-to-end management of your database -- including configuration, handling security, and maintenance.
  • Offers compatibility with many (and the most popular) database technologies -- including but not limited to MySQL, Postgres, Microsoft SQL Server, Oracle DB.
  • Makes backups and replications very easy, which is one of the toughest things to do effectively.
  • The logging options aren't as good as you would have if you managed your database yourself.
  • Restricted rights and permissions. Because you are using a managed service, you don't have 100% of all the capabilities you would traditionally have when managing a database yourself.
  • Because you are using a managed service, that's meant to do a lot for you and make things easy, you are paying a premium price. Some tasks are very simple (for even standard software developers, not even for a DBA). If you don't need to scale and aren't in a rush, the price might not be worth it.
  • Saved money on hiring SQL specialists or Database Administrators.
  • The security and back-ups offered help make my company's software solutions Enterprise-grade, which is necessary in today's world.
  • Save time because doing almost anything database related is very fast and only requires a few button clicks.
Amazon Relational Database Service will probably give you everything you need from a traditional manual DB setup, except everything is managed for you. The only downside is having to pay the premium for the service; however, the trade-off of not having to deal with the intricacies involved with database administration, make it well worth it for most.
Amazon Relational Database Service is great when you need a Database solution that can work for you very fast. It is also a great solution when you need a system that can scale to handle very large amounts of data. You can get set up with a complex, large database eco-system in minutes/hours, and have the best security and backups scheduled. The alternative to doing this would typically be hiring one or more very experienced database professionals for not just the implementation, but also on staff to handle the periodic maintenance necessary.