Amazon RDS

Pros

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.

Cons

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.

Pros

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

Cons

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

Pros

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

Cons

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

Pros

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.

Cons

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

Pros

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.

Cons

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.

Pros

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.

Cons

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.

Pros

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.

Cons

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

Pros

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.

Cons

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.

Pros

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.

Cons

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

Pros

Amazon has worked hard to democratises databases, it's easy to set up a variety of different type of databases: SQL, Oracle, MySQL etc and perform things that typically have been a little more complicated with just a few clicks for example snapshots and database mirrors for you analytical platform.

Choose the region in which you're seeking to operate with just a few clicks, and it's pretty easy to kick off auto-scaling etc.

Cons

You need to be careful with billing surprises, make sure that you're familiar with Cloudwatch before you start playing with RDS.

Keep an eye on how much it's costing you.

Amazon may be elastic, but your budget probably lacks the same amount of elasticity.

Pros

i really appreciate easy dashboard and possibility to write new records quickly

Cons

some problems occoured in our management software while using program

Pros

I tried it but it just was not what I was looking

Cons

Our business is too small for this product

Pros

Most loved feature is data security and durability as we can take snapshot of data at another region its very easy to backup and restore data .Its all in one service for database

Cons

I have use this service alot and there is hardly anything I least lied but one thing is while we need support from AWS we need credits for that.

Pros

Amazon RDS provides the capability to host whichever database server customer wants, providing options like MS SQL , PostgreSQL, and have its own in house Aurora DB.With the Host and user/password simplified model like any other database it allows users who are not familiar with cloud to use it similarly.I have used Amazon RDS with all kind of databases and the way it optimizes costs and provides integration to logs is amazing.

Cons

Log and monitoring on the console could be improved and enhanced heavily

Pros

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.

Cons

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 .

Pros

- Fully managed database
- Access to all the configuration options you would usually do when tweaking the configuration file(s)
- Top notch support
- High-availability is just a few mouse clicks away
- Incredible easy to setup master/slave scenarios
- Great backup (snapshot) service
- Great performance with basic monitoring included
- You get the database engine you already know without the hassle to have to set it up by yourself

Cons

- Price? AWS is still expensive
- Nothing else I can think of

Pros

Amazon RDS is easy to create and maintain, just a few clicks to set up a new Database instance and AWS will take care of all maintenance and upgrade task. RDS is well integrated with other AWS component for security, role-based access and query access. RDS is cheap compared with other solution and it has flexible on select instance size, engine, purchase mode and scale mode for cost-optimized. AWS RDS provides fast response and very reliable

Cons

We should trickly use AWS version of the database engine. Its database logs are not kept for a long time and we have to use additional solution for keeping the log.

Pros

- the ease of setting up and getting ready with the first instance
- the multitude of options when getting to advanced level
- the performance of the Aurora engine

Cons

- could not get the fastest performance being connected from remote vs connect from another Aws instance. A minimum 60ms overhead is added to every query, which disappears running the client on an ec2

Pros

A lot of server tiers available to choose from, good when you need to start out with a smaller instance. Like to option to quickly create snapshots or restore a backup. Multi-az is a nice freaute to have that can save your business when things go south.

Cons

Halted instances are booted back up after 7 days automatically, so you can't really have an instance that is stopped for a long time. Since it's not a self-hosted service, there are some low level features that are missing.

Pros

AWS is the reason, amazon is giant today and RDS is one of the most used services on AWS.
No need of maintaining own infrastructure, server, backup plans. Use RDS, they have everything ready for you, create RDS instances , as much as you required, scale if you need more resources, use RDS backup
plans to backup all your data and retrieve whenever required. with 99.999% availability and highly secured features, your application development will be much better.

Cons

security features need to be taken care seriously

Pros

It caters to all types of requirements in terms of size, it can handle any amount of data
The pricing is good and even a person starting out his website or server can use this to maintain 100% uptime of his database.
You can control a lot of things from the Control Panel of AWS which include monitoring CPU usage, number of connections. It provides easy rebooting as well.

Cons

There was nothing that I did not like about this software. I am still using it and it solves my use case perfectly.

Pros

