Amazon Aurora

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

Incentivized

• No need to provision storage nor IOPS for the disks
• Automatics continuos backups with the possibility to point-in-time restore in new database or backtrack to a point in time in the same database
• Increase availability by using Read Replicas and also distributing read capacity using them for queries

Incentivized

• Access to slow query, and error logs is a little cumbersome. Maybe, stream that to an AWS Elasticsearch, and provide searching out of the box (even if it means additional costs).
• Upgrade to higher versions of MySQL is a problem.
• Failovers to replica, although, they are not needed often, they can be made more seamless.

Incentivized

We have an entire infrastructure around Amazon Aurora. We ara confident on our decision, as Amazon Aurora has been able to evolve as database solution, keeping up with the latest trends, and is very well integrated on all the AWS environment. Furthermore, we use lots of services from AWS, and it's important that they all can be easily connected to improve each individual contribution.

Incentivized

Aurora is easy to deploy and operate from the AWS console, the command line, and with Infrastructure as Code tools like Cloudformation and Terraform. Integrating the endpoints into an application is easy because from the outside, the Aurora clusters look just like any other open source database. I have also seen benefit from using the instances within the cluster as distinct read and write endpoints allowing for further customization in our applications.

Incentivized

This is a cost effective software for large data handlers who find difficulty in placing their data in a confidential manner, this provides almost everything which one needs for powerful data handling softwares , even though I find it lacking in somewhat interactiveness but yet this is worth effective and efficient for working and relating datas in several tuples.

Incentivized

The support as a whole cannot be applied to just Aurora, but I must say that the response to our tickets from the AWS side was a bit anemic. Despite that, there is plenty of documentation and forum articles that should make anybody self-serviced. Again, let me stress this out - the product (in either MySQL or Postgres form) was used by many people and thus now well understood, explained and there are plenty of books and other material available. This is not the case that we encountered with NoSQL.

Incentivized

• Performance and Scalability: If an organization requires high performance and the ability to scale seamlessly to handle varying workloads, Amazon Aurora's architecture is well-suited for these needs.
• High Availability: Organizations that prioritize uptime and require automatic failover in case of AZ failures can benefit from Aurora's multi-AZ deployments.
• Ease of Management: AWS's managed service approach reduces administrative burden, allowing organizations to focus on their applications rather than database maintenance.
• Security and Compliance: Aurora's security features make it appealing to organizations that deal with sensitive data or are subject to compliance regulations.
• Compatibility: Organizations already using MySQL or PostgreSQL may find it easier to migrate to Aurora while maintaining familiarity with the database engine.

Incentivized

• After migrating to Amazon Aurora, our speed of the query, database availability, and security has increased a lot from before.
• It has an inbuilt autodetection and correction mechanism for locks in the database, which is a great asset for any team. It also enhances our database schema if it not properly structured.
• If your requirements are not clear at the moment, but you know based on the project that it is going to be a big database, then you should go with Amazon Aurora as you can scale and descale based on your needs.

Incentivized