I utilize Amazon RDS as the backbone for content management and stored user information for our corporate web presence. I was looking for a scalable relational database that would be an easy transition with my background in MySQL. I didn't want to spend a lot of time setting up and managing replication and backup, and I didn't want daily maintenance tasks. RDS fit the bill nicely, and coupled with my EC2-based web hosting, provides a easy-to-implement security.
Pros
Simplicity
Security
Monitoring
Cons
Properly implementing security can be challenging for new users
Administrative tools are not always intuitive
Likelihood to Recommend
Well suited for system administrators looking to incorporate a highly available RDBMS into their AWS-hosted web site. Not well suited for WYSIWYG web site developers.
We are using RDS in storing all our products and their information. We have hundreds of brass products and we have maintained all our product database with RDS. It is quick and easy also we have assigned to roles to avoid access to unauthorized users. We have different databases of products depending upon our audience and purpose.
Pros
RDS is fast
All versions of databases engines are already installed
Highly secure
Takes less time to setup
Cons
Logs needs to be more visually appealing and detailed in a proper way
Cost is high
Scaling is an issue, it is tiring and exhausting
Likelihood to Recommend
I am storing structured data such as product description, SKU, price, dimensions, customers reviews etc due to which i need to have structured data therefore relational database is very appropriate for my use case. It becomes very fast. Moreover my setup is in Amazon EC2 thus Amazon RDS has integration for that aswell thus making it a perfect combo.
We use RDS to power our custom programs and applications. We are a bolting company with a wide range of data sets. We collect tool data in the field and expose it through an endpoint for other systems like SAP and MSDCRM. We enhance our custom programming by utilizing customer and location data to give our clients full visibility of their equipment and maintenance records. Multi-availability zones, full backup and restore capability on both our PROD and UAT instances, and monitoring help us stay on top of our database performance.
Pros
The RDS console allows for a quick view of the health and status of a DB instance.
Simple management of routine database tasks, backup, restore, etc.
Cost-effective
Works seamlessly with our EC2 instances.
Cons
No root access to an RDS instance.
mySQL databases max out available storage quickly.
UAT and PROD version of identical databases don't allow duplicate naming.
Likelihood to Recommend
For our small team of developers, RDS makes it easy for us to manage many databases simply. Working mostly with MySQL databases we can easily scale and resize our dbs as well as create and restore backups. One drawback is that AWS security is outside of our ability, so we must rely on an IAM administrator who controls access.
Currently, we are using a lot of backend application that needs a database. RDS is easy to configure and easy to manage compared to traditional on-prem databases where you need a dedicated DBA team, but here we are able to manage it. We were facing latency issues earlier due to cloud to on-prem latency, but everything is smooth.
Pros
Automatic backup.
Easy to configure and manage.
HA with Multi-AZ setup in nominal cost and effort.
Cons
Table defragmentation happens, and the process degrades. There should be a mechanism for defragmenting.
Likelihood to Recommend
It is best suited when you are hosting applications too on cloud so it becomes easy to connect and you can have internal communication on your VPC. RDS also provides you the option to explore various different DB like Aurora, MySQL, and Oracle.
We use RDS service for MySQL databases to host our OLTP applications . It’s a very easy to use service and the GUI interface is user-friendly to monitor and perform database admin tasks . The version upgrade or patching is very seamless and done without issues most or times . MySQL databases running on Rds have better performance than ones hosted on physical machines.
Pros
Easy to upgrade your databases.
A good interface for performance monitoring using performance insights.
Backups are automated.
Encryption can be turned on optionally.
Performance Insights.
Cons
Very little access to DBAs for admin.
A lot of functionality that is on Prem is not available.
Mysqldump has restrictions.
Likelihood to Recommend
Very minimal intervention is needed, storage can be autoscaled along with lot of other parameters . Good disaster recovery plan and can be designed as per our needs , multiple read copies can be created for reporting . backup and restore is very important easy . Performance insights can be improved bringing in dashboard type of views for performance metrics.
VU
Verified User
Employee in Information Technology (10,001+ employees)
Amazon RDS helps our company simplify its cloud database in regard to scaling and operation. We can operate more databases with RDS and maintain database backups with ease. The scope we use RDS for the most is viewing I/O metrics and capacity. That way, we only pay for what we need.
Pros
Cost
Automatic Database Backups.
Scalability
Cons
Slight learning curve.
Deployment can be tricky at first.
UI could be better.
Likelihood to Recommend
Amazon RDS is well suited for dealing with many different kinds of relational databases. This includes popular ones such as Oracle, PostgreSQL, and Microsoft SQL. RDS lets users at my company easily manage, configure, and backup instances when it fits the situation.it is less appropriate for logs. RDS does not provide a full set of logs when debugging.
We mainly use AWS in our org and are transitioning everything to VPC. One of the use cases was to have an RDBMS that supports several databases such as MySQL, Postgres, and the likes. AMAZON RDS checked all the boxes and made it easier for us to manage everything on AWS.
Pros
Supports MySQL, PostgreSQL.
Useful if you want to leverage Aurora.
Highly scalable.
Supports dynamic scaling.
Cons
Scale down is a bit buggy.
Likelihood to Recommend
Easy to create and configure. Front-end configuration makes it easier for non DBAs to maintain and manage databases on Amazon RDS. Well integrated with AWS' fine-grained and role-based security. Highly scalable and supports dynamic scaling which takes away the overhead of constantly monitoring databases for space/memory issues.
VU
Verified User
Project Manager in Information Technology (10,001+ employees)
We started recently using Amazon Relational Database service in our company. We are exploring the usage and trying to utilize it at the maximum level. Still we are in the learning phase. Presently we are using Amazon Relational Database service in building reports, Analyzing the data in different ways. As I said earlier still we are in the learning phase as of now we are in good shape.
Pros
Data storage and retrieval of data at high speed.
Able to store a huge amount of data.
Analyzing of data became more accurate.
Cons
Price is a little high
Multi-Master replication
Storage capacity needs to increase
Likelihood to Recommend
Amazon Relational Database is easy to Set up, Use and debug. Automatic patch is very good. Amazon Relational Database provides good security and it's configured very well. The timely backup is also too good in reality. Multi-tasking can be improved and the amount of data storage in one file needs to improve.
