We currently use Amazon Aurora across all of our clients and have recently migrated over to the V2 type. This is a great product offered by AWS as it solves a lot of the maintenance problems we would otherwise have to address, and it offers high performance and easy to configure and change parameters.
Pros
Easy to maintain
Easy to configure
Can change instance types quickly
Offers great DR options
Cons
Sometimes too many options of instance types, versions, engines, etc. so can get confusing
Likelihood to Recommend
Amazon Aurora helps us create multiple database instance with minimal effort. They are easy to maintain, easy to update or change any of their configurations. They offer great performance and many types of analytics.
VU
Verified User
Employee in Information Technology (51-200 employees)
Amazon Aurora comes with an easy to use and intuitive workflow. Our business started using Amazon Aurora to handle vast websites with huge content and file systems. We nearly have 500+ websites and all of them use Amazon Aurora. As far as I know, everything has been seamless until now. Of course there were hiccups in the between with some outages but were handled by Amazon Aurora support very well.
Pros
Concurrency
Excellent transaction time
Perfect compatibility with our sites
Ease of scaling
Cons
Little less transparent on insights
Non-availability of standalone solutions. I understand amazon aims for cloud based solution. But having a facility with standalone will look great
Lastly, of course pricing could be more dynamic so we can only pay for what we opt for
Likelihood to Recommend
We have around 500+ websites in which we are using Amazon Aurora. Most of them are huge in terms of content and transactions per minute that the databases handle. In my opinion, database encryption is well defined. It automatically upsizes, upscales the clusters that it provides per database. Once we had an outage for around 30hours. We have one website which sends around 1.5k files at a time monthly to another vendor using the database. We had an outage once and had a backlog of around 12k files not being sent to our other vendor. But, support team was readily available in shifts the whole time, they passed on notes of what and how much work is done to their colleagues and resolved the issue within 30hours (which would have easily taken 4-5 working days to understand) for us.
Amazon Aurora helps me and my organisation to collect and review in the course of analyzing the query performance. It is very persuasive in nature. Even we can write codes using three easy accessible steps and even it stores six backups eventually while writing the codes in their platform. Best thing about this Aurora is if our one of the instance has been failed this will automatically use replicas to repair them and also create new instance automatically. Even their servers are clean and their indexing capabilities are complete.
Pros
Able to work on very big databases without any interruptions.
One of the best things about Aurora is everything is hosted in the cloud with wider capabilities.
It is easy to implement, and the interface is easy to access.
Very quick instances can be connected without the loss of data.
Cons
Its interface is quite simple but repetitive in nature.
Database authentication problems can be improved.
Sometimes logical errors occur which is annoying in nature.
Likelihood to Recommend
Best thing about Aurora is that it is server less and relational database. I like it personally because of its performance which is quite impressive and its instances provide us a great experience. Also if Aurora have a script embedded in it so that we can our queries easily and there will be no requirement of other services to make the connection of the database.
VU
Verified User
Team Lead in Information Technology (1001-5000 employees)
Amazon Aurora is characterized by high availability and performance in the cloud that few tools of the same characteristics offer, the cost is initially 10GB for free, but then costs increase but the amount of capacity used, however it can be really low and its use guarantees integrated security, with regular backups and fully protected by the Amazon Aurora system. It's a fully managed system which reduces the workload and automates many daily tasks that would take a lot of time to perform manually. Another important point to take into account is that the tool automatically recovers from any failure, if one of our instances fails the system uses replicas to repair them creating new instances automatically.
Pros
Efficient monitoring of databases such as SQL, etc.
Fully automatic scaling
Fully encrypted backups
Cons
Price
Complex configurations
Technical Support could be better
Likelihood to Recommend
I think Amazon Aurora is well suited in the database arena. Amazon Aurora abstracts the connections of the database instances relationships, with a sophisticated link point mechanism, achieving more speed when processing intermediate data, which is extremely positive for large volumes of data that need to be processed quickly. In my experience, Amazon Aurora is a powerful tool when replicating data, since it manages everything in its platform with read-only queries.
Amazon Aurora just works.My experience with Amazon Aurora has been nothing but excellent. The Aurora database platform has been easy to deploy, configure, monitor, and maintain, and its performance capabilities have been able to handle any amount of workload we've thrown at it.
We used Amazon Aurora to see how to increase the efficiency and learn AWS Services. Amazon Aurora Serverless is an on-demand, autoscaling configuration for Amazon Aurora. It automatically starts up, shuts down, and scales capacity up or down based on your application's needs. You can run your database in the cloud without managing any database instances. It is easy to use and super secure. On a data base instance running with aurora encryption, data store automated backup, replicas and snapshots in the same cluster.
Pros
Integration and Deployment
Service and Support
Product Capabilities
Security
Cons
Better price
Good documentation
High availability
Likelihood to Recommend
As we just used the service to learn its basics, all systems seemed worked perfectly. I must say that overall, I’m very impressed. There are A LOT of limitations with this first release, but I believe that Amazon will do what Amazon does best, and keep iterating until this thing is rock solid.
VU
Verified User
Team Lead in Information Technology (11-50 employees)
Amazon does offer two relational database services, namely RDS and Aurora. While both very similar, there are key differences in how they persist data on disk. RDS uses EBS volumes, which are limited up to 16k concurrent IOPS. On the other hand, Aurora uses a virtual storage cluster that supports up to 80k concurrent IOPS. When dealing with large clients whose database usage might exceed the 16 concurrent IOPS threshold, Aurora was the preferred choice to ensure higher availability.
Pros
High-availability
Multi-AZ configuration
Serverless support
Crash recovery
Cons
Asynchronous replication lag
Opaque pricing
Likelihood to Recommend
Thanks to a completely different storage orchestration layer, Aurora supports far more concurrent IOPS than its counterpart, Amazon RDS, which uses individual EBS volumes. Thus, Aurora truly shines where high-performance is a major concern.
Also, Aurora supports a serverless DB cluster option, which is able to scale up/down based on application needs to save money. This is particularly suited for intermittent, unpredictable or infrequent workloads, where performance and reliability still matter.
Amazon Aurora is a great product as it provides us with a cloud-native DB that provides MySQL and Postgres compatibility while simultaneously offering all the benefits of a cloud-native product - built-in security, continuous backups, serverless computing, and high integration with other AWS Services. It is ideal for powering a number of web applications based on the LAMP or LAPP stack.
Pros
Scale
Elasticity
Durability
Security
Cons
Opinionated in the way it does things
Tight AWS integration
Likelihood to Recommend
Amazon Aurora is ideal for applications running in the well-known LAMP or LAPP stacks. It's generally great and the benefits of cloud-native elasticity, scale, security, ease to set up replicas and backups, and so on make it ideal for web-based applications. However, you need to be a tiny bit careful when using Aurora - and this is true for all products that generally emulate/simulate products. Generally, the more strange or exotic MySQL or Postgres features you are using, the more problems you're going to have with Aurora. However, as most LAMP/LAPP stacks aren't generally too exotic these tend to be edge cases that can be coded in other fashions.
Amazon Aurora is essentially a relational database as a service on AWS. Since it is cloud-based, there are many advantages to its name. First of all, it is a server-less database which essentially means that you do not need to host a physical server and provide space for it. Secondly, it is a pay-per-use model which means you only pay whenever you use it, which is a great feature if you do not make everyday queries into the database. Since it is again an amazing product from Amazon, it fits very well in the AWS ecosystem. You can use it to scale your database as per your needs, no need to buy server space and resources in advance, then not use them. It can scale and descale according to your needs.
Pros
It is a high performance and low latency database. You can also be assured of the high-availability of the database and the services hosted.
The Security provided by Amazon is again top notch because all of the data is encrypted and secured. The customers feel much more relaxed and assured when the project is using Amazon Aurora to host their services.
A big plus point for Amazon Aurora is the latest and impactful upgrades which it brings in the package. The automated up-gradation and maintenance is an outstanding feature which it provides to receive and stay up to date with the latest upgrades in the DB world.
It is compatible with MYSQL and PostgreSQL. It essentially means that the database is able to support the old data-sets and tools which were being used on those DB's. This is a great advantage because it is essentially backward compatible.
The Amazon technical team behind the development of this software is very knowledgeable and supportive as well. We told our requirements clearly and they suggested the best use of the database for us, which scenario it should be used, and which it is not a perfect fit.
Cons
I think the biggest point for a project or team to consider is the cost. Although it can scale and descale according to your requirements, still you need to be cautious and have a vision of how big your database is going to be, how complex it is going to be, and how much does latency matter. You need to factor all those decisions before going to spend extra on Amazon Aurora as compared to a simple MYSQL database.
It suffers from Clod start which is a very well known aspect of the product. But the recovery part is also not up to the mark. They need to improve on the ability to restore a copy of the backup, but mostly it is seen that the copy is corrupted or not the latest one.
It does allow us to add new nodes to the existing cluster but we need to be wary of that the new nodes are read-only nodes. All the functions of write/update will still be carried out by the master node only.
Likelihood to Recommend
Amazon Aurora is best suited for creating complex, highly available and commercial databases, in a very straightforward way. The database size should be medium to large because only then will you be able to justify the extra cost incurred for using Amazon Aurora. Another aspect is that if you are already using AWS and most of your applications and services are on the cloud, then it makes sense to use Amazon Aurora since it fits in the Amazon ecosystem really well.
VU
Verified User
Team Lead in Information Technology (10,001+ employees)