We had challenges in loading huge volumes of data quickly, with reports growing beyond a certain number of millions of rows. Despite indexing and applying filters, we experienced significant latency loading the related reports. That's why we looked into using Aurora. We monitored it for about six months and tweaked the database-related parameters, but we still didn't see much improvement. So we reverted to RDS.
We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities.
It would have been helpful if they had provided some benchmarking numbers. If they had given those, we would have been able to make a more informed decision.
I have been using Amazon Aurora for six months.
It is a stable solution for a specific business case.
It is a scalable solution. We had around 35 users.
My IT person has been involved in the setup, but they said it was easy.
It is an expensive solution. It is one of the reasons we shifted to RDS.
I would check you to check your use cases and the pain points you have with the current database and then recommend you make a benchmarking comparison.
In case of any specific requirements, we can evaluate if Amazon Aurora is a good fit. Overall, I would rate the solution a seven out of ten because our objective was not fulfilled.