Amazon is getting good at putting DB in the cloud that before you know it, it will be as easy and syncing data to another computer.
Amazon is in the right track and not for long other companies will follow and make their disaster recovery simple to do.

Cons

Amazon still has a long way to go to make every database work seamless, but they have the right idea and concepts and it will only be a matter of time.
The pricing is something to get use to until it goes down and the demand get larger.

Pros

I really like this software and I would sincerally recommend it. It is simple, practical and easy to use.

Cons

I think the only thing that I don't quite like is the cost. I think it is a little expensive.

Pros

- Great stability and performance
- Great technical support
- You almost don't need to mind at any configuration or database servers anymore

Cons

Maybe the costs, but it depends. For small databases the RDS may not be a good idea but for large ones, you'll probably spend less than maintaining you own infrastructure

Pros

Easy deployments and ability to run in AWS

Cons

Non RDBMS are the future. I always prefer DocumentDB or Mongo if possible

Pros

Amazon RDS simplifies database management with automated backups, scaling, and maintenance, reducing operational overhead.

Cons

Compared to self-managed databases, there is limited customization and control, especially for configurations and performance tuning.

Pros

RDS giving lot of features with better performance.

Cons

Doing setup become little bit difficult.

Pros

I like some of the things the most about amazon RDS no 1 obviously the pricing it is amazing you only get charged for your usage and then secondly the remote connection although it is not very easy but when you establish it like for example with your microsoft workbench then there is nothing better than Amazon RDS and then there is more good things for example this is very very secure and fast and reliable

Cons

The only thing i do not like about is it is very very hard if you are not a Database administrator this is probably harder for you maybe you need some extra exclusive study of it

Pros

It supports multiple database engines like PostgreSQL, Aurora, and MySQL

Cons

It is costly for high performance workloads and complex while setting up in multi AZ deployments.

Pros

One of the best thing about it is that no configuration & setup required in order to work with any database, it could be relational or non relational DB eg: MySQL, MongoDB, SQL or Oracle anything with just few clicks on aws console we can start working.

Cons

There are no major issue but pricing model comparison to on premise setup is costly & cluster updates sometimes delay the business operation & any production deployment.

Pros

Amazon RDS is easy to use .It helps to maintain the relational database in the cloud.Also it’s flexible and secure to use.

Cons

It has higher cost compared to other softwares.And also we can only increase the allocated storage in Amazon RDS we can’t reduce it.

Pros

RDS for MySQL provides an easy and simple way to set up and run MySQL servers on AWS cloud without having to setup EC2 machines. It supports easy scale-up options and can work with replication for your DRP. There is also a very nice console to monitor performance and slow-running queries, which is very handy.

Cons

There is no way to easily down-scale servers and you have to configure backup yourself.

Pros

It is a thorough database management systemd.

Cons

Being new presented several challenges which eventually we were able to receive guidance.

Pros

Provides all the basic features that we absolutely need, out of the box. Super helpful

Cons

Since it's an AWS service, it's just not very intuitive to get around with - just like any other AWS products.

Pros

You don't want to care about more configuration setup to run as we did in normal case. A lot of configurable variable available in it to help the system working smooth. You can change maximum setting at runtime . easy to setup replication here, user & permission management is fast & secure.

Cons

No more cons except the price in compare to others only.

Pros

Eaay to handle, and search. Eaay to understand

Pros

It was a overall good database solution for or company that had a nice dashboard for management.

Cons

Dashboard was confusing as there was so many options. Perhaps some better overall training would be something to do before jumping in.

Pros

RDS is a highly scalable database and it can scale up or down depending on the resource and workloads it has and it works smoothly even for high data volumes and increased traffic. It automatically backs up data and we can restore our data even if we lost it. This is a highly available db because it automatically stores data in another availability zone and if a failure happens, then the primary database will be replaced with that replica.

Cons

With our application requirement, we have to choose the supported db engine. That db engine running inside RDS has some limitations other than running it in our machine. So that is the drawback I see.

Pros

InexpensiveEase to useData security is highly recommended

Cons

Affected by system crashes which May result in data loss

Pros

Convenient and smooth process for usage. .

Cons

A lot of red tape to get set up to get started

Pros

