Amazon RDS

Avantages

RDS provides support for verity of database systems like mysql, postgreSql, Maria DB, Oracle, Microsoft Sql and a hybrid Aurora (supports both mysql & psql)

Resizing, network management processes like subnet and security group are easily manageable.

Using Aurora it has become easy to transfer data from DB to S3 using "INTO OUTFILE S3" query

Aurora is really faster when it comes to executing heavy flock of query simultaneously when compared with its native RDS, it increases the over all through put

Aurora Server less is a extremely cost effective solution when used with proper configurations, it scales up and scales down as per its usage (pay per sec)

Supports Auto Backing up and scheduled snapshotting which stores the DB snapshot in S3, which helps in recovery at times of data deleted by mistake or data corruption by some failure in the application etc

Aurora provides Export Snapshot to S3 feature, its a additional feature towards data movement from RDS to S3, from this we can easily migrate data from RDS to Redshift or Athena via S3

Inconvénients

Can't change subnet of a multi AZ RDS Database directly, to achieve this i had to first change my DB to single AZ

Aurora Server less dose not scale up when used with low CPU utilising application, user should have given the flexibility to change the autoscaling parameter for Aurora server less (CPU utilisation 70%)

Aurora the use of "INTO OUTFILE S3" query requires some additional setup steps at the s3 bucket end and IAM role which is well documented, but quite confusing,

Aurora dose not support newer mysql or psql versions which are supported by its native RDS's

Aurora when compared with its native RDS its slower for executing single queries,
officers Aurora is really faster when it comes to executing heavy flock of query simultaneously, but at the least we expect Aurora to perform as the same level as its native RDS when it comes to single queries

Aurora's Export Snapshot to S3 feature only supports Parquet file format, and on trigging Export it takes more time to start, it wold be better if the process starts instantaneously

Avantages

this freature of amazon can be pretty useful on your data analysis

Inconvénients

is pretty hiden, sometimes you forgot its exist

Avantages

Its saves time of their employees, productivity increased and cost of data management is reduced

Inconvénients

Their cost is high, because they make monopoly and less competitive.

Avantages

We have been using AWS RDS with MySQL since 2015. It is the best option we encountered in the market to set up, operate and scale a relational database in the cloud. Management Console is really easy to use. You can create, restore and scale any size of database in a matter of minutes. You should however be familiar with the technical term AWS uses. Be careful when you choose between General Purpose and Provisioned IOPS types.

Multi-AZ feature is a life saver if you have a database that cannot tolerate any downtime.

Point in time recovery saved us a lot. Also RDS takes automatic backups regularly.

You should also try Amazon Aurora which is an engine compatible with MySQL and PostgreSQL. AWS built Aurora for itself and the underlying technology is mind blowing.

Inconvénients

You should be careful with the price of Amazon RDS and keep an eye on CloudWatch and Trusted Advisor. It gets expensive depending on usage but still it is worth not to struggle with operational problems.

Avantages

RDS allows us easy to create and manage a relational database for our Application hosted in AWS. It supports many different instance type, engine and scale option to select. RDS works well with VPC to keep our database private and only allow to access from specify sources. It has a lot of monitor metrics such as CPU utilization, free storage, freeable memory and read/write latency and well notification system to keep track of our database. Excellent backup, snapshot and restore support by AWS

Inconvénients

Manage RDS's parameter is quite complex since it does not have good UI support. It lacks support tool to run SQL command directly from AWS console

Avantages

The best thing about Amazon RDS is, it automatically take backups of the database which increase more reliable systems so basically it supports recovery at that point.

Inconvénients

The least liked thing about Amazon RDS is there is no guarantee of hardware performance and also sudo access is to be provided.

Avantages

