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 was used for audit purposes. The main purpose was to audit IoT device activities performed by end user. All the information is fed into Aurora database and later use to analytics purpose what activities are performed by user. Also provide user the history of their activities.
Pros
Fetch performance is great.
Huge cluster size.
Easy to setup.
Cons
Supports InnoDB.
Does not support small RDS.
Likelihood to Recommend
It's suited where you have enterprise applications and integrate open-source databases without requiring a license.
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.
In our organization, we leverage Amazon Aurora as a critical component of our database infrastructure. Aurora is a high-performance, fully managed relational database service that provides compatibility with MySQL and PostgreSQL. Our organization uses Amazon Aurora to address several business problems and improve the efficiency and reliability of our applications.
Pros
High Availability and Fault Tolerance
High Performance
Backup and Restore feature
Cons
It has a limited support for non-SQL/PostgreSQL engines
More integration with other AWS services
Likelihood to Recommend
Amazon Aurora is very well suited in situations where the application requires high scalability and has variable and unpredictable workloads. Also, real-time analysis and reporting could be performed easily using Aurora's read replica feature. Aurora might not be a good fit for applications that rely more on other cloud-based services such as Azure since there are some issues with regards to integrations.
VU
Verified User
Employee in Information Technology (11-50 employees)
My organization uses Amazon Aurora as a database to store customer request information at scale. We also scan the database at a minimum of every 10 minutes to produce telemetry towards insights on customer usage
Pros
Scalability
Availability
Low Latency
Reasonable Cost
Cons
Schema update was challenging, but it is difficult for RDBMS in general
Likelihood to Recommend
reasonable resource for large scale with more defined schema. Users should avoid if your schema updates often
We use RDS/Amazon Aurora for some of our legacy databases that we need to retain for governmental reporting on a low frequency basis.
Pros
Scalability
Enable and disable database as needed
Database administration
Cons
Training and examples for vairoud use cases
Likelihood to Recommend
Perfect for using it workloads where you don't need your database running all day long everyday. With Aurora, you can start and stop the database on demand and save costs also.
VU
Verified User
Analyst in Information Technology (10,001+ employees)
Amazon Aurora is a relational database service offered by AWS that is designed for high performance, availability, and scalability. It's compatible with MySQL and PostgreSQL. We use both MySQL and PostgreSQL for our client databases. Depending on our needs.
Pros
High availability.
Compatibility.
High throughput.
Cons
Cost
Complexity
Likelihood to Recommend
For running a high-traffic e-commerce solution that needs to handle a massive stream of user data, products and deal with inventory updates. It works really well and you can easily add replicas to deal with i.e. load balancing.
VU
Verified User
Manager in Information Technology (51-200 employees)
A perfect and powerful database management system, I received this application from one of my colleagues, after changing from many DBs like one them is MongoDB. It has a powerful life of taking a huge amounts of data, as for long I have been working with data, I wanted a powerful and well working database system for working efficiently and effectively with my data works, well this application has a cool and powerful chain system for making relationships with various data. I loved it.
Pros
Powerful data handling
Migration facility
Cost effective application
Cons
GUI
Interaction
Likelihood to Recommend
I used many Database management systems , I have even used MySQL, but yeah this is worth of cost and have a good security system, and has a faster deliver speed, which works smoothly and efficiently. Having this I have now stopped looking for other powerful databases, this is a perfect tool for large data handlers.