It is scalable, we tried it on different projects, small and big and it performed well.With just a few clicks, you can easily add or remove database instances, adjust computing resources, and automatically scale your database as your application grow.

Cons

One bad thing is that developers have limited control over the underlying infrastructure and configuration.

Pros

It is a pay-per-use system where you are only charged for the number of transactions that occur. Still, there is also a subscription system called Reserved Instances (RI), so instances that generate transactions frequently use this system to reduce costs significantly. There are three types to choose from: one-year prepayment, one-year prepayment, monthly payment, and no prepayment, depending on the kind of discount. Pay-per-use is basically cheaper for cases where transactions do not occur frequently, depending on the situation, so you can optimize the charge by using different payment methods depending on the application.

Cons

I would like you to provide a concrete fault test solution. If you do not have a high level of knowledge about RDS, you cannot be relieved that you cannot perform useful failure tests assuming a failure occurs.

Alternatives Considered

Reasons for Choosing Amazon RDS

Switched From

Reasons for Switching to Amazon RDS

Pros

Aurora is a great port of mySQL - very compatible and super fast
Prices are always going one direction: down
Scalable way huge with just a few clicks
Automated backups, patching, upgrades
You can still do a lot of customization using PL/MYSQL
The instances just stay up and running - becomes one less thing to worry about
You have options: both mySQL and Postgres

Cons

It's not amazingly easy to update the various variables that enable you to configure your mySQL instance.
I wish it was a bit easier to get monitoring that would give you more granular insight into what's causing issues.
You don't have quite as much flexibility and control over special packages you might install to do special stuff (calculating the Levenschtein distance between words, for example).

Pros

AWS RDS allows us to deploy databases easily and efficiently with great resilience, scalability, and security - but without having to deal with managing a server. RDS makes it easy to spin up a new database, have multi-availability zone replicas, back it up, and do many other things. It's also dead easy to upgrade software versions - simply let AWS look after it.

Cons

Being a managed database service there are restrictions; for instance, with SQL Server you don't have the sysadmin role and you can't set any trace flag you want. You can adjust a number of parameters in the RDS console but only those which AWS have explicitly added support for. There are other caveats and restrictions for other DBMS products too.

Another thing I don't like is when you change your instance size it takes a long time - but at least there's no downtime. Also, tooling is restricted.

A lot of great tools to dig into performance and query tracing won't work with the AWS caveats so you have to use the AWS RDS console and logs and it can be more tedious to really drill into application performance bottlenecks.

Alternatives Considered

Reasons for Choosing Amazon RDS

Switched From

Reasons for Switching to Amazon RDS

Pros

Requires minimum knowledge or time to set up the database.
Everything you need is basically there.
Documentation is fantastic.
It just works and takes all the burden of infrastructure management from you.
A handful of engines, version, and extensions to them are supprted.
Integrated seamless to AWS infrastructure.

Cons

Price. It will literally eat 7/8 of your infrastructure budget.
Metrics lies. Performance insight simply does not work. Note, this is an opinion of somebody who paid for AWS Enterprise support (sigh, that's me)
Backups are not backups per se, this is filesystem rsync. So it is easy to end up with broken DB.
Support is very poor.

Alternatives Considered

Reasons for Choosing Amazon RDS

Switched From

Reasons for Switching to Amazon RDS

Pros

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 .

Cons

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

Pros

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

Cons

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

Pros

I like how easy it is to scale RDS up and down alongside its monitoring features which can be conveniently accessed via AWS console.

Cons

The burst balance limit for the underlying EBS disk gave us lots of problems. I wish this feature was more user-friendly.

Alternatives Considered

Reasons for Choosing Amazon RDS

Switched From

Reasons for Switching to Amazon RDS

Pros

Easy deployment
Easy management and monitoring
Affordable price

Cons

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

Pros

ease of setup
ease of taking snapshots
no configurational drainers
very easy to set up alerts for monitoring problems in the database
debugging is a breeze.

Cons

It is easy to get lost without an UI.
also replicating databases can get stuck sometimes if you don't know what you are doing.
replication can be pain depending upon whether you want (master-master) or (master-slaves)

Alternatives Considered

Switched From

Reasons for Switching to Amazon RDS