Amazon RDS

Cost Effective and Fully Cloud Managed Relational Database Service

Commentaires : Had A Really Great Experience with RDS, I have been evaluating Aurora with Native RDS so i will be talking more about Aurora in this Review

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

High availability even for database beginners

Commentaires : I am using it as a MySQL server. With a managed database server, almost everything can be configured by just operating the configuration screen, so it is recommended that even members with little knowledge of MySQL can create a high availability database infrastructure, such as creating a Master-Slave configuration. It was possible to significantly reduce the man-hours required to install and configure the DB supports in EC2 and the upgrade procedure for maintenance, and dedicate the man-hours to other design and construction work. Including a BD license, it has freed us from license management. In addition, by not needing a physical space, we are freed from the whole flow of purchasing it.

Avantages :

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.

Inconvénients :

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.

RDS is just a necessity

Avantages :

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

Inconvénients :

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

Will cost you all yourmoney.

Commentaires : Easy to setup. Very expensive. Play great with other AWS services.
The main issue is that metrics collected manually will never meet AWS metrics which are used to bill your stack. And of course AWS point of view will be much costly. Their Enterprise Support can not understand why metrics extracted from DB itself do not meet billing metrics and will endlessly redirect you to yet another expert.

Avantages :

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.

Inconvénients :

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.

Easy To Setup & Super In Security & Data Management

Commentaires : I have a very good experience with AWS RDS system.

Avantages :

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.

Inconvénients :

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