Amazon Relational Database Service (RDS) vs. Oracle MySQL Cloud Service

Amazon Relational Database Service is a perfect fit for everyone who is seeking for an high-performance cloud-based database service. No matter if Postgres, Oracle, or any other type of relational database. Amazon RDS is our first choice for any kind of database requirement in the cloud. Especially I like the scalability.

It is very scalable and it gives us backup for everything. Because of this feature, we (as a developer) can do any R&D if required. It is very stable so we can get any type of help. It has a recovery feature also which we used recently for my project. It is very easy to recover.

• Automated Database Management: We use it for streamlining routine tasks like software patching and database backups.
• Scalability on Demand: we use it to handle traffic spikes, scaling both vertically and horizontally.
• Database Engine Compatibility: It works amazingly with multiple database engines used by different departments within our organization including MySQL, PostgreSQL, SQL Server, and Oracle.
• Monitoring: It covers our extensive monitoring and logging, and also has great compatibility with Amazon CloudWatch

Incentivized

• Oracle database has ability to store large scale of data.
• It can support any kind of scenario with any label of system.
• Encryption and security is the key features of Oracle database 12c.

• It is a little difficult to configure and connect to an RDS instance. The integration with ECS can be made more seamless.
• Exploring features within RDS is not very easy and intuitive. Either a human friendly documentation should be added or the User Interface be made intuitive so that people can explore and find features on their own.
• There should be tools to analyze cost and minimize it according to the usage.

Incentivized

• It has some issues [when] performing local unit testing in personal edition.
• It is costly if we will go for cloud.
• Need license for some features.

We do renew our use of Amazon Relational Database Service. We don't have any problems faced with RDS in place. RDS has taken away lot of overhead of hosting database, managing the database and keeping a team just to manage database. Even the backup, security and recovery another overhead that has been taken away by RDS. So, we will keep on using RDS.

Incentivized

I've been using AWS Relational Database Services in several projects in different environments and from the AWS products, maybe this one together to EC2 are my favourite. They deliver what they promise. Reliable, fast, easy and with a fair price (in comparison to commercial products which have obscure license agreements).

Incentivized

I have only had good experiences in working with AWS support. I will admit that my experience comes from the benefit of having a premium tier of support but even working with free-tier accounts I have not had problems getting help with AWS products when needed. And most often, the docs do a pretty good job of explaining how to operate a service so a quick spin through the docs has been useful in solving problems.

Incentivized

the online training & digital content available on the web from AWS was having sufficient information to deploy and run the service

Incentivized

In a few words, we are just to confortable working with oracle and sql server. Using RDS add another layer of distributed database in order to backup everything we have in case of a disaster and also complies with authorities locally and internacionally. All database we use, are local in custom servers that we maintain, but we agree to expand this.

Incentivized

It has the most stable database. It smoothly supports [a] huge [amount of] data. Security-wise it is best among them. It is a very large community and has well-defined documentation, which can support [during the] implementation of the Oracle database. We can easily scale up servers whenever [we] change our requirements. Oracle12c is best for large-scale projects like banking and retails.

• RDS is costly and thus small business should avoid it as it might not be worthful (in ROI perspective)
• Downtime is very low and there are automated backups thus we dont have to worry much about technical stuff and can focus more on marketing and sales
• Due to various automated features such as automated backup etc we dont need a huge technical team thus reducing the cost of maintaining a huge technical team ,

Incentivized

• It has ability to handle [a] huge [amount of] data and give [the] best performance
• Easy to write PL/SQA queries
• Secure and encryption option