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

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

Amazon RDS is really simple and lightweight. It is easy to use and scale up in the cloud. Easy to setup.

Inconvénients

I have not used Amazon Relational Database extensively, so I did not find any drawbacks forAmazon Relational Database.

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

We're using Amazon RDS PostgreSQL.

Our database use case is pretty trivial, so we're entirely satisfied with RDS experience.

Database is fast and efficient, very easy to scale by changing instance types, adding more disk I/O, or spinning up read replicas. Backups do not have significant performance penalty.

With some careful planning it is very easy to migrate between different software versions.

Reserved instances make it a very compelling offering.

Inconvénients

It gets expensive, but if you consider the fact that you don't need to deal with many daily operational issue, it's well worth the price.

You can only add storage capacity (no storage downsizing possible without a complex migration process).

Avantages

InexpensiveEase to useData security is highly recommended

Inconvénients

Affected by system crashes which May result in data loss

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

- Very easy to setup
- Creating database environments including HA in minutes
- Creating a HA environment without having to know anything about database replication
- Upgrading the DB engine with a click of a mouse
- Very ease to create backups (and setup automated snapshots)
- Easy to restore
- Can be managed via the weg GUI but also via the very powerful AWS CLI
- No need to manage an Operating system
- Changing instanced types if you need more or less CPU/memory.
- Dynamically change the storage
- Performance is very good

Inconvénients

- On Aurora the disk spaces grows automatically when the database grows. But when deleting lots of data its not possible to shrink the file system.
- No root access to server (which we never missed since using RDS)

Avantages

It makes your life way easier by not having to manage a database server. Amazon RDS abstracts all the server stuff away so you just focus on managing the actual database content itself.

Inconvénients

The UI is a bit clunky and some of the parameterization options are a bit difficult to use. There used to be a couple of bugs as well but they were fixed thankfully. With the lack of control over the server it can be a bit annoying if something is broken and you can't fix it.

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

It's fully managed database service with multiple database types available (Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server) - you can chose whatever you like or used to run. It's really easy to migrate from existing database of the same type. RDS is highly available and durable service if you chose to run in multi AZ (multiple availability zone/datacenter) scenario (master/slave replication). Amazon will do all the administration task like upgrades or failover for you. Max database storage size is 16 TB (in most cases) and you pay only for what you use.

Inconvénients

It'a a little pricey and not all advance database configuration/administratio options are available if you compare it to on premise deployment.

Avantages

1. RDS is very fast and feasible to fetch and manage the data.
2. Version are dynamic and can be chosen/changed through simple steps.
3. Restriction can be easily managed through subnets and security groups.
4. It has high uptime overcoming downtime and can be scaled easily.

Inconvénients

1. Some time for the beginners it is not easy to setup or manage.
2. Pricing is bit high if you are creating a small instance DB.
3. Integrations with 3rd party is quite a bit complex.
4. No fully admin controls are given to manage the DB.

Avantages

RDS is highly available, easy to scale and extremely customisable. Whether I want to set up a small MySQL database or a PostgreSQL instance to be run at scale, RDS is my first port of call.

Inconvénients

RDS can start to get pricey as the instance sizes increase. For most consumers with relatively optimised database queries, this would not be an issue - but for those that have not aligned their applications for efficiency, this could be problematic.

Avantages

As a sysadmin, I working with many databases and tools related to this. I could say that RDS is a great service, that allows your team to focus on business, letting Amazon manages your database for you.
I also appreciate pay on demand, and the facility to upgrade environments.

Inconvénients

I could say that I like every aspect of this product, but if I should say some negative aspect. I would say that price on America/Sao_Paulo is a bad aspect, but I know that isn't RDS problem but the cost of my country.

Avantages

Almost 100% uptime very reliable compared to own installation of mysql on EC2, auto backup, auto update etc are seamless and very stable product, aurora is a very promising technology for scalability too

Inconvénients

Not much the parameter groups UI is kind of stinks and has some default parameters configured is not good, for eg: definer statements need to be removed before uploading data/stureture from backups

Avantages

Amazon RDS provides arelational database instance that you can use to create any number to databases. All data are stored in SSD that provides faster read and write compared to conventional magnetic disk. Data can be secured by applying a security group such that the database can get request from within AWS (EC2 servers). RDS provides variety of databases each with their free tier.

Inconvénients

Prices to enable multi availability zones for an instance is just double to their singe availability zone. It is too costly. For beginner the set up of RDS is quite confusing. Sometimes It doesn't display the estimated price of while setting up resources of an instance.

Avantages

It has an easy setup for creating new database connections, it's very flexible regarding creation of snapshots and recoveries, easy to scale as needed, It has the ability to create replication in simple steps.

Inconvénients

By far it has met my needs, so I have no concerns about this software.

Avantages

- This is a good choice, if you want to get a relational database server immediately up and running
- No operations or maintenance overhead
- Good security features, easy to configure them up
- Scheduled backups/failovers is very easy to setup

Inconvénients

- Slightly expensive
- Other than that it offers exactly what you expect from a managed db and more

Avantages

Easily scalable system. Different DBMS available, so everyone can find a good fit. A lot of metrics available, so you can track what's going on with your databases.

Inconvénients

Once set, some of the setting are not easily changed (like space reserved for RDS instance). Restoring includes restore of complete instance, not just a DB, so in some scenarios it can take a lot of time.