Amazon RDS is a very good product if you need a Database solution in your software architecture. Scaling and ensure performance without bottlenecks is definitely a plus value that Amazon RDS offers. Easier to integrate across other AWS products, but also on standalone software through DNS names and port, you can easily spawn a Database in a couple of clicks. Amazon RDS offers also Read-Replicas and Multi-AZ totally transparent to you, which makes it kind of unique in database hosting.

Inconvénients

Price: everybody is well aware of how much AWS costs in the long run. Amazon RDS solution makes no difference, but if you are well aware of the costs, then this shouldn't stop you from trying and using it.

Avantages

Amazon Relational Database Service is one of the best product of AWS. The best thing in it is easy to deploy,patch,backup,security and administrate . The distributed architecture provide render the high scalability feature in it. The hardware upgrade is also easy and less time consuming with AWS as it comes with the embed features of it. After switching to the AWS RDS there is a less administration activities needed on managing the databases. Best feature in it is, if you are new to the RDS it also provides the best practices and recommendations. Managing the database snapshot with the help of Amazon S3 is also very convenient.

Inconvénients

Amazon Relational Databases management is easy but it's little tricky also as if you mess up the security group setting to vast, it's not an easy task to solve the puzzle. Best practices is to keep the security group setting simple and as per recommendation by AWS.

Avantages

I use this service daily and it is really powerful, especially if you need to manage hundreds of databases without having to worry about anything. pointing in time backup is the most powerful feature ever.

Inconvénients

For the target audience of the service there are no cons, perhaps a little costs for smaller projects.

Avantages

Performance Insight is the best, it helps us to identify slow queries in our system. Also, since this is managed service, we don't have to worry too much about uptime.

Inconvénients

Since AWS RDS offers a lot of features, I usually lost when navigating the UI. Having the ability to create a custom dashboard for each user role can be helpful.

Avantages

This really reduces the operational time taken to set up a database on a cloud machine, the cost of setting up and managing is really cheep when compared to the native approach of installing mysql or psql on a EC2 and managing it,
it exposes us to a verity of options and versions which we wouldn't have been aware of , and setting them up in just clicks without even spending much time in researching on it and figuring out the way to setting it up ,
The security management is really good, we can set all types of security managements like, subnet, security group, VPC, IAM role etc, which will take a lot of effort if gone manually ,
Backup restore is really well managed , we can schedule the backup process which dumps the data into the S3, we can restore it when needed ,
it supports all type of CURD operations including cloning a DB setup,
it supports many type of databases, it has a new one called Aurora which is AWS specific which is in 2 flavours (mysql and psql) - can use it for high cost effectiveness, additional features and speed up your bulk query executions,
Upgrading DB version or any other edition are easy to make without any data losses,
it gives a DNS URL for the DB, we need not manually add its IP into a Rout53,
Now we can integrate RDS with AWS secret, using which the application can access the DB with a dynamic password, and this creds gets rotated every day, which really increases the security.
Query Execution history and resource utilisation monitoring .

Inconvénients

I know AWS is in a process of developing new hybrid databases like Aurora, i have noticed some trivial issues in it, its slower then RDS for executing stand alone queries , but its faster than RDS while executing Bulk Queries, there may be a way to SSH into the RDS machine or accessing its DB terminal , it would be better it i can do it on the UI, instead of remembering all the commands to connect

Avantages

Easy deployment
Easy management and monitoring
Affordable price

Inconvénients

Lack of replication options
It do not have a scheduler to keep a replica updated at a desired time

Avantages

I like how it scales seamlessly and can add new fields

Inconvénients

Nothing I dislike will continue using it as it is very flexible

Avantages

AWS provides a fully managed database solution covering a number of DB technologies, so most deployments can utilize this product. MySQL, Postgres, MSSQL, Oracle, MariaDB, are all there, as well as AWS's own Aurora high performance DB.
Automated backups, with 5 minute point in time recovery is provided out of the box at no additional cost, as is software patching. If you require high availability spanning multiple data centers, it's there too.

Inconvénients

If there is a downside to AWS RDS, it would be that it does not cover every use case. In the MSSQL world, you cannot use SSRS or SSIS on RDS, so would need to look at MSSQL on EC2 instead .

Avantages

Amazon RDS has worked really well for us for our cloud DB solution. It's pretty intuitive and easy to use, and you can choose exactly what instances sizes, storage sizes, etc. you want.

Inconvénients

Amazon RDS has a strange method for determining how many IOPS you get (Input/Output Operations per Second): it's based mostly on your db storage size. So if you have a smaller database that is hit a lot, you can get throttled with the IOPS. But if you have a large database that isn't hit as often, you end up having a lot of unused IOPS.

Avantages

Auto Scaling and high availability features are impressive, and it is effortless andtakes around 10 minutes to set it up. It also has a free tire service so that students can try it for learning purposes. But we need a database manager to connect it to the client's computer.

Inconvénients

Sometimes security groups create issue due to with it will get some problems with connectivity.

Avantages

We started using this as our DA Team size increased. Best is fast operations on data, connecting multiple databases and nice ui to write query to fetch data.

Inconvénients

Costly. Duplicating and copying data take much time

Avantages

We use Aurora, which gives us a lot of flexibility in scale and size. Not having to manage clusters or database consistency across a number of different machines is amazing.

Inconvénients

RDS, and aurora, generally lags behind the current state of postgres, which comes with the territory.

Alternatives envisagées 

Avantages

Amazon RDS is Amazon's solution to hosted database services in the cloud. The console is easy to use and provides a ton of functionality with the click of a button. They have CLI and other API's that makes it easy to automate processes such as backup and recovery.

Inconvénients

Microsoft products are supported but latest features are late to be added. Amazon likes to push their own products and slower adopt new features of SQL Server.

Avantages

It has met all our requirements regarding costs and storage. We observed no downtimes. Once set up, we did not have to manage it at all. Really enjoyed the backup functionality.

Inconvénients

Deployment was quite hard as for most of AWS infrastructure, but once you get over initial struggles it becomes relatively easy

Avantages

Amazon RDS provides all features of a modern RDMS and it takes it further by securing your RDS instance using IAM which improves access and security.The backup feature ensures that replicas of data are maintained in cases of data loss.

Inconvénients

One drawback is that it can be quite tricky to fully set up. The docs are easy to follow but you have to dig deeper to set up some feature that one is used to. A good example is setting up your RDS instance to allow connections from public IP addresses.

Avantages

RDS makes deploying a MySQL or Postgres cluster a breeze. Their Aurora fork of MySQL allows for even more performance boosts. Auto scaling is made easy. Back ups are made easy. RDS makes everything easy.

Inconvénients

Pricing can be a bit steep if you need their r3 server series.

Avantages

I like that I don't have to worry about my database as much - RDS takes care of all of the details. Security, scaling and uptime are all baked in to the service.

Inconvénients

Like all AWS products, it has a learning curve to figure out. And you don't get unlimited control - if you want that you have to deploy your own database servers.

Avantages

Amazon RDS allows creating DB instances in a very few clicks with full customization like engine type, size of class required, connectivity, availability, and durability.
Also, all monitoring, eventing, and logs are very handy and displayed on the pictorial representation dashboard.

Inconvénients

Honestly, Amazon RDS fulfills all the use cases for me and I haven't spotted any disadvantage in it.

Avantages

He been using AWS RDS for like 4 years now, & its the best Database management tool we ever tried. Here its super easy to operate & scale your database. The console is easy to understand & somehow intuitive if you been working with databases in past. Multi-AZ feature gives you power if you cannot afford any downtime. RDS takes backup automatically so no worries of loosing any data.

Inconvénients

Only dark side of AWS RDS is its pricing, do have a watch on what they billing you. Keep track of your usage on CloudWatch and Trusted Adviser. It may get expensive not not affordable if you use it without sincere approach.