Amazon RDS vs Amazon Redshift

• 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.

Read full review

• Redshift is fully managed. Small teams do not have the resources to maintain a cluster. CloudWatch metrics are provided out-of-the-box, and it is easy to configure alarms.
• Redshift's console allows you to easily inspect and manage queries, and manage the performance of the cluster.
• Redshift is ubiquitous; many products (e.g., ETL services) integrate with it out-of-the-box.
• Writing .csvs to S3 and querying them through Redshift Spectrum is convenient.

Read full review

• Not fully configurable. It's a hosted service and you sometimes needs to work around RDS's rules, especially when it comes to administrating the service. But, it's similar to AWS's general architecture, so not a huge issue.
• Aurora is the "better" service from a performance perspective. From a cost perspective, RDS is fine and will likely improve over time.
• Cheaper to run your own database on your own instance, but I'm really stretching for a con here as it's relatively so inexpensive.

Read full review

• Can propose better optimization techniques based on the business use case.
• Can provide option to set the upper bound on number of connections to cluster
• Can improve on optimized writes/updates

Read full review

• 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.

Read full review

• Redshift has had a very positive impact on our business. It has been used to provide analytics on marketing campaigns to boost revenue.
• Redshift is instrumental in our payment collection business processes. It powers everything from who gets called to who gets sent collection emails.

Read